Database Design MCQ with Answers PDF Download – Test 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