Difference between primary key and unique key ?
Answer Posted / ela tiku
1. Primary key does not allow Nill value whereas Unique key
allows Null values.
2. There can more than one Unique key for a table however
there is only one primary key for ant tanle.
2. Whenever a primary key is assigned by default a
Clustered Index is created whereas When a Unique key is
created a Non Index clustered index is created...
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
what is insert all statement in sql
How to create a table in a specific tablespace?
What is an oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is a sub query and what are the different types of subqueries?
What is ceil and floor in oracle?
How to drop a stored procedure in oracle?
When do you get a .pll extension in oracle? Explain its importance
How does one get the view definition of fixed views/tables?
What privilege is needed for a user to insert rows to tables in another schema?
How to check your oracle database 10g xe installation?
How to create an initialization parameter file?
What is a dynamic performance view in oracle?
What are the different editions of oracle?
Explain an exception and its types?