question archive For each of the following statements, indicate whether it is true or false
Subject:Computer SciencePrice:3.86 Bought8
For each of the following statements, indicate whether it is true or false.
1) In ER, a relationship type can have no key.
2) In SQL, using the command AS will change the database.
3) Any relation in BCNF is also in 2NF.
4) A primary key must consist of only one attribute.
5) A lossless and dependency-preserving decomposition into 3NF is not always possible.
6) Both using OS file system to manage disk space and keeping track of free blocks can improve disk access.
7) SQL cannot control sequences of database operations.
8) Frequent checkpoints can reduce the amount of data lost if a disk is destroyed.
9) The time-stamp ordering method never produces deadlocks.
10) As a concurrency control method, optimistic control is a good option if there is a lot of interaction between transactions.
Purchased 8 times