Database Design Multiple Choice Questions (MCQ) PDF Download

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

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

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

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

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

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