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 to bring a tablespace online?
How to display employee records who gets more salary than the average salary in the department?
What is a dead lock in oracle?
What is an oracle transaction?
Explain the use of consistent option in exp command.
What is format trigger?
Explain what are the type of synonyms?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is the difference between Delete, Truncate and Drop in Oracle?
What are the uses of a database trigger?
What is a table in oracle?
Can we insert data in view oracle?
Explain the use of owner option in exp command.
Describe an oracle table?