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

What are the differences between lov and list item?

754


Why cursor variables are easier to use than cursors?

774


Differentiate between translate and replace?

798


What is connection pool in oracle?

737


What is an anonymous block?

883


Explain an index?

857


What is meant by an index?

800


What are the advantages of oracle?

752


what is Single Byte Overhead...?

2271


Difference between hot backup vs. Cold backup?

769


What is a partition in oracle?

774


How will you write a query to get a 5th rank student from a table student_report?

1646


What is a sub query and what are the different types of subqueries?

860


How many types of tables supported by oracle?

782


What is a dynamic performance view in oracle?

781