Ordered Records Quiz PDF: Questions and Answers - 71

MCQ 351: The file which consists of the ordering fields for records is called

1. sequential file
2. ordered file
3. spanned file
4. both a and b

MCQ 352: The operation which violates only one constraint called referential integrity when it is performed is called

1. New operation
2. Modify operation
3. Delete operation
4. Insert operation

MCQ 353: The concept in which the shared subclass take over the relationship from multiple classes is considered as

1. joint inheritance
2. partial inheritance
3. multiple inheritance
4. independent inheritance

MCQ 354: Consider two tuples A and B, the operation whose result includes tuples that are included in both relations is classified as

1. intersection of relation A and B
2. difference of relation A and B
3. square of relation A and B
4. union of relation A and B

MCQ 355: In the CREATE TABLE command in standard query language, the referential integrity constraints is specified only after the

1. attributes are declared
2. schema is declared
3. identifier is declared
4. notifies are declared