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 keyword pl sql?

732


How delete all data from all tables in sql?

687


What is the difference between microsoft sql and mysql?

709


What is the difference between pl and sql?

737


What is cursor and its types?

716






Can we call a function containing dml statements in a select query?

724


What are % type and % rowtype?

778


Can you have a foreign key without a primary key?

681


Is sql dba a good career? : SQL DBA

712


Differentiate between syntax and runtime errors.

846


What are inner and outer joins examples of both?

691


What is recursive join in sql?

752


how tsql statements can be written and submitted to the database engine? : Transact sql

714


what are the different index configurations a table can have? : Sql dba

750


What are the types of operators available in sql?

770