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
What are the different types of record groups in oracle? Explain each of them
Explain the use of constraints option in exp command.
What is a user role in oracle?
What are the uses of Database Trigger ?
What is the difference between a user and a schema in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a cognitive schema?
Explain the dml?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What are the various oracle database objects?
How to use existing values in update statements using oracle?
How to create lov dynamically at runtime & attach to text field?
How to set a transaction to be read only in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.