DBMS Concepts UGC

Question 1

Which of the following key constraints is required for the functioning of the foreign keys in the context of a relational database?

• Unique Key
• Primary Key
• Candidate Key
• Check key

Question 2

In relational database, if a relation R is in BCNF, then which of the following is true about relation R?

• R is in 4NF
• R is not in 1NF
• R is in 2NF and not in 3NF
• R is in 2NF and 3NF

Question 3

In relational database management, which of the following is/are property/properties of candidate key? P: Uniqueness Q: Irreducibility

• P only
• Q only
• Both P and Q
• Neither P nor Q