Static Hashing Quiz Questions and Answers PDF - 185

MCQ 921: Indices that store (other than the search key) the values of some attributes are called

1. Covering indices
2. Clustered indices
3. Composite indices
4. Scrub indices

MCQ 922: The new types can be defined by the clause

1. define type
2. create type
3. select type
4. verify clause

MCQ 923: For the elimination of duplicates in a result, we use the keyword

1. No-Duplicate
2. Eliminate
3. Distinct
4. Definite

MCQ 924: In rollback work, the database state is restored to what it was before the first statement of the transaction was

1. Stored
2. Executed
3. Called
4. Used

MCQ 925: Physical data independence needs to be rewritten if a change occurs in

1. Physical schema
2. Logical schema
3. Subschema
4. Model schema