Is primary key = unique key,not null?
If yes,please explain
IF No,please explain

Answer Posted / neeraj

No, Both are different, If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.
I think you got the difference.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State all possible different index configurations a table can possibly have?

800


How to use subqueries in the from clause in oracle?

859


Differentiate between pre-select and pre-query?

863


How many types of table in Oracle?

872


Difference between inner join vs where ?

813


What is an oracle wallet?

707


1) Does oracle have any table which contain all the exceptions and it's code internally?

1530


How many types of database triggers exist?

807


What are the most common interview questions on ETL Testing for experience?

890


Explain about achiever in sql?

820


What are the different types of modules in oracle forms?

777


What is a subquery?

862


What privilege is needed for a user to create views in oracle?

826


How does the on-delete-cascade statement work?

887


How a database is related to tablespaces?

797