Database Management System Mock Test 8

10%

Question 1 of 10

1. Which of the following is TRUE for the System Variable $date$?

Can be assigned to a global variable

Can be assigned to any field only during design time

Can be assigned to any variable or field during run time

Can be assigned to a local variable

Question 1 of 10

Question 2 of 10

2. Which one of the following statements about normal forms is FALSE?

Lossless, dependency-preserving decomposition into 3NF is always possible

BCNF is stricter than 3NF

Any relation with two attributes is in BCNF

Lossless, dependency-preserving decomposition into BCNF is always possible

Question 2 of 10

Question 3 of 10

3. The storage structure which do not survive system crashes are ______

Stable storage

Non-volatile storage

Dynamic storage

Volatile storage

Question 3 of 10

Question 4 of 10

4. _______________ joins are SQL server default

Inner

None of the Mentioned

Equi

Outer

Question 4 of 10

Question 5 of 10

5. Which of the following is not the function of client?

Query optimization

Compile queries

Result formatting and presentation

Receive queries

Question 5 of 10

Question 6 of 10

6. Consider the following functional dependencies in a database.

   Date_of_Birth->Age            Age->Eligibility 
   Name->Roll_number             Roll_number->Name 
   Course_number->Course_name    Course_number->Instructor 
   (Roll_number, Course_number)->Grade

The relation (Roll_number, Name, Date_of_birth, Age) is

In second normal form but not in third normal form

In third normal form but not in BCNF

None of the mentioned

In BCNF

Question 6 of 10

Question 7 of 10

7. When two inputs that we desire to pipeline into the join are not already sorted it is the _____________ technique.

double-pipelined hash join

Buffer join

Hash join

double-pipelined join

Question 7 of 10

Question 8 of 10

8. Identify the characteristics of transactions

Atomicity

All of the mentioned

Isolation

Durability

Question 8 of 10

Question 9 of 10

9. Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

not dependency preserving and not lossless join

lossless join but not dependency preserving

dependency preserving and lossless join

dependency preserving but not lossless join

Question 9 of 10

Question 10 of 10

10. The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in

1NF only

3NF and hence also in 2NF and 1NF

2NF and hence also in 1NF

BCNF and hence also in 3NF, 2NF and 1NF

Question 10 of 10