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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How oracle handles dead locks?
Give syntax for SQL and ORACLE joins.
What is index in Oracle?
Whats the benefit of dbms_stats over analyze?
What is the difference between I and G in Oracle?
Explain the use of indexes option in exp command.
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.
What is coalesce function?
What is the order of defining local variables and sub procedures/functions?
What is the difference between 10g OEM and 11g OEM?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the common oracle dba tasks?
How to get a create statement for an existing table?