MCQ Bank

The SQL BETWEEN operator is used to:

Write-ahead logging (WAL) requires that a log record be written to stable storage:

A partial dependency exists when a non-key attribute depends on:

A self-join is a query in which a table is:

A subquery in SQL is:

A checkpoint in database recovery is used to:

Timestamp-based concurrency control orders transactions according to their:

A functional dependency X to Y means that:

The SQL ROLLBACK statement is used to:

The purpose of the SQL COMMIT statement is to:

A transitive dependency exists when a non-key attribute depends on:

The SQL LIKE operator is used for:

Sharding in databases refers to:

The relational algebra projection operation (pi) is used to:

A surrogate key is a primary key that is:

OLTP systems are optimized for:

A schema in a relational database describes:

The relational algebra selection operation (sigma) is used to:

A dirty read occurs when a transaction reads data that:

Physical data independence refers to the ability to change the: