DBMS TAE-3

Which of the following properties ensures that a transaction is processed in a way that either all of its operations are executed or none are executed?

• • A) Durability

• • B) Consistency

• • C) Atomicity

• • D) Isolation

The isolation property in transactions ensures that:

• • A) Each transaction is executed independently

• • B) Each transaction affects only its own data

• • C) Each transaction leaves the database in a valid state

• • D) Each transaction appears to be the only transaction running

Which of the following ensures that the result of executing concurrent transactions is the same as if they were executed serially?

• • A) Deadlock prevention

• • B) Two-phase locking

• • C) Serializability

• • D) Cascading rollback

Which of the following is a key component of the Two-Phase Commit protocol?

• • A) Commit log

• • B) Prepared log

• • C) Commit request and acknowledgment

• • D) Deadlock detection

In a database system, a cursor is used for:

• • A) Recovering from a system failure

• • B) Serializing transaction execution

• • C) Traversing through the result set row by row

• • D) Locking rows during a transaction

Which type of index stores a sorted order of data values to improve query performance?

• • A) Hash index

• • B) Primary index

• • C) Clustered index

• • D) Non-clustered index

Which of the following is typically the first step in query processing?

• • A) Query execution

• • B) Query optimization

• • C) Parsing the query

• • D) Transaction logging

Which of the following best defines data mining?

• • A) Extracting data from external sources

• • B) Discovering patterns and knowledge from large amounts of data

• • C) Generating random data for testing purposes

• • D) Removing unwanted data from the database