One table may have more than one Unique Key Constraint columns, but should

Difference between primary key and unique key ?

Question Posted / pawan mishra

77 Answers
208057 Views
Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
E-Mail Answers

Answer Posted / pawan mishra

One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to start instance with a minimal initialization parameter file?

1000

What is the difference between postgresql and oracle?

995

Can we store images in oracle database?

954

What is private procedure oracle?

962

What is sequence?

1021

Explain the truncate in oracle?

921

Explain the types of exception?

1094

Explain table?

1073

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2062

How to import one table back from a dump file?

981

What are operators in oracle?

1018

How to create a new view in oracle?

1023

How to join two tables in a single query using oracle?

942

What is redo log?

1012

How can we force the database to use the user specified rollback segment?

1087