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

Answer Posted / yuva

No. It can be at table level, but this will get failed
while referencing in another table.

Is This Answer Correct ?    13 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is redo log?

628


How many types of database triggers exist?

581


Can a formula column be obtained through a select statement ?

1847


What is oracle open database communication (odbc)?

563


How to manage transaction isolation level?

568






What is the difference between primary key and unique key and foreign key in oracle?

556


What is a tns service name?

538


Is it possible to split the print reviewer into more than one region ?

1840


What operating systems are supported by oracle database 10g xe?

585


Can we connect to ORACLE db using Windows Authentication?

727


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

1924


What is truncate oracle?

535


How to define an anonymous procedure with variables?

549


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2395


How to view all columns in an existing table?

552