Interested to Buy Any Domain ? << Click Here >> for more details...
what is unique key?
- 14 Answers
- 26333 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
Why do you use stored procedures and state some of its disadvantages?
How to create additional tablespaces for an new database?
How a database is related to tablespaces?
How to select some rows from a table in oracle?
how to join query for one source type is oracle another source type is sql server ?
How to build data dictionary view an new database?
How can windows applications connect to oracle servers?
In what script is snap$ created? In what script is the scott/tiger schema created?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is the data type of dual table?
How to view all columns in an existing table?
Can we connect to ORACLE db using Windows Authentication?
Explain the use of owner option in exp command.
How to view the tablespaces in the current database?
1) Does oracle have any table which contain all the exceptions and it's code internally?
