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
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.
What are the different oracle database objects?
Explain the use of compress option in exp command.
Explain user account with reference to oracle.
How many types of auditing in Oracle?
Differentiate between function and procedure in oracle.
How to define a specific record type?
How to list all tables in your schema?
How do I spool to a csv formatted file using sqlplus?
Explain the use of show option in imp command.
How can we force the database to use the user specified rollback segment?
How to drop an existing table in oracle?
How to select an oracle system id (sid)?
How to select some columns from a table in oracle?
What are the different pseudo commands? Explain in general?