Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT
AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A
COLUMN ?
INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN.
WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE
ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS
NULL VALUES.
- 3 Answers
- 7036 Views
- I also Faced
- E-Mail Answers
Answer Posted / manikanta
By default primary key maintain clusterd index,All the
records are stored in stored order.By takeing this
advantage query will be execute fast.
Unique maintain nonclusted index,All the records are not in
stored order.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain database link?
Can we store pictures in the database and if so, how it can be done?
how can we store any pdf file in oracle
How to grant create session privilege to a user in oracle?
what is reindexing?
List out the components of logical database structure of oracle database.
How many types of synonyms in Oracle?
How many anonymous blocks can be defined?
How to create an oracle testing table?
How to best split csv strings in oracle 9i?
What is a relational database management system?
How to create tables for odbc connection testing?
What is connection pooling in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Can we insert data in view oracle?
