NIC-NIELIT Scientist-B 2020
October 3, 2023
Environment
October 3, 2023
NIC-NIELIT Scientist-B 2020
October 3, 2023
Environment
October 3, 2023

Database-Management-System

Question 4

Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key VY?

A
VXYZ
B
VWXZ
C
VWXY
D
VWXYZ
Question 4 Explanation: 
It is given that “VY” is a primary key of the relational schema.
Any superset of “VY” is a super key. So, option (B) does not contain “Y”.
Correct Answer: B
Question 4 Explanation: 
It is given that “VY” is a primary key of the relational schema.
Any superset of “VY” is a super key. So, option (B) does not contain “Y”.

Leave a Reply

Your email address will not be published. Required fields are marked *