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

Answer Posted / raam

No. Generally Primary Key contains Unique + NotNull values.
If we are not defined a column as Primay Key and we defined
as Unique + NotNull, then, the behavior of that particular
column in that particular table looks like primary key. but
this cannot be referenced in any other table as we have not
defined as primary key..So, Primary Key column is different
from the column which have Unique + Not Null qualities.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2034


What are the different oracle database objects?

843


Explain the use of compress option in exp command.

779


Explain user account with reference to oracle.

789


How many types of auditing in Oracle?

827


Differentiate between function and procedure in oracle.

818


How to define a specific record type?

861


How to list all tables in your schema?

817


How do I spool to a csv formatted file using sqlplus?

752


Explain the use of show option in imp command.

871


How can we force the database to use the user specified rollback segment?

855


How to drop an existing table in oracle?

843


How to select an oracle system id (sid)?

812


How to select some columns from a table in oracle?

763


What are the different pseudo commands? Explain in general?

834