Home > Databases > Quizzes > DBMS (Database Management System) Practice Test
DBMS (Database Management System) Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 79% • Most missed: “Which of the following command is used to delete a table in SQL?”
DBMS (Database Management System) Practice Test
Time left 00:00
25 Questions

1. Network models are complicated by physical keys, but the Relation model is __________?
2. The method of access which uses key transformation is known as __________.
3. __________ is a virtual table that draws its data from the result of an SQL SELECT statement.
4. In a relational model, relations are termed as _______ .
5. To delete a particular column in a relation the command used is:
6. A logical schema __________.
7. The relational model uses some unfamiliar terminology. A tuple is a equivalent to __________.
8. An advantage of the database approach is __________.
9. 'AS' clause is used in SQL for _______?
10. Cartesian product in relational algebra is _______?
11. A data manipulation command that combines the records from one or more tables is called __________?
12. __________ function divides one numeric expression by another and returns the remainder.
13. In an E-R diagram attributes are represented by _______ .
14. The way a particular application views the data from the database that the application uses is a __________.
15. In a Hierarchical model records are organized as _______?
16. Relational calculus is a _______?
17. In case of entity integrity, the primary key may be _______ .
18. The __________ operator is used to compare a value to a list of literals values that have been specified.
19. A primary key if combined with a foreign key creates __________.
20. DML is provided for _______?
21. Which of the following command is used to delete a table in SQL?
22. Which one of the following is not true for a View:
23. In the relational modes, cardinality is termed as:
24. Consider Join of a relation R with a relation S. If R has m tuples and S has n tuples, then maximum and minimum sizes of the Joinrespectively are
25. Hierarchical model is also called __________.

⚡ 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.