Database Design MCQ with Answers PDF Download – Test 96

MCQ 476: To determine whether a relation schema is in its normal form, the common approach to use is:

1. Relationship dependencies
2. Entities dependencies
3. Functional dependencies
4. Mapping dependencies

MCQ 477: SQL includes a privilege that permits a user to declare foreign keys when creating relations, known as to be:

1. References privilege
2. Update privilege
3. Execute privilege
4. Select privilege

MCQ 478: Magnetic tape and optical-disk jukeboxes storage medias are known as:

1. Volatile storage
2. Primary storage
3. Secondary storage
4. Tertiary storage

MCQ 479: To perform the cube operation, SQL supports generalization of the:

1. group by construct
2. having by construct
3. define by construct
4. declare by construct

MCQ 480: The problem that occurs while writing new application programs to retrieve the appropriate data, is known as:

1. Difficult to access data
2. Data Inconsistency
3. Data Isolation
4. Atomicity problems