What is differance unique key and primary key.

Answer Posted / gourvendra singh

Unique : One or more unique key in a table,
allow only one null in the field.

Primary :Only one primary key in a table and u cannot
insert null into it.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the most restrictive isolation level? : Transact sql

532


what is datawarehouse? : Sql dba

548


What is the purpose of design view?

495


What is out parameter used for eventhough return statement can also be used in pl/sql?

559


what is the difference between nested subquery and correlated subquery?

521






Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

662


What are the benefits of pl sql?

505


Which is better stored procedure or query?

520


How do you sort in sql?

575


What is normalization in sql?

505


How can I see all tables in sql?

516


Is sql a programming?

516


how to include numeric values in sql statements? : Sql dba

532


What is the use of prepared statement?

518


What is pl sql code?

562