Difference between primary key and unique key ?
Answer Posted / pralhad
Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 63 Yes | 47 No |
Post New Answer View All Answers
Explain the use of compress option in exp command.
What are the limitations of check constraint?
Explain an exception?
What is the difference between sharding and replication?
How to change system global area (sga) in oracle?
Is a rollback possible to any savepoint?
How to define an anonymous procedure with variables?
interview questions with answer for cts
How to calculate date and time differences in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to commit the current transaction in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How do I connect to oracle?
master table and child table performances and comparisons in Oracle ?