Question: A functional dependency such as X ? Y means a. X functionally determines Y. b. Y is functionally dependent on X. c. either a. or
A functional dependency such as X ? Y means
|
| a. | X functionally determines Y. |
|
| b. | Y is functionally dependent on X. |
|
| c. | either a. or b. |
|
| d. | neither a. or b. |
QUESTION B
A functional dependency such as X ? Y means
|
| a. | for each unique value Y in a relation table, there is one unique value X value associated. |
|
| b. | for each unique value X in a relation table, there is one unique value Y value associated. |
|
| c. | for each unique value Y in a relation table, there is at most one unique value X value associated. |
|
| d. | for each unique value X in a relation table, there is at most one unique value Y value associated. |
QUESTION C
A key in a relation table is
|
| a. | a proper subset of a candidate key. |
|
| b. | a proper superset of a superkey key. |
|
| c. | a minimal superkey. |
|
| d. | None a., b, and c are correct. |
QUESTION D
A transaction is a logical unit of sequential operations that must be
|
| a. | entirely completed. |
|
| b. | entirely aborted. |
|
| c. | either a. or b. |
|
| d. | neither a. nor b. |
QUESTION E
Each transaction must display
|
| a. | durability |
|
| b. | atomicity |
|
| c. | consistency |
|
| d. | isolation |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
