If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / dibya tara shakya
It will same but in case of primary key we can create the
master child relationship with other child table as foreign
key but in case of unique and not null we cannot.
another major difference is that Primary key constraint
applied Cluster index on that
column and unique key constraint non clustered index on
that column.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to connect the oracle server as sysdba?
what are bitmap indexes? How does they work?
What is Library Cache in Oracle?
What are the different windows events activated at runtime ?
What is the use of aggregate functions in oracle?
How to start your 10g xe server?
What are the uses of a database trigger?
Name the three major set of files on disk that compose a database in Oracle?
How to pass a parameter to a cursor in oracle?
How do I recompile a procedure in oracle?
Explain the use of consistent option in exp command.
How to turn on or off recycle bin for the instance?
What is blob datatype?
What are operators in oracle?