what are the advantages of primary key over unique+notnull

Answer Posted / nitesh

PRIMARY KEY CREATED WITH INDEXES WHICH IS NOT HAPPEN WITH
UNIQUE AND NOT NULL

Is This Answer Correct ?    8 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any restriction on the use of union in embedded sql?

687


What is raid? How does it help storage of databases?

610


What is rowid in sql?

514


What is the difference between numeric and autonumber?

502


Which one is better sql or oracle?

506






Differentiate between pl/sql and sql?

624


How do you create an update query?

528


What is mutating sql table?

615


Is and as keyword in pl sql?

517


How do I make my sql query run faster?

472


What is rowtype?

573


What is a dynamic query?

578


How do you delete a table?

546


What is a full join sql?

599


What is crud stand for?

570