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

Answer Posted / samir kumar sahoo.

no. bcoz we can insert null values in the column which
contains the combination of constraints as
UNIQUE+ NOT NULL

but in case of primary key we can't use null values in that
primary key column

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a table in oracle?

718


What are the different types of database objects?

734


query optmization techniques and quwry analyser+projects+ppts

2147


How to export several tables together?

789


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2727


How to invoke the original export import utilities?

695


How to lock and unlock a user account in oracle?

847


How to update values in a table in oracle?

758


What is the order of defining local variables and sub procedures/functions?

825


What is the difference between online and offline backups?

743


what is meant by magic query

1945


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

750


How to write date and time literals in oracle?

738


Describe varray?

836


How to set up autotrace for a user account?

792