Difference between primary key and unique key ?

Answer Posted / pawan mishra

One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to unlock the sample user account in oracle?

733


Difference between oracle's plus (+) notation and ansi join notation?

853


Can select statements be used on views in oracle?

787


Can we save images in a database and if yes, how?

823


How to start instance with a minimal initialization parameter file?

796


What is a table index in oracle?

854


What is ASM (Automatic Storage Management) in Oracle?

910


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

805


Give the advantages and disadvantages of clusters.

797


Explain database link?

878


How to call a sub procedure?

830


Why do you use stored procedures and state some of its disadvantages?

800


Can a formula column referred to columns in higher group ?

2271


How many categories of data types?

766


How to login to the server without an instance?

824