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
What is the relation of a user account and a schema?
How to export several tables together?
What are the different pseudo commands? Explain in general?
How to use attributes of the implicit cursor in oracle?
What privilege is needed for a user to create tables in oracle?
How to convert characters to dates in oracle?
How to view existing locks on the database?
What is parameterized cursor in oracle?
Explain the characteristics of oracle dba?
What is the usage of merge statement?
What is a synonym? What are its various types?
How to create tables for odbc connection testing?
What is oracle database 10g express edition?
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.
What are ddl statements in oracle?