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
How do I manually uninstall oracle client?
Explain index?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Define oracle database
How many data types are supported?
Explain drop constraint oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
what is a Nested Loop join?
What to do if the startbd.bat failed to start the xe instance?
How do we get field details of a table?
Is there any function in oracle similar like group_concat of mysql?
Explain do view contain data?
What is oracle sid?
How to shutdown your 10g xe server from command line?
What is the difference between a hot backup and a cold backup in oracle?