Question: 15. Which schedule is serializable? 16. Cascading rollback never occurs ind a. non-serializable schedules.e b. serializable schedules. c. strict schedules. d. recoverable schedules. 17. A

15. Which schedule is serializable? 16. Cascading rollback never occurs ind a. non-serializable schedules.e b. serializable schedules. c. strict schedules. d. recoverable schedules. 17. A relation decomposition must satisfy the nonadditive join property to preventd a. insertion anomalies. b. deletion anomalies. c. modification anomalies. d. spurious tuple generation.e 18. Distributed databases may store subsets of tuples in relations, called c. shards.f d. column families. a. vieWS. hives. 19. The SQL isolation level READ COMMITTED solves the problem of a. blind write. dirty read. C. read, d. phantoms.* 20. Functional dependencies are constraints one a. a component of a tuple. b. an attribute in a relation. c. a tuple in a relation. d. a relation state, 21. Which schedule is strict? 22. Data striping in RAID increases a. reliability. b. data independence.* c. data transfer rates. d. data redundancy. 23. (A,B}->Cand B,C]-> D implies a. fB,C] ->A.e b. {B,D}->C. d. A,B)-D. 24. The Cheetah NS 10K hard disk has Mean Time Between Failure (MTBF) listed as 1.4 M hours. The disk is expected to fail in a. 2 months. b. 160 years. c. 20 years. d. 2 years
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
