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
Can you drop an index associated with a unique or primary key constraint?
How can we force the database to use the user specified rollback segment?
Whether any commands are used for months calculation? If so, what are they?
What is set operator oracle?
How to change system global area (sga) in oracle?
How to define a record variable to store a table row?
Explain what are the advantages of views?
various types of hints and their usage
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
1) Does oracle have any table which contain all the exceptions and it's code internally?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Explain the use of rows option in imp command.
What are the differences between interval year to month and interval day to second?