primary key has two properties * uniqueness. * not null value acceptable.

waht is the difference between primary key and super key?

Question Posted / guneetinder singh

Answer Posted / guneetinder singh

primary key has two properties
* uniqueness.
* not null value acceptable.
where as super key is candidate key minus primary key
attributes.

Is This Answer Correct ?

14 Yes

32 No

Please Help Members By Posting Answers For Below Questions

What is the difference between substr and instr?

976

What is a server parameter file in oracle?

1000

How to write text literals in oracle?

1018

What are the database administrators utilities available?

970

What privilege is needed for a user to create views in oracle?

978

How to check the oracle tns settings?

989

why dont we assign not null constraint as table level constraint.

2682

What are the system predefined user roles?

981

How to retrieve the count of updated rows?

1053

What is dual table oracle?

923

How to get maxsal , minsal, ename department wise in single query

1498

What is a sub query? Describe its types?

962

How to Truncate Table in Oracle

1090

What is PL/SQL ?

1898

Briefly explain what is literal? Give an example where it can be used?

972