State Chart Diagrams Notes Questions with Answers PDF Download – Test 47

MCQ 231: The relationship between two independent data tables is classified as:

1. structural relationships
2. non-structural relationships
3. identifying relationships
4. non-identifying relationships

MCQ 232: The command in SQL which is used when any of the schema is no longer needed in relation is classified as:

1. DROP SCHEMA command
2. PICK SCHEMA command
3. DELETE SCHEMA command
4. RESTRICT SCHEMA command

MCQ 233: If the current number of records are 92, blocking factor is 20 and the number of file buckets are 5 then the file load factor is:

1. 0.85
2. 0.92
3. 0.35
4. 0.46

MCQ 234: If the common attributes of two relations are classified as join attributes then the OUTER UNION must be equal to:

1. LEFT OUTER JOIN
2. FULL OUTER JOIN
3. HALF OUTER JOIN
4. DOWNWARD JOIN

MCQ 235: The property of DBMS which ensures the execution of all the operations in transaction or none of the operation is executed is classified as:

1. isolation property
2. atomicity property
3. online execution property
4. offline execution property