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

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

what is the scenario where you take the database to NoArchivelog mode?

1826


What is a table index in oracle?

624


How many memory layers are in the oracle shared pool?

634


What are the differences between primary key and unique key?

507


What happens to the current transaction if the session is killed?

528






How to convert characters to times in oracle?

588


How to define a data field as not null?

628


Difference between the “verify” and “feedback” command?

761


Explain how are indexes update?

617


Explain drop constraint oracle?

589


What happens if the update subquery returns multiple rows?

597


How to start instance with a minimal initialization parameter file?

525


What is connection pool in oracle?

549


How to use "while" statements in oracle?

729


11. Display the client number and name and the client number and name of the person who referred that client.

1915