Primary key doesnot allow null value but unique key allows null value. We

Difference between primary key and unique key ?

Question Posted / chauhan rakesh botad

77 Answers
210277 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 / chauhan rakesh botad

Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

How do I know if oracle is installed on windows?

931

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2221

How to check the server version in oracle?

1092

How to loop through data rows in the implicit cursor?

1073

Explain an exception?

995

What are the differences between char and varchar2 in oracle?

1170

What is the use of oracle?

1030

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

How do I manually create a database in oracle?

1019

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2255

How to list all user accounts in oracle?

1027

How to convert a string to a date in oracle database?

1053

How would you go about verifying the network name that the local_listener is currently using?

2049

What is an oracle and why it is used?

1150