If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / bhakti
ya thats true.i.e.,in case of Primary Key we can have
parent to child relationship if that is say foreign key in
another table.In case of unique and not null we cant achive
dis.
But while inserting data into one table both will have no
difference.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is meant by recursive hints in oracle?
How to select an oracle system id (sid)?
What are the uses of a database trigger?
What are the tools for Oracle ?
What is an oracle table?
How do we represent comments in oracle?
Explain implicit cursor.
How to view existing locks on the database?
Explain self joins in oracle?
Why do you create or replace procedures rather that drop and recreate.
What is a nvl function?
Is it possible to split the print reviewer into more than one region ?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Are truncate and delete commands same? If so why?
what is difference between sql plus and sql*plus? (not sql and sql plus).