If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?

Answer Posted / kuldeep singh

Primary Key=Unique+Not Null+Sorting+Cluster Index
So
UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the relation of a user account and a schema?

853


How to export several tables together?

769


What are the different pseudo commands? Explain in general?

753


How to use attributes of the implicit cursor in oracle?

758


What privilege is needed for a user to create tables in oracle?

737


How to convert characters to dates in oracle?

755


How to view existing locks on the database?

760


What is parameterized cursor in oracle?

788


Explain the characteristics of oracle dba?

845


What is the usage of merge statement?

871


What is a synonym? What are its various types?

850


How to create tables for odbc connection testing?

700


What is oracle database 10g express edition?

791


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1053


What are ddl statements in oracle?

754