sql online test - Quiz Questions (Page 1 of 2)
This quiz contains 20 questions.
Question 1: What does SQL stand for?
- Structured Query Language (Correct Answer)
- Standard Query Level
- Simple Question Language
- System Quick Language
Question 2: Which SQL clause is used to filter results?
- WHERE (Correct Answer)
- ORDER BY
- GROUP BY
- HAVING
Question 3: Which command is used to remove a table in SQL?
- DROP TABLE (Correct Answer)
- DELETE TABLE
- REMOVE TABLE
- CLEAR TABLE
Question 4: What command is used to add new data in SQL?
- INSERT INTO (Correct Answer)
- ADD DATA
- PUSH TO
- PLACE INTO
Question 5: How do you update data in a table?
- UPDATE (Correct Answer)
- SET
- MODIFY
- CHANGE
Question 6: Which SQL function returns the number of records?
- COUNT() (Correct Answer)
- SUM()
- AVG()
- MAX()
Question 7: What does the 'JOIN' keyword do in SQL?
- Combines rows from two tables (Correct Answer)
- Removes duplicates
- Creates a new table
- Adds columns
Question 8: Which keyword is used to sort query results?
- ORDER BY (Correct Answer)
- GROUP BY
- SORT
- FILTER BY
Question 9: How can you prevent duplicate values in SELECT?
- DISTINCT (Correct Answer)
- UNIQUE
- FILTER
- LIMIT
Question 10: Which SQL statement is used to extract data?
- SELECT (Correct Answer)
- RETRIEVE
- EXTRACT
- GET
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!
