Difference between primary key and unique key ?
Answer Posted / umapathy.r
The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null
Is This Answer Correct ? | 1164 Yes | 121 No |
Post New Answer View All Answers
Why do we use bulk collect in oracle?
How to display employee records who gets more salary than the average salary in the department?
How to count duplicated values in a column in oracle?
What are the arithmetic operations?
Is oracle a relational database?
In oracle there is column command, how will you explain that?
What is the difference between substr and instr?
What to do if dba lost the system password?
Explain alias?
Explain how you would restore a database using RMAN to Point in Time?
What is truncate oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain an exception?
What is a private synonym?