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:
• What is a primary key in a relational database?
• Which of the following is a property of a relational database?
• Which normal form removes partial dependency?
• What is referential integrity?
• Which SQL command is used to remove a table from the database?
• Which SQL command is used to retrieve data from a table?
• Which type of relationship exists when a record in one table can relate to multiple records in another table, and vice versa?
• Which constraint ensures that no duplicate values exist in a column?
• Which type of join returns only matching records from both tables?
• Which SQL clause is used to group rows based on one or more columns?
• Which of the following is a type of database index?
• Which of the following is a transaction property ensuring all steps are completed or none?
• In a relational database, what is a foreign key?