SQL Quiz 6

Question 1 of 15

1. Question

Normalisation is set of rules

True
false

Question 2 of 15

2. Question

Which of the following are characteristics of normalization

eliminating data
increasing data dependency
eliminating data redundancy
eliminating data dependency

Question 3 of 15

3. Question

Which of the below are forms of normalization

First normalization form
Second normalization form
Third normalization form
fourth normalization form

Question 4 of 15

4. Question

Which of the following is a rule of first normalization form

defining data items
ensuring that there is no repeating group of data
ensuring that there is a primary key
all of the above

Question 5 of 15

5. Question

Which of the following is a rule of second normalization form

it should meet all the rules of first normalization rules
no partial dependency of any columns on primary key
both of the above options
none of the above

Question 6 of 15

6. Question

We have follow only normalization rules and we cannot add our rules to it

True
False

Question 7 of 15

7. Question

What are the constraints?

rules enforced on the objects
rules enforced on the data columns on the table/ governors
rules which by default enforced
none of the above

Question 8 of 15

8. Question

What is the functionality of not null constraint?

enforces a column to accept values
enforces a column to NOT accept NULL values
enforces a column to NOT accept values
enforces a column to accept NULL values

Question 9 of 15

9. Question

What is the functionality of default constraint?

used to set a default value for a column
used to set a default value for a row
used to set a null value for a column
used to set a null value for a row

Question 10 of 15

10. Question

What is the functionality of default constraint?

ensures that all numbers in a column are different
ensures that all values in a rows are same
ensures that all values in a column are same
ensures that all values in a column are different

Question 11 of 15

11. Question

what is the other key which guarantee the uniqueness in a column

parent key
foreign key
primary key
child key

Question 12 of 15

12. Question

Which of the following are SQL constraints?

not null
Default
Unique
Check

Question 13 of 15

13. Question

Which of the following are the properties of a primary key?

must not contain UNIQUE values, and cannot contain NULL values
must contain UNIQUE values, and cannot contain NULL values
must contain UNIQUE values, and can contain NULL values
must not contain UNIQUE values, and can contain NULL values

Question 14 of 15

14. Question

Foreign key is used for?

to separate two tables
to link two tables together
to break one table into two tables
none of the above

Question 15 of 15

15. Question

Which of the following statements is true?

child table contains foreign key and parent table contains primary key
parent table contains foreign key and parent table contains primary key
child table contains foreign key and child table contains primary key
parent table contains foreign key and child table contains primary key

Quiz Summary

Information

Results