MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following normal forms does not exist? |
| A. | BCNF |
| B. | PJNF |
| C. | 5NF |
| D. | None of the mentioned |
| Answer» E. | |
| 2. |
State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency. |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» E. | |
| 3. |
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies |
| A. | Star |
| B. | Closure |
| C. | Derivation |
| D. | Evolution |
| Answer» C. Derivation | |
| 4. |
STATE_TRUE_OR_FALSE:_IF_A_RELATIONAL_SCHEMA_IS_IN_________NF_AND_A_IS_A_SUBSET_OF_R_AND_B_IS_ALSO_A_SUBSET_OF_R_THEN_IT_IS_THAT_A_IS_A_SUPERKEY_IS_A_TRIVIAL_MULTI_VALUES_DEPENDENCY.?$ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» E. | |
| 5. |
Which of the following normal forms does not exist?$ |
| A. | BCNF |
| B. | PJNF |
| C. | 5NF |
| D. | None of the mentioned |
| Answer» E. | |
| 6. |
The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencie? |
| A. | Star |
| B. | Closure |
| C. | Derivation |
| D. | Evolution |
| Answer» C. Derivation | |
| 7. |
Functional dependencies are sometimes referred to as ________ |
| A. | Equality generating dependencies |
| B. | Tuple generating dependencies |
| C. | Multi-purpose dependencies |
| D. | None of the mentioned |
| Answer» B. Tuple generating dependencies | |
| 8. |
Multi valued dependencies are also called as __________ |
| A. | Equality generating dependencies |
| B. | Tuple generating dependencies |
| C. | Multi-purpose dependencies |
| D. | None of the mentioned |
| Answer» C. Multi-purpose dependencies | |
| 9. |
State true or false: Most current database systems do not support constraints on materialized view |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
State true or false: SQL specifies a way of mentioning functional dependencies |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
Which of the following is desirable in a database design with functional dependencies? |
| A. | BCNF |
| B. | Losslessness |
| C. | Dependency preservation |
| D. | All of the mentioned |
| Answer» B. Losslessness | |
| 12. |
The 3NF decomposition algorithm is also called as _______ |
| A. | 3NF normal algorithm |
| B. | 3NF synthesis algorithm |
| C. | 3NF generator |
| D. | Functional dependence algorithm |
| Answer» C. 3NF generator | |
| 13. |
What does the BCNF decomposition algorithm do? |
| A. | States a method to decompose a relation satisfying BCNF |
| B. | States a method for joining two relations satisfying BCNF |
| C. | States a method to decompose a relational schema such that there are no multiple occurrences |
| D. | None of the mentioned |
| Answer» B. States a method for joining two relations satisfying BCNF | |