Difference between primary key and unique key ?
Answer Posted / rajkumar tiwari
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to change system global area (sga) in oracle?
Explain the characteristics of oracle dba?
What is a static data dictionary in oracle?
What do you mean by a tablespace?
what is the difference between restoring and recovering?
What happens if variable names collide with table/column names?
What are the restrictions in a oracle read only transaction?
What is a read write transaction in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are privileges and grants?
How to convert characters to times in oracle?
What is not equal to in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.