Practice IT DBMS Questions and Answers

• What does normalization in DBMS achieve?
• Which of the following is a DML command?
• Which type of join returns rows when there is a match in both tables?
• ACID properties in DBMS ensure:
• Which of the following is a non-relational database?
• A view in SQL is:
• Which of these ensures referential integrity?
• Which of the following is NOT a type of database model?
• Which normal form removes transitive dependency?
• Which operation is NOT part of relational algebra?
• Indexing in DBMS improves:
• Deadlock occurs when:
• Which isolation level allows dirty reads?
• Which concurrency anomaly is specific to phantom reads?
• Multiversion Concurrency Control (MVCC) ensures:
• Bitmap indexes are most efficient when:
• Shadow paging in recovery eliminates the need for:
• Which deadlock prevention scheme allows older transactions to preempt younger ones?
• Query optimization heuristics often include:
• Distributed transactions typically use which protocol for atomicity?
• Phantom Reads occur when:
• MVCC (Multi-Version Concurrency Control) ensures:
• Bitmap indexes are most efficient when:
• Shadow Paging avoids:
• Wait-Die and Wound-Wait are strategies for:
• Query optimization heuristic that “pushes selections down” improves:
• Distributed 2-Phase Commit (2PC) can suffer from: