Practice IT DBMS Questions and Answers

• 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?
• Which normal form ensures that every determinant is a candidate key?
• Which of the following schedules is serializable?
• In two-phase locking, a transaction releases its locks:
• Indexes improve query performance but can degrade performance of:
• In relational algebra, the operation that combines tuples from two relations using common attribute values is:
• Which type of attack exploits software bugs to execute arbitrary code on a system?
• HTTPS ensures which of the following?
• Which layer of the OSI model handles logical addressing and routing?
• Which of the following is a type of phishing attack?
• The command to test reachability of a host in Linux is:
• Which of the following is true about ACID properties in DBMS?
• Which SQL statement is used to remove all rows from a table without logging individual row deletions?
• In a relational database, which relationship allows multiple records in one table to be associated with multiple records in another table?
• In DBMS, which scheduling method ensures serializability of transactions?
• Which normal form ensures no partial dependency of non-prime attributes on a candidate key?
• Which of the following is true about the primary key in a relational database?
• Which of the following is a weak entity in a database?
• Which DBMS command is used to remove a table completely along with its structure?
• Which normal form eliminates transitive dependency?
• Which type of DBMS model organizes data in tables with rows and columns?