if that so then your referential entrigity will be spoil foreign key will

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

Question Posted / amit

8 Answers
11877 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / amit

if that so then your referential entrigity will be spoil
foreign key will not be recognised means data will not true.

Is This Answer Correct ?

5 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the types of joins used in writing subqueries?

941

What is the difference between hot backup and cold backup in oracle?

956

How to create a new table in your schema?

1028

How to use fetch statement in a loop?

971

Explain a segment?

1018

What is recovery manager in Oracle?

992

What are the database administrators utilities available?

971

What is a sub query? What are its various types?

1078

what is the difference between restoring and recovering?

962

What is translate in oracle?

1049

Briefly explain what is literal? Give an example where it can be used?

973

Explain parameter file in oracle.

970

Explain about the analyze command in oracle?

996

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1861

What is oracle used for?

968