DBMS QUIZ

Which normalization form is based on the transitive dependency?

• 1NF

• 2NF

• 3NF

• 4NF

Which of the following is a command of  DDL

• SELECT

• ALTER

• DROP

• DELETE

Which of the following is known as minimal super key?

• Primary key

• Foreign key

• Candidate key

• None

Which of the following is not a SQL command?

• WHERE

• SELECT

• ORDER BY

• DELETE

Which of the following is the property of transaction that protects data from system failure?

• Atomicity

• Isolation

• Durability

• Consistency

How many levels are there in architecture of database?

• 2

• 3

• 4

• 5

Primary key can be?

• NULL

• NOT NULL

• 1

• BOTH NULL AND NOT NULL

Rectangles in ER diagram represents?

• Tables

• Attributes

• Entity sets

• Tuples

Select the correct advantages of view.

• Derived columns

• Data security

• Hiding of complex queries

• All of the above

Select the correct command to find the number of values in a column.

• COUNT

• TOTAL

• SUM

• ADD