SQL Quiz

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

Leave a Comment

Copy link
Powered by Social Snap