Interested to Buy Any Domain ? << Click Here >> for more details...
If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
- 8 Answers
- 11994 Views
- IBM, I also Faced
- E-Mail Answers
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
How would you begin to troubleshoot an ORA-3113 error?
What do you mean by redo log file mirroring?
Where are the settings stored for each instance in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
How to import one table back from a dump file?
What are the different types of record groups in oracle? Explain each of them
Can we convert a date to char in oracle and if so, what would be the syntax?
How to create a single index for multiple columns?
What are the tools for Oracle ?
How to divide query output into groups in oracle?
How to write numeric literals in oracle?
What is oracle instant client?
How to view the data files in the current database?
How to select some columns from a table in oracle?
How to use "while" statements in oracle?
