MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
State true or false: Redundancy is desired in a relational schema |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
State true or false: Composite attributes have non-atomic domains. |
| A. | True |
| B. | False |
| Answer» C. | |
| 3. |
If all the domains are atomic then the relational schema is in ________ normal form |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» B. 2 | |
| 4. |
A domain whose elements are indivisible is called as ______ |
| A. | Unique domain |
| B. | Proxy domain |
| C. | Atomic domain |
| D. | Multiple domain |
| Answer» D. Multiple domain | |
| 5. |
If the decomposition is able to represent all the facts about the relation then such a decomposition is called as? |
| A. | Lossless decomposition |
| B. | Lossy decomposition |
| C. | Insecure decomposition |
| D. | Secure decomposition |
| Answer» B. Lossy decomposition | |
| 6. |
If the decomposition is unable to represent certain important facts about the relation, then such a decomposition is called as? |
| A. | Lossless decomposition |
| B. | Lossy decomposition |
| C. | Insecure decomposition |
| D. | Secure decomposition |
| Answer» C. Insecure decomposition | |
| 7. |
The dependency rules specified by the database designer are known as _______ |
| A. | Designer dependencies |
| B. | Database rules |
| C. | Functional dependencies |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 8. |
Which of the following is not a feature of a good relational design? |
| A. | Specifying primary keys |
| B. | Specifying foreign keys |
| C. | Preserving integrity constraints |
| D. | Allowing redundancy of attributes |
| Answer» E. | |