why can't we assign not null constraint as table level
constraint
Answer Posted / senthil
not null constraint applied on table level constraint but table must be empty otherwise not possible .
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is recovery manager(rman) backup in Oracle?
Explain joins in oracle?
What do you mean by merge in oracle?
Can we protect our pl/sql source code?
What do you mean by a deadlock?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What happens if the update subquery returns multiple rows?
How to declare a local variable?
Explain the use of constraints option in exp command.
master table and child table performances and comparisons in Oracle ?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is oracle instant client?
What is Trigger in Oracle?
What is the meaning of recursive hints in oracle?
How are extents allocated to a segment?