Difference between primary key and unique key ?

Answer Posted / niraj pratap singh

primary key has no null values whereas unique accepts null
values and in a table only one primary key is declared
whereas unique key is multiple in a table.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of indexes option in imp command.

566


What is an anonymous block?

625


Explain joins in oracle?

561


How remove data files before opening a database?

564


How to find out what oracle odbc drivers are installed?

577






Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1666


How to connect to oracle using service name instead of sid?

553


How to unlock the sample user account in oracle?

558


Can we convert a date to char in oracle and if so, what would be the syntax?

550


Explain oracle 12c new features for developers?

540


What is an oracle?

579


How to assign query results to variables?

592


Explain a synonym?

606


what are the default admin accounts in Oracle 10g ?

508


Explain what are the uses of rollback segment?

586