sql online test - Quiz Questions (Page 2 of 2)
This quiz contains 20 questions.
Question 11: What is the function of 'HAVING' in SQL?
- Filters grouped rows (Correct Answer)
- Joins tables
- Orders rows
- Counts elements
Question 12: Which clause is used to combine result sets?
- UNION (Correct Answer)
- JOIN
- COMBINE
- MERGE
Question 13: How do you eliminate a specific row in a table?
- DELETE (Correct Answer)
- DROP
- CLEAR
- REMOVE
Question 14: What is used to uniquely identify a record?
- Primary Key (Correct Answer)
- Foreign Key
- Index
- Alias
Question 15: What keyword is used to give a temporary name?
- AS (Correct Answer)
- IS
- LIKE
- WITH
Question 16: How do you retrieve all columns from a table?
- SELECT * (Correct Answer)
- SHOW ALL
- GET ALL
- FIND *
Question 17: Which SQL keyword is used to rename a table?
- ALTER TABLE (Correct Answer)
- RENAME TABLE
- CHANGE TABLE
- MODIFY TABLE
Question 18: What is used to group results in SQL?
- GROUP BY (Correct Answer)
- BUNDLE
- COLLECT
- SORT BY
Question 19: What symbol denotes a wildcard in SQL?
Question 20: Which clause specifies conditions in an UPDATE?
- WHERE (Correct Answer)
- SET
- WITH
- HAVING
Try our SQL online test to check your skills with database work and writing queries. This simple quiz helps you practice real tasks in data management, making it a handy tool for IT certification and database jobs in India. Enjoy testing your knowledge and improving your practical skills with clear, step-by-step questions. Good luck and have fun learning!
