Ordered Records Notes Questions with Answers PDF Download - 71

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

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

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

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

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