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 the difference between sql and t sql?

533


Will truncate release space?

514


Why do we use sql constraints? Which constraints we can use while creating database in sql?

543


What is cascade in sql?

559


Explain spool.

683






what is a trigger in mysql? : Sql dba

599


How to load data with sql*loader?

548


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

565


What are local and global variables and their differences?

580


how to dump a table to a file with 'mysqldump'? : Sql dba

546


What are the events on which a database trigger can be based?

592


What is the process of copying data from table a to table b?

595


What is a dirty read sql?

476


Explain the difference between sql and mysql.

563


What is sequence in sql?

506