MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 22 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To specify the foreign keys in relations referencing temporal data we need to specify _______ |
| A. | The time interval |
| B. | The Boolean value for the working |
| C. | The integer corresponding to the relation number |
| D. | None of the mentioned |
| Answer» B. The Boolean value for the working | |
| 2. |
Which of the following is the time of temporal data that record when a fact was recorded in a database? |
| A. | Transaction time |
| B. | Valid time |
| C. | Enter time |
| D. | Exit time |
| Answer» B. Valid time | |
| 3. |
State true or false: Overlapping time intervals cannot be prevented |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
The data that have a time interval associated with them during which they are valid are called as ________ |
| A. | Timed data |
| B. | Temporal data |
| C. | Model data |
| D. | Clocked data |
| Answer» C. Model data | |
| 5. |
Which of the following is not a process of generating a good relational schema? |
| A. | Converting ER diagrams to relational schema |
| B. | Decomposing the relational schema while satisfying functional dependencies |
| C. | Joining multiple relations together to form a single relation containing all the attributes |
| D. | A design of relations which is then tested and modified to satisfy given normal forms |
| Answer» D. A design of relations which is then tested and modified to satisfy given normal forms | |
| 6. |
WHICH_OF_THE_FOLLOWING_IS_THE_TIME_OF_TEMPORAL_DATA_THAT_RECORD_WHEN_A_FACT_WAS_RECORDED_IN_A_DATABASE??$ |
| A. | Transaction time |
| B. | Valid time |
| C. | Enter time |
| D. | Exit time |
| Answer» B. Valid time | |
| 7. |
WHICH_FORMS_ARE_BASED_ON_THE_CONCEPT_OF_FUNCTIONAL_DEPENDENCY:?$ |
| A. | 1NF |
| B. | 2NF |
| C. | 3NF |
| D. | 4NF |
| Answer» D. 4NF | |
| 8. |
To_specify_the_foreign_keys_in_relations_referencing_temporal_data_we_need_to_specify________$ |
| A. | The time interval |
| B. | The Boolean value for the working |
| C. | The integer corresponding to the relation number |
| D. | None of the mentioned |
| Answer» B. The Boolean value for the working | |
| 9. |
State true or false: Overlapping time intervals cannot be prevente? |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
Functional dependencies that have a time associated with them during which they are valid are called as________ |
| A. | Timed functional dependencies |
| B. | Clocked functional dependencies |
| C. | Temporal functional dependencies |
| D. | Modeled functional dependencies |
| Answer» D. Modeled functional dependencies | |
| 11. |
Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups: |
| A. | 1NF |
| B. | 2NF |
| C. | 3NF |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 12. |
The value of the data at a particular time is called as? |
| A. | Instance |
| B. | Picture |
| C. | Snapshot |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 13. |
Which is a bottom-up approach to database design that design by examining the relationship between attributes: |
| A. | Functional dependency |
| B. | Database modeling |
| C. | Normalization |
| D. | Decomposition |
| Answer» D. Decomposition | |
| 14. |
The data that have a time interval associated with them during which they are valid are called as ________ |
| A. | Timed data |
| B. | Temporal data |
| C. | Model data |
| D. | Clocked data |
| Answer» C. Model data | |
| 15. |
Functional Dependencies are the types of constraints that are based on______ |
| A. | Key |
| B. | Key revisited |
| C. | Superset key |
| D. | None of the mentioned |
| Answer» B. Key revisited | |
| 16. |
State true or false: Crosstabs are not desirable in a database design |
| A. | True |
| B. | False |
| Answer» B. False | |
| 17. |
Which-one ofthe following statements about normal forms is FALSE? |
| A. | BCNF is stricter than 3 NF |
| B. | Lossless, dependency -preserving decomposition into 3 NF is always possible |
| C. | Loss less, dependency – preserving decomposition into BCNF is always possible |
| D. | Any relation with two attributes is BCNF |
| Answer» D. Any relation with two attributes is BCNF | |
| 18. |
The process of making a normalized schema unnormalized is called as _________ |
| A. | Unnormalization |
| B. | Denormalization |
| C. | Renormalization |
| D. | Annormalization |
| Answer» C. Renormalization | |
| 19. |
Tables in second normal form (2NF): |
| A. | Eliminate all hidden dependencies |
| B. | Eliminate the possibility of a insertion anomalies |
| C. | Have a composite key |
| D. | Have all non key fields depend on the whole primary key |
| Answer» B. Eliminate the possibility of a insertion anomalies | |
| 20. |
What is unique role assumption? |
| A. | The attribute name has a unique meaning in the database |
| B. | The attributes are all unique |
| C. | No two tuples have even a single same value in a relation |
| D. | None of the mentioned |
| Answer» B. The attributes are all unique | |
| 21. |
A table on the many side of a one to many or many to many relationship must: |
| A. | Be in Second Normal Form (2NF) |
| B. | Be in Third Normal Form (3NF) |
| C. | Have a single attribute key |
| D. | Have a composite key |
| Answer» E. | |
| 22. |
In the __________ normal form, a composite attribute is converted to individual attributes. |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» B. Second | |