If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / prashant t.
No.
It will same for doesn't allow null and duplicate values.
But, Primary key constrained applied Cluster index on that
column and unique key constraint non clustered index on
that column. that is the major differece still be there.
Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to update values in a table in oracle?
How do I manually uninstall oracle client?
How to set up autotrace for a user account?
What is a nested table?
What is the minimum client footprint required to connect c# to an oracle database?
What is user managed backup in Oracle?
How to retrieve data from an explicit cursor?
What are the advantages of oracle 12c?
interview questions with answer for cts
Can sub procedure/function be called recursively?
State and explain about oracle instance?
Is a rollback possible to any savepoint?
How do I limit the number of oracle database connections generated by weblogic server?