Primary key is only one and it is clustered index. Unique key cannot be

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

Question Posted / ananta pilaka

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

Please Help Members By Posting Answers For Below Questions

How to define an anonymous procedure without variables?

1107

How to pass parameters to procedures?

1034

Explain the use of analyse option in exp command.

1128

What is memory advisor in Oracle?

1077

What is a connect identifier?

1040

How to select an oracle system id (sid)?

1064

How do we get field detail of a table?

1081

Whats the benefit of dbms_stats over analyze?

2003

How to change program global area (pga) in oracle?

1095

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

What are the attributes of the cursor?

1004

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1046

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

How to load data through external tables?

1136