Database Design Multiple Choice Questions (MCQ) PDF - 156

MCQ 776: An approach is to design schemas that is in an appropriate

1. Integrated form
2. Induced form
3. Deduced form
4. Normal form

MCQ 777: The number of error(s) in the following query are:
select avg (salary) like avg salary
from instructor
where dept name=Comp. Sci.;

1. 2
2. 3
3. 4
4. 5

MCQ 778: Cascading rollbacks can be avoided by

1. Strict two-phase locking protocol
2. Rigorous two-phase locking protocol
3. Deadlock two-phase locking protocol
4. Lock-point two-phase locking protocol

MCQ 779: The E-R model allows attributes that are

1. Multi-valued
2. Multi-layers
3. Multi-levels
4. Multi-relation

MCQ 780: Machines with a large number of processors are said to be of

1. Diverse-granularity parallelism
2. Dense-granularity parallelism
3. Fine-granularity parallelism
4. Coarse-granularity parallelism