edited by
779 views

1 Answer

0 votes
0 votes

Option B) is surely wrong.

Option D) you can discard, because in the option candidate keys is there, which is a minimal set of super key.(https://dba.stackexchange.com/questions/71924/what-is-the-difference-between-primary-key-and-super-key-in-dbms)

Now in option (A) and (C), I will choose Option A, because one of the most important properties of Primary key is that it should not have NULL value. But in Option C it can not be guarantee.

Hence I will choose Option (A) as answer.

  • The primary key of a relation is a candidate key especially selected to be the key for the relation.
  • In other words, it is a choice, and there can be only one candidate key designated to be the primary key.

 

Related questions

0 votes
0 votes
1 answer
1
go_editor asked Mar 28, 2020
451 views
Aggregate functions in SQL are :GREATEST, LEAST and ABSSUM, COUNT and AVGUPPER, LOWER and LENGTHSQRT, POWER and MOD
0 votes
0 votes
1 answer
2
go_editor asked Mar 28, 2020
618 views
The end of an SQL command is denoted by :an end-of-line characteran ‘enter-key’ markerentering F4 keya semicolon (;)
2 votes
2 votes
1 answer
4