Determine whether the following statements are true or false a)Once a transaction is committed, it cannot be rolled back. Answer: b) An index file is always larger than the original database file because the index file needs to store an additional pointer to each record. Answer: c) Sparse indices facilitate faster search operations comparing to the dense indices.
- Determine whether the following statements are true or false
- a)Once a transaction is committed, it cannot be rolled back.
Answer:
b) An index file is always larger than the original
Answer:
c) Sparse indices facilitate faster search operations comparing to the dense indices.
Answer:
d) In a B+-tree, it always requires reorganizing the entire index file to maintain performance.
Answer:
e) Atomicity of transactions means that the transaction must be executed serially.
Answer:
f) Both committed and aborted transactions leave the database in consistent state.
Answer:
g) A serial schedule always satisfies isolation requirement.
Answer:
h) If P is the primary key of schema R, we must have P ® R.
Answer:
I) A failed transaction must be aborted.
Answer:
j) If the precedence graph of a schedule is acyclic, the schedule is serializable.
Answer:
Step by step
Solved in 2 steps
