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
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is data file?
Is there a combination of "like" and "in" in sql?
Which environment variables are absolutely critical in order to run the OUI?
Can you drop an index associated with a unique or primary key constraint?
How to do paging with oracle?
What is a connect identifier?
What happens to indexes if you drop a table?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Explain overloading. Can functions be overloaded?
How to list all user accounts in oracle?
What are the differences between number and binary_float in oracle?
candidate key is subset of super key but not vice-verse explain
How to convert times to characters in oracle?
In oracle there is column command, how will you explain that?