what are the advantages of primary key over unique+notnull

Answer Posted / smita

A Foriegn key can refer to the primary key.
A Foriegn key can refer to the unique key also .

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sql profiler?

770


Can we use rowid as primary key?

738


how to drop an existing table in mysql? : Sql dba

763


what are properties of a transaction? : Sql dba

760


what is user defined functions? : Sql dba

744






column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6599


What does seeding a database mean?

691


What is cost in sql execution plan?

687


Is the primary key an index?

765


What is sql data?

713


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1083


How do I partition in sql?

706


Can we insert in sql function?

774


Enlist the advantages of sql.

747


What is a pl/sql block?

760