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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!