Single Level Order Indexes Multiple Choice Questions (MCQ) PDF - 4

MCQ 16: The primary indexes, secondary indexes and cluster indexes are all types of

1. ordered indexes
2. unordered indexes
3. linear indexes
4. relative search indexes

MCQ 17: Considering the binary relationships, the possible cardinality ratios are

1. one : one
2. 1 : N
3. M : N
4. all of above

MCQ 18: In Standard Query Language, the types of DROP commands include

1. RESTRICT command
2. FOREIGN key command
3. CASCADE command
4. both a and c

MCQ 19: The attributes that can be arranged into hierarchy are called

1. composite attributes
2. atomic attributes
3. derived attributes
4. simple attributes

MCQ 20: The storage media that is operated directly from computer's central processing unit is considered as

1. primary storage
2. secondary storage
3. tertiary storage
4. all of above