Difference between primary key and unique key ?
Answer Posted / anuradha
The unique column constraints permits multiple entries of
null in the column. these null values are clubbed at top of
column in order they were entered into table. this is
essential difference .
Table have more than 1 unique key which is not possible in
primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the use of record length option in exp command.
How to use "if" statements on multiple conditions?
How do you find current date and time in oracle?
What are the different editions of oracle?
What is coalesce function?
What is bulk copy or bcp in oracle?
Explain oracle data types with examples?
Explain about achiever in sql?
Explain the use of tables option in exp command.
What is using clause and give example?
What privilege is needed for a user to connect to oracle server?
What is a cognitive schema?
How to define a data source name (dsn) in odbc manager?
What is a package in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.