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
How to define a data field as not null?
What is the difference between sharding and partitioning?
how the indexes are stored in the Oracle Database?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Can group functions be used in the order by clause in oracle?
Why do you use stored procedures and state some of its disadvantages?
How to use attributes of the implicit cursor in oracle?
How to define an anonymous procedure with variables?
Describe an oracle table?
Explain the use of online redo log files in oracle.
Is java required for oracle client?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain alias?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Explain the difference between a procedure and a function? What do you understand by those terms?