Primery Key = (Unique key - NULL values) One table may have more than o

Difference between primary key and unique key ?

Question Posted / satya

77 Answers
210425 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 / satya

Primery Key = (Unique key - NULL values)

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

Any comment? please shoot a mail.

Is This Answer Correct ?

329 Yes

90 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the purpose of save points in oracle database?

1120

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1114

What is SQL Tuning Advisor in Oracle?

1183

What do you mean by merge in oracle and how can we merge two tables?

1051

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

What is an oracle user account?

994

How to create a table interactively?

1097

What is an oracle tablespace?

1045

What are group functions in oracle?

1043

What is oracle thin client?

1027

Explain the features of oracle?

1046

How to write a query with an inner join in oracle?

1042

How to write date and time literals in oracle?

1002

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4523

What are the restrictions in a oracle read only transaction?

1038