If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / bhakti
ya thats true.i.e.,in case of Primary Key we can have
parent to child relationship if that is say foreign key in
another table.In case of unique and not null we cant achive
dis.
But while inserting data into one table both will have no
difference.
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is meant by a deadlock situation?
What happens to the current transaction if the session is killed?
Explain cascading triggers.
How to delete a column in an existing table in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
How to save query output to a local file?
Explain a segment?
Explain table?
what is the dual table in oracle?
Point out the difference between user tables and data dictionary?
What do you understand by a database object? Can you list a few of them?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain the use of rows option in exp command.
What is raw datatype in oracle?
How to convert csv to table in oracle?