Dependencies and Normal Forms Quiz PDF: Questions and Answers - 59

MCQ 291: The template conclusion is a set of tuples that must be included in the relations in the template dependency called

1. constraint generating templates
2. tuple generating templates
3. schema generating templates
4. relation filtering template

MCQ 292: While designing the database management system, if the performance is the main issue to be considered then the DBMS designed is called

1. special purpose DBMS
2. general purpose DBMS
3. non-classical DBMS
4. classical DBMS

MCQ 293: The entity types, super classes and subclasses are classified as

1. ER schema overlapping
2. ER schema functions
3. ER schema objects
4. EER schema constructs

MCQ 294: In multilevel indexes, the blocking factor is also called

1. fan out of multilevel index
2. fan in of multilevel index
3. distinct value of multilevel index
4. ordered field of multilevel index

MCQ 295: The kind of field with which the record searching is done is classified as

1. sorting field
2. relative field
3. linear field
4. ordering field