Integrity Constraints Notes Questions with Answers PDF Download – Test 359

MCQ 1791: The term which means checking immediately by default,but can be deferred when desired, makes the constraint alternatively:

1. Non-deferrable
2. Initially deferred
3. Deferrable
4. Previously deferred

MCQ 1792: The organization in which records are placed anywhere in the file, where there is free space for the record is referred to as:

1. Hashing file organization
2. Sequential file organization
3. Heap file organization
4. Clustered file organization

MCQ 1793: The database designer uses the resulting system-specific database schema in the:

1. Logical-design phase
2. Physical-design phase
3. Contextual-design phase
4. Virtual-design phase

MCQ 1794: The command that deletes not only all tuples of r, but also the schema for r.:

1. Drop command
2. Delete command
3. Eliminate command
4. Abort command

MCQ 1795: The JDBC standard defines an:

1. Application process interface
2. Application program interface
3. Application product interface
4. Application project interface