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
What is analyze command used for?
What is the data type of dual table?
Explain parameter file in oracle.
Why do you create or replace procedures rather that drop and recreate.
Can we commit inside a function in oracle?
What is a nvl function? How can it be used?
What privilege is needed for a user to connect to oracle server?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to run create database statement again?
What is translate in oracle?
How to get execution statistics reports on query statements?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What happens in oracle commit?
What is a user role in oracle?
How to create lov dynamically at runtime & attach to text field?