State Chart Diagrams Quiz Questions with Answers PDF Download - 47

The relationship between two independent data tables is classified as

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

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

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

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

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