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

Answer Posted / murugananthan

NO, UNIQUE +NOT NULL != PRIMARY KEY
it cant refer someother table column

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain compound trigger in oracle?

784


How to start instance with a minimal initialization parameter file?

761


What is an oracle data file?

809


What is a table index?

745


What is an Oracle Instance?

861


Explain the use of constraints option in exp command.

751


Explain what does a control file contain?

782


what is the use of system.effective.date variable in oracle?

861


What is sequence?

812


How to define an anonymous procedure without variables?

732


How a tablespace is related to data files?

776


What do you mean by a tablespace?

761


Point out the difference between user tables and data dictionary?

738


How to define a data source name (dsn) in odbc manager?

732


What are the set operators union, union all, minus & intersect meant to do?

748