Difference between primary key and unique key ?
Answer Posted / satya
Primery Key = (Unique key - NULL values)
One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.
Any comment? please shoot a mail.
| Is This Answer Correct ? | 329 Yes | 90 No |
Post New Answer View All Answers
What is the difference between sharding and partitioning?
How to load data through external tables?
What are temporal data types in oracle?
Explain a segment?
 What are the oracle DML commands possible through an update strategy?
What is blob data type in oracle?
What is coalesce function?
What happens to the current transaction if a ddl statement is executed?
How to count duplicated values in a column in oracle?
What is a database table in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is the fastest query method to fetch data from the table?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What are the different pseudo commands? Explain in general?
What is a trigger and what are its types in oracle?