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

Answer Posted / ananta pilaka

Primary key is only one and it is clustered index.

Unique key cannot be referred as foreign key contraint of
another table.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a stored procedure in oracle?

571


What are the restrictions on external table columns?

545


Is oracle the best database?

516


How to convert characters to numbers in oracle?

588


How to turn on or off recycle bin for the instance?

605






How to set up autotrace for a user account?

590


How many types of table in Oracle?

612


Differentiate between translate and replace?

625


How to establish administrator authentication to the server?

556


Name the various constraints used in oracle?

560


How to define a sub function?

658


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1612


What is a Garbage Collection? and what is full recursive Garbage collection?

2384


What are the common oracle dba tasks?

617


Explain oracle insert into command?

622