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
How to use "startup" command to start default instance?
What is the difference between substr & instr functions?
What do you understand by a database object? Can you list a few of them?
How to drop a stored procedure in oracle?
What do you mean by redo log file mirroring?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain the use of grant option in imp command.
How to set up autotrace for a user account?
What suggestions do you have to reduce the network traffic?
What is a user role in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What happens if the update subquery returns multiple rows?
What is primefaces used for?
Why do we need integrity constraints in a database?
Explain the dml?