there is only one primary key for one table; it can not acept null values;

Difference between primary key and unique key ?

Question Posted / guna

77 Answers
212224 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 / guna

there is only one primary key for one table;
it can not acept null values;
any no uniquefor a table;
it can accept null values;
which the rows are unique value;

Is This Answer Correct ?

9 Yes

18 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the uses of synonyms?

1183

What are the limitations of check constraint?

1071

What is coalesce function?

1136

How to store only time; not date and time?

1065

What is a trace file and how is it created in oracle?

1137

What are the differences between number and binary_float in oracle?

1140

What is a data lock in oracle?

1178

if you ctreate table identity

2426

How to experiment a data lock in oracle?

1106

What are the attributes of the cursor?

1057

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3244

How to use "if" statements on multiple conditions?

1215

What is connection pool in oracle?

1031

Give the constructs of a package, function or a procedure.

1093

What are the benefits of ordbms?

1136