what is unique key?
- 14 Answers
- 22850 Views
- Amazon, Cap Gemini, Infosys, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gyana ranjan behera
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is private procedure oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to login to the server without an instance?
What is a cursor variable?
What is different types of joins?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to get the Installed Oracle Version Information ?
What is oracle in java?
Please explain drop constraint oracle?
What are the different windows events activated at runtime ?
How do I call oracle stored procedures that take no parameters?
How to rollback the current transaction in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is system tablespace?
