Difference between primary key and unique key ?
Answer Posted / nithin
1. There can be more than one unique key in a row or table
but there can be only one primary key in a row or table.
2. Primary key does not accept NULL values but Unique key
accepts even NULL values.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to start instance with a minimal initialization parameter file?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to add a new column to an existing table in oracle?
What is different types of joins?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What do you mean by cdb and pdb in oracle 12c?
What are set operators?
Explain an exception and its types?
Who developed oracle & when?
What is set verify off in oracle?
What is concurrency in oracle?
What are the ansi data types supported in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is the difference between PFILE and SPFILE in Oracle?
Can a formula column be obtained through a select statement ?