MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
THE_TERM_FOR_INFORMATION_THAT_DESCRIBES_WHAT_TYPE_OF_DATA_IS_AVAILABLE_IN_A_DATABASE_IS:?$ |
| A. | Data dictionary |
| B. | data repository |
| C. | Index data |
| D. | Metadata |
| Answer» B. data repository | |
| 2. |
A_data_type_that_creates_unique_numbers_for_key_columns_in_Microsoft_Access_is:$ |
| A. | Autonumber |
| B. | Boolean |
| C. | Sequential key |
| D. | Sequential number |
| Answer» B. Boolean | |
| 3. |
If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed? |
| A. | DKNF |
| B. | BCNF |
| C. | Fourth |
| D. | Third |
| Answer» E. | |
| 4. |
If every non-key attribute is functionally dependent primary key, then the relation will be in |
| A. | First normal form |
| B. | Second normal form |
| C. | Third form |
| D. | Fourth normal form |
| Answer» C. Third form | |
| 5. |
If a relation is in BCNF, then it is also in |
| A. | 1 NF |
| B. | 2 NF |
| C. | 3 NF |
| D. | All of the mentioned |
| Answer» C. 3 NF | |
| 6. |
Which one is based on multi-valued dependency: |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» E. | |
| 7. |
Identify the composite attributes |
| A. | Salary |
| B. | Credits |
| C. | Section_id |
| D. | None of the mentioned |
| Answer» E. | |
| 8. |
A domain is ______ if elements of the domain are considered to be indivisible units. |
| A. | Atomic |
| B. | Subatomic |
| C. | Substructure |
| D. | Subset |
| Answer» B. Subatomic | |