Database Design Multiple Choice Questions with Answers – PDF Download

MCQ 1: The designer can review the schema to ensure it meets all the functional requirements, at the stage:

1. Conceptual design
2. Execution design
3. Controlling design
4. Initial Planning

MCQ 2: In the database design, to characterize fully the data needs of the prospective database users, in the:

1. Initial phase
2. Execution phase
3. Maintenance phase
4. Closure phase

MCQ 3: The problem of being unable to represent some information, can be solved by introducing:

1. Pointers
2. Null values
3. 0 value
4. Null pointer

MCQ 4: Generating a set of relation schemas that allows storing information without unnecessary redundancy, is goal of:

1. Assertions
2. Associations
3. Normalization
4. Integration

MCQ 5: Database systems are designed to manage:

1. Small bodies of information
2. Large bodies of information
3. Plain bodies of knowledge
4. Complex bodies of knowledge