If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?

Answer Posted / murugananthan

NO, UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types in oracle?

548


When system tablespace is created?

601


What is the quickest way to export a table to a flat file?

568


Explain the use of indexes option in exp command.

590


How to rollback the current transaction in oracle?

536






How to call a sub procedure?

560


How to use fetch statement in a loop?

549


What are the system predefined user roles?

583


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1519


Explain temporal data types in oracle

603


Is insert autocommit in oracle?

601


Difference between hot backup vs. Cold backup?

602


List out the types of joins.

589


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1558


What is a table index in oracle?

626