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
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How can we view last record added to a table?
How do I spool to a csv formatted file using sqlplus?
What is partitioned table in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What are the ways tablespaces can be managed and how do they differ?
Explain the use of analyse option in exp command.
Why we use bulk collect in oracle?
How to estimate disk space needed for an export job?
what is reindexing?
What language does oracle use?
How to start your 10g xe server from command line?
What are the ansi data types supported in oracle?
What is a select query statement in oracle?
What are named parameters?