Home > Databases > Quizzes > Database Management System (DBMS) Practice Test: SQL
Database Management System (DBMS) Practice Test: SQL
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 55% • Most missed: “What does the ALTER TABLE clause do?”
Database Management System (DBMS) Practice Test: SQL
Time left 00:00
25 Questions

1. Which SQL function is used to count the number of rows in a SQL query?
2. Which of the following statements is true concerning subqueries?
3. The UPDATE SQL clause can _____________
4. Which of the following is not a DDL command?
5. Which of the following is not a SQL Server INFORMATION_SCHEMA view?
6. What is SCHEMABINDING a VIEW?
7. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
8. Which of the following is a correlated subquery?
9. SQL query to find all the cities whose humidity is 95.
10. Find all the tuples having a temperature greater than ‘Paris’.
11. What is the meaning of LIKE ‘%0%0%’?
12. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?
13. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
14. What type of join is needed when you wish to include rows that do not have matching values?
15. ________________ is not a category of SQL command.
16. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?
17. Which of the following SQL clauses is used to DELETE tuples from a database table?
18. What is the purpose of the SQL AS clause?
19. What type of join is needed when you wish to return rows that do have matching values?
20. Dynamic Management View is a type of ___________
21. Which SQL statement is used to return only different values?
22. Which of the following statement is true?
23. What is a view?
24. Which of the following are TCL commands?
25. ___________removes all rows from a table without logging the individual row deletions.

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL 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 | OSHA Basics Quiz | 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.