Ordered Records Notes Questions with Answers PDF Download – Test 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