a primary key can be a unique key but a unique key may be or may not be a

Is primary key = unique key,not null?
If yes,please explain
IF No,please explain

Question Posted / chanchal

8 Answers
18033 Views
Genpact, I also Faced
E-Mail Answers

Answer Posted / chanchal

a primary key can be a unique key but a unique key
may be or may not be a primary key bcoz primary key cant be
NULL but Unique Key may.
in a table more than one unique key but only one primary key

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the dual table in oracle?

987

Explain the difference between replace() and translate() functions in oracle?

1026

How to initialize variables with default values?

1227

What is an oracle database table?

1004

What is the data type of dual table?

989

What is a database table in oracle?

1011

What is a data lock in oracle?

1096

What is an oracle table?

981

What is background process in Oracle?

1097

Use of an integrity constraint is better to validate data. Explain

1029

Explain alias?

1121

What is the difference between primary key and unique key and foreign key in oracle?

968

How to define a variable of a specific record type?

1061

What is an oracle and why it is used?

1140

How can we find out the duplicate values in an oracle table?

1036