SQL Quiz | Software Testing Material

Welcome to your SQL Quiz. This quiz consists of 30 multiple-choice questions. There is no negative marking in this. Click on NEXT button to Start this Java Quiz.

1. With SQL, how do you select all the columns from a table named "Employees"?
2. Which of the following is not a Data Definition Language (DDL) statement?
3. Which SQL statement is used to remove rows from a table?
4. Which statement is correct
5. The table rows are also known as
6. The result of a SELECT statement can contain duplicate rows
7. Which SQL statement is used to modify the existing records in a table?
8. Which SQL keyword is used to sort the data in ascending or descending order, based on one or more columns
9. The UNION operator is used to
10. Which SQL statement is used to delete complete data from an existing table?
11. Which SQL statement is used to return only different values?
12. Which SQL keyword you use to merge two tables based on a matching column?
13. Which SQL statement is used to extract data from a database?
14. Which function returns the difference between two dates
15. The MIN() function returns the smallest value of the selected column and The MAX() function returns the largest value of the selected column
16. What does SQL stand for?
17. The OR operator displays a record if any of the conditions separated by OR is TRUE
18. Which SQL statement is used to delete complete data from an existing table & table structure from the database?
19. The AND operator displays a record if all the conditions separated by AND are TRUE
20. Which SQL statement is used to insert new rows of data to a table in a database
21. Which of the following is not a RDBMS?
22. The table columns are also known as
23. With SQL, how do you select a column named "FirstName" from a table named "Employees"?
24. What is the keyword you use to group the result by a column's values?
25. Which type of database management system represents relations using tables?
26. Which of the following keyword you use to modify the existing value in an UPDATE query?
27. Subqueries can be nested multiple times
28. Which of the following is not a part of SQL
29. A NULL value is different than a zero value or a field that contains spaces
30. Which of the following is not an SQL Aggregate function

SQL Quiz – You can test your knowledge with this SQL Quiz. We have created this SQL Quiz Online Test to help you master SQL.

Knowledge Base:

 
SQL Quiz

Rajkumar SM is a founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and blogger & youtuber by choice. He has an extensive experience in the field of Software Testing. He writes here about Software Testing which includes both Manual and Automation Testing. He loves to be with his wife and cute little kid 'Freedom'.

Leave a Comment

Share via
Copy link
Powered by Social Snap