Integrity Constraints Quiz PDF: Questions and Answers - 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