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

Answer Posted / pkd

yes, unique key is also used for foreign key

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is recovery manager(rman) backup in Oracle?

629


What do you mean by merge in oracle and how can we merge two tables?

577


Why do we use coalesce function in oracle?

637


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

653


What is a database schema in oracle?

627






What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4023


Difference between hot backup vs. Cold backup?

608


What is oracle update statement with inner join ?

585


How to export your own schema?

579


List out the types of joins.

595


What do you mean by a tablespace?

566


How to define a cusotmer as a supplier in ORACLE R12

1728


What is oracle analytical function?

533


How many data types are supported?

624


What is oracle and what are its different editions?

581