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


Please Help Members By Posting Answers For Below Questions

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2141


20. Using a set operator, display the client number of all clients who have never placed an order.

1996


How to update values in a table in oracle?

780


How do I manually uninstall oracle client?

783


How to set up autotrace for a user account?

807


What is a nested table?

842


What is the minimum client footprint required to connect c# to an oracle database?

799


What is user managed backup in Oracle?

852


How to retrieve data from an explicit cursor?

817


What are the advantages of oracle 12c?

863


interview questions with answer for cts

2349


Can sub procedure/function be called recursively?

772


State and explain about oracle instance?

763


Is a rollback possible to any savepoint?

780


How do I limit the number of oracle database connections generated by weblogic server?

832