Home > Class 12 Informatics Practices > Quizzes > CBSE Class 12 SQL Practice Test
CBSE Class 12 SQL Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 62% • Most missed: “By default, ORDER BY clause displays records in ______”
CBSE Class 12 SQL Practice Test
Time left 00:00
25 Questions

1. Write a query to display details of all those employees whose name starts with ‘M’.
2. Which of the following statement will display all the database of the system?
3. When we create a table, we can specify that a column should not contain a Null value by using _________ constraint.
4. _____________ command is used to open the existing database.
5. Identify the odd one out
6. SQL provides a __________ operator that can be used with the WHERE clause to search for a specified pattern in a column.
7. Write a query to display details of all those employees whose name ends with ‘L’.
8. ______ clause is used to display data in an ordered form with respect to a specified column.
9. MySQL commands are case sensitive.
10. Which clause fetch a group of rows on the basis of common values in a column?
11. Which of the following is not the valid data type of MySQL?
12. Which of the following is not an example of DBMS?
13. The horizontal lines of table are called ______
14. By default, ORDER BY clause displays records in ______
15. ________ functions returns the smallest value from the specified column.
16. Consider the following query:
Delete from employee;

The above command will ______________
17. Which of the following wild character (use with Like) represent multiple characters?
18. Aggregate functions are also called ________
19. It is mandatory to define constraints for each attribute of a table.
20. Consider the following column of table “sports”.
Category
1
2
3
2
1
4
1

Write the query for the following

Display the total number of different types of category from table sports"."
21. Write a query to display details of all employees who have been given a salary (i.e., salary is not null) and works in the department D1.
22. Write command to show all the records of table “document”
23. We can update values for more than one column using the UPDATE statement.
24. Which of the following store data in the form of rows and columns?
25. Name the command used to change the existing data of the table.

⚡ Recently practiced quizzes in this topic
Live quiz activity
CBSE Class 12 IP Data Visualization Practice Test CBSE Class 12 Introduction to Computer Networks Practice Test CBSE Class 12 Societal Impacts Practice Test SQL Grouping Records and Table Joins (MCQs) Web Application Development (MCQs) Extensible Markup Language (MCQs)
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.