Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15323 Views
- Genpact, I also Faced
- E-Mail Answers
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
What is SQL access advisor in Oracle?
What is ASM (Automatic Storage Management) in Oracle?
What is the use of aggregate functions in oracle?
How many types of cluster table in Oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is an oracle database table?
Can multiple cursors being opened at the same time?
Explain the use of control file?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to get a list of all user accounts in the database?
Explain user account with reference to oracle.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is oracle and what are its different editions?
How do we represent comments in oracle?
