Home > Databases > Quizzes > DBMS (Database Management Systems) MCQs
DBMS (Database Management Systems) MCQs
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 25% • Most missed: “Which of the following is not a property of transactions?”
DBMS (Database Management Systems) MCQs
Time left 00:00
25 Questions

1. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
2. According to the levels of abstraction, the schema at the intermediate level is called
3. If an entity can belong to only one lower level entity then the constraint is
4. Cascading rollback is avoided in all protocol except
5. Which one is true statement :
6. What is a disjoint less constraint?
7. Which normal form is considered adequate for normal relational database design?
8. What are the desirable properties of a decomposition
9. Which of the following is not a recovery technique?
10. Which is the best file organization when data is frequently added or deleted from a file?
11. The data models defined by ANSI/SPARC architecture are
12. A transaction is in _______ state after the final statement has been executed.
13. Relational Algebra is
14. Which of the following is not a consequence of concurrent operations?
15. Which of the following addressing modes permits relocation without any change over in the code?
16. The normalization was first proposed by ______ .
17. A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
18. Precedence graphs help to find a
19. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
20. The keyword to eliminate duplicate rows from the query result in SQL is
21. Which of the following relational algebraic operations is not from set theory?
22. The drawback of shadow paging technique are
23. Which of the following aggregate functions does not ignore nulls in its results?
24. The operation which is not considered a basic operation of relational algebra is
25. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition

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