MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 15 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which one of the following conditions, can the relational table for R be merged with that of A? |
| A. | Relationship R is one-to-many and the participation of A in R is total. |
| B. | Relationship is one-to-many and the participation of A in R is partial. |
| C. | Relationship R is many-to-one and the participation of A in R is total. |
| D. | Relationship R is many-to-one and the participation of A in R is partial. |
| Answer» D. Relationship R is many-to-one and the participation of A in R is partial. | |
| 2. |
In E-R model, Y is the dominant entity and X is the subordinate entity. |
| A. | If X is deleted then Y is also deleted. |
| B. | If Y is deleted then X is also deleted. |
| C. | If Y is deleted then X is not deleted. |
| D. | none of the above |
| Answer» C. If Y is deleted then X is not deleted. | |
| 3. |
Consider the following Entity Relationship Diagram (ERD) Which of the following possible relations will not hold if the above ERD is mapped into a relation model ? |
| A. | Person (NID, Name) |
| B. | Qualification (NID, ExamID, QualifiedDate) |
| C. | Exam (ExamID, NID, ExamName) |
| D. | Exam (ExamID, ExamName) |
| Answer» D. Exam (ExamID, ExamName) | |
| 4. |
An aggregation association is drawn using which symbol? |
| A. | A line which loops back on to the same table |
| B. | A small open diamond at the end of a line connecting two tables |
| C. | A small closed diamond at the end of a line connecting two tables |
| D. | A small closed triangle at the end of a line connecting two tables |
| Answer» C. A small closed diamond at the end of a line connecting two tables | |
| 5. |
In ER diagrams weak entity set is represented by _____ and weak entity set has always ______ participation with respect to its identifying relationship. |
| A. | Double lined Diamond, Partial |
| B. | Double lined Box, Total |
| C. | Dashed lined Box, Total |
| D. | Dashed lined Diamond, Partial |
| Answer» C. Dashed lined Box, Total | |
| 6. |
Considering binary relationships, possible cardinality ratios are: |
| A. | one ∶ one |
| B. | 1 ∶ N |
| C. | M ∶ N |
| D. | All the options |
| Answer» E. | |
| 7. |
A double ellipse represents _________ attribute in ER-diagram. |
| A. | Multi-valued |
| B. | Composite |
| C. | Derived |
| D. | Complex |
| Answer» B. Composite | |
| 8. |
In an Entity-Relationship (ER) model, suppose |
| A. | Every entity in E1 is associated with exactly one entity in E2. |
| B. | Some entity in E1 is associated with more than one entity in E2. |
| C. | Every entity in E2 is associated with exactly one entity in E1. |
| D. | Every entity in E2 is associated with at most one entity in E1. |
| Answer» B. Some entity in E1 is associated with more than one entity in E2. | |
| 9. |
Conceptual level, internal level and External level are three components of the three-level RDBMS architecture. which of the following is not of the conceptual level? |
| A. | Entities, attributes, relationships |
| B. | Semantic information |
| C. | Constraints |
| D. | Storage dependent details |
| Answer» E. | |
| 10. |
______ mean unification of several otherwise distinct data files with data redundancy among those files partially or wholly eliminated. |
| A. | Unique |
| B. | Integrated database |
| C. | Inconsistent |
| D. | Conversion |
| Answer» C. Inconsistent | |
| 11. |
Consider a weak entity set in DBMS. Cardinality ratio 'strong entity set : weak entity set' in their binary identifying relationship is: |
| A. | One to one |
| B. | One to many |
| C. | Many to one |
| D. | Many to Many |
| Answer» C. Many to one | |
| 12. |
An entity set that does not have sufficient attributes to form a key is termed as: |
| A. | Strong entity set |
| B. | Simple entity set |
| C. | Weak entity set |
| D. | Primary entity set |
| Answer» D. Primary entity set | |
| 13. |
Consider the following statements regarding database normal forms:1. Any relation with two attributes is BCNF.2. Lossless, dependency - preserving decomposition into BCNF is always possible.3. Lossless, dependency - preserving decomposition into 3NF is always possible.4. BCNF is stricter than 3NF.Which of the above statements are correct? |
| A. | 1, 2 and 3 |
| B. | 1, 3 and 4 |
| C. | 1, 2 and 4 |
| D. | 2, 3 and 4 |
| Answer» C. 1, 2 and 4 | |
| 14. |
Consider the results of a medical experiment that aims to predict whether someone is going to develop myopia based on some physical measurements and heredity. In this case, the input dataset consists of the person’s medical characteristics and the target variable is binary: 1 for those who are likely to develop myopia and 0 for those who aren’t. This can be best classified as |
| A. | Regression |
| B. | Decision Tree |
| C. | Clustering |
| D. | Association Rules |
| Answer» C. Clustering | |
| 15. |
_____ model and its variations are frequently used for the conceptual design of database applications, and many database design tools employ its concepts. |
| A. | Functional analysis |
| B. | Transaction implementation |
| C. | Application program design |
| D. | Entity Relationship |
| Answer» E. | |