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 set operators?
List the types of joins used in writing subqueries?
Explain what are synonyms used for?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is a schema in oracle?
How to drop an index in oracle?
What is a package ? What are the advantages of package ?
What is a database schema in oracle?
What is meant by joins?
What are the built-in functions used for sending Parameters to forms ?
What are the different types of database objects?
How to create a stored program unit?
Is oracle a programming language?
Explain the use of indexes option in exp command.
How to insert multiple rows with one insert statement in oracle?