Difference between primary key and unique key ?
Answer Posted / niranjan dhungia
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
Is This Answer Correct ? | 1017 Yes | 126 No |
Post New Answer View All Answers
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
State some uses of redo log files?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between translate and replace in oracle?
How to insert a new row into a table in oracle?
What is oracle used for?
How do I limit the number of rows returned by an oracle query after ordering?
How to assign a tablespace to a users in oracle?
What are the types of trigger in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is user managed backup in Oracle?
Explain the use of grant option in exp command.
What is max rowid in oracle?
What is system tablespace?
what is port in oracle? how is it related to database application.