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

564


Write a unique difference between a function and a stored procedure.

534


Explain mutating table error.

649


what are all the different normalizations? : Sql dba

511


Explain what is a field in a database and record in a database?

611






how to get a list of indexes of an existing table? : Sql dba

518


What do you mean by stored procedures? How do we use it?

527


What is an inner join sql?

549


What is normalization? How many normalization forms are there?

554


How would you convert date into julian date format?

594


Can we insert in view in sql?

568


How do sql triggers work?

556


what is a table in a database ? : Sql dba

546


Why are cursors used?

585


what is not null constraint? : Sql dba

553