Interested to Buy Any Domain ? << Click Here >> for more details...
what is unique key?
- 14 Answers
- 26828 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 parameterized cursor in oracle?
What is the oracle implicit cursor?
What happens if you use a wrong connect identifier?
What is the string concatenation operator in oracle?
What are ddl statements in oracle?
Calculate difference between 2 date / times in oracle sql?
What privilege is needed for a user to create tables in oracle?
Why cursor variables are easier to use than cursors?
Explain what does a control file contain?
Use of an integrity constraint is better to validate data. Explain
What is archive log in Oracle?
How to view the tablespaces in the current database?
What happens if the imported table already exists?
How to omit columns with default values in insert statement in oracle?
Is oracle a programming language?
