1. What is Index ? Mid A. Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction B. a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage C. two transactions each waiting on a lock the other holds, resolved by the database aborting one D. an index containing every column a query needs, avoiding a table lookup
2. Which term means: "a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage"? Mid A. Deadlock B. Index C. Isolation levels D. Covering index
3. Which statement is correct? Mid A. Index — a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage B. Index — Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency C. Index — an index containing every column a query needs, avoiding a table lookup D. Index — Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction
4. What is Composite index ? Senior A. two transactions each waiting on a lock the other holds, resolved by the database aborting one B. a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage C. an index on multiple columns, usable left-to-right by the leftmost-prefix rule D. Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction
5. Which term means: "an index on multiple columns, usable left-to-right by the leftmost-prefix rule"? Senior A. Composite index B. Covering index C. ACID D. Index
6. Which statement is correct? Senior A. Composite index — an index containing every column a query needs, avoiding a table lookup B. Composite index — a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage C. Composite index — an index on multiple columns, usable left-to-right by the leftmost-prefix rule D. Composite index — Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction
7. What is Covering index ? Senior A. two transactions each waiting on a lock the other holds, resolved by the database aborting one B. an index on multiple columns, usable left-to-right by the leftmost-prefix rule C. an index containing every column a query needs, avoiding a table lookup D. Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction
8. Which term means: "an index containing every column a query needs, avoiding a table lookup"? Senior A. Covering index B. Deadlock C. Index D. Composite index
9. Which statement is correct? Senior A. Covering index — Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency B. Covering index — an index on multiple columns, usable left-to-right by the leftmost-prefix rule C. Covering index — an index containing every column a query needs, avoiding a table lookup D. Covering index — Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction
10. What is ACID ? Junior A. two transactions each waiting on a lock the other holds, resolved by the database aborting one B. a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage C. Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction D. an index on multiple columns, usable left-to-right by the leftmost-prefix rule
11. Which term means: "Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction"? Junior A. Deadlock B. Isolation levels C. Composite index D. ACID
12. Which statement is correct? Junior A. ACID — an index on multiple columns, usable left-to-right by the leftmost-prefix rule B. ACID — Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency C. ACID — two transactions each waiting on a lock the other holds, resolved by the database aborting one D. ACID — Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction
13. What is Isolation levels ? Mid A. Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction B. Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency C. two transactions each waiting on a lock the other holds, resolved by the database aborting one D. a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage
14. Which term means: "Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency"? Mid A. Isolation levels B. Covering index C. Composite index D. Deadlock
15. Which statement is correct? Mid A. Isolation levels — an index containing every column a query needs, avoiding a table lookup B. Isolation levels — Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction C. Isolation levels — Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency D. Isolation levels — a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage
16. What is Deadlock ? Senior A. a structure (usually a B-tree) that speeds lookups at the cost of slower writes and extra storage B. two transactions each waiting on a lock the other holds, resolved by the database aborting one C. an index on multiple columns, usable left-to-right by the leftmost-prefix rule D. an index containing every column a query needs, avoiding a table lookup
17. Which term means: "two transactions each waiting on a lock the other holds, resolved by the database aborting one"? Senior A. Deadlock B. ACID C. Composite index D. Covering index
18. Which statement is correct? Senior A. Deadlock — Read Uncommitted, Read Committed, Repeatable Read and Serializable — trading consistency for concurrency B. Deadlock — two transactions each waiting on a lock the other holds, resolved by the database aborting one C. Deadlock — Atomicity, Consistency, Isolation, Durability — the guarantees of a reliable transaction D. Deadlock — an index containing every column a query needs, avoiding a table lookup