MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 11 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
RELATION_DEPT_YEAR(DEPT_NAME,_TOTAL_INST_2007,_TOTAL_INST_2008,_TOTAL_INST_2009)._HERE_THE_ONLY_FUNCTIONAL_DEPENDENCIES_ARE_FROM_DEPT_NAME_TO_THE_OTHER_ATTRIBUTES._THIS_RELATION_IS_IN?$ |
| A. | Fourth NF |
| B. | BCNF |
| C. | Third NF |
| D. | Second NF |
| Answer» C. Third NF | |
| 2. |
Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.$ |
| A. | Cross-tabs |
| B. | Snapshot |
| C. | Both Cross-tabs and Snapshot |
| D. | All of the mentioned |
| Answer» B. Snapshot | |
| 3. |
Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.$ |
| A. | Instance |
| B. | Snapshot |
| C. | Both Instance and Snapshot |
| D. | All of the mentioned |
| Answer» C. Both Instance and Snapshot | |
| 4. |
In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ? |
| A. | Dept name, year->size |
| B. | Year->size |
| C. | Dept name->size |
| D. | Size->year |
| Answer» B. Year->size | |
| 5. |
Designers use which of the following to tune the performance of systems to support time-critical operations? |
| A. | Denormalization |
| B. | Redundant optimization |
| C. | Optimization |
| D. | Realization |
| Answer» B. Redundant optimization | |
| 6. |
What is the best way to represent the attributes in a large database? |
| A. | Relational-and |
| B. | Concatenation |
| C. | Dot representation |
| D. | All of the mentioned |
| Answer» C. Dot representation | |
| 7. |
Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by |
| A. | Unique-role assumption |
| B. | Unique-key assignment |
| C. | Role intergral assignment |
| D. | None of the mentioned |
| Answer» B. Unique-key assignment | |
| 8. |
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | All of the mentioned |
| Answer» C. A one-to-many relationship set | |
| 9. |
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | All of the mentioned |
| Answer» B. A multivalued attribute of an entity set | |
| 10. |
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | Both A many-to-many relationship set and A multivalued attribute of an entity set |
| Answer» E. | |
| 11. |
_____________ can help us detect poor E-R design. |
| A. | Database Design Process |
| B. | E-R Design Process |
| C. | Relational scheme |
| D. | Functional dependencies |
| Answer» E. | |