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


Please Help Members By Posting Answers For Below Questions

How to create a temporary table in oracle?

683


Explain the use of parfile option in exp command.

513


Please explain drop constraint oracle?

623


What do you understand by database schema and what does it hold?

588


Why do you create or replace procedures rather that drop and recreate.

540






How do I manually uninstall oracle client?

512


How do we get field details of a table?

541


What is a nvl function? How can it be used?

553


What is oracle used for?

528


How to create an initialization parameter file?

535


Explain joins in oracle?

557


What are the attributes of the cursor?

549


Explain the use of indexes option in exp command.

588


How to retrieve values from data fields in record variables?

559


How to add a new column to an existing table in oracle?

576