sql practice questions - Quiz Questions (Page 2 of 2)
This quiz contains 20 questions.
Question 11: Which operator is used for pattern matching?
- LIKE (Correct Answer)
- MATCH
- SIMILAR
- PATTERN
Question 12: How do you sort results in descending order?
- ORDER BY column ASC
- ORDER BY column DESC (Correct Answer)
- SORT BY column DESC
- ARRANGE BY column DOWN
Question 13: What is used to group records with the same values?
- ORDER BY
- GROUP BY (Correct Answer)
- SORT BY
- FILTER BY
Question 14: Which operator checks for null values?
- IS EMPTY
- IS NULL (Correct Answer)
- IS BLANK
- IS VOID
Question 15: What is a foreign key?
- A field linking to another table's primary key (Correct Answer)
- A unique identifier
- A type of SQL join
- A command to delete data
Question 16: How do you combine rows from different tables?
- JOIN (Correct Answer)
- CONNECT
- MERGE
- LINK
Question 17: Which function counts the number of rows?
- COUNTER()
- COUNT() (Correct Answer)
- ROW_COUNT()
- NUM()
Question 18: What does the 'INSERT' statement do?
- Deletes data from a table
- Adds data to a table (Correct Answer)
- Changes table structure
- Selects specific data
Question 19: How do you update data in a table?
- INSERT INTO
- ALTER TABLE
- MODIFY RECORDS
- UPDATE table_name SET (Correct Answer)
Question 20: What command removes all table records?
- EMPTY TABLE
- DELETE FROM table_name
- TRUNCATE TABLE table_name (Correct Answer)
- EMPTY RECORDS
Test your SQL skills with this quiz made for everyone, from beginners to experienced users. The questions range from writing basic queries to handling advanced database design and schema management. Practice how to manipulate data and build strong databases in a simple and friendly way. This quiz is perfect for anyone in India looking to improve their SQL abilities for jobs in database management and analytics.
