What is self-referential integrity constraint ?
Answer Posted / orawhiz
If a foreign key reference a parent key of the same table is
called self-referential integrity constraint
| Is This Answer Correct ? | 36 Yes | 3 No |
Post New Answer View All Answers
What is meant by a deadlock situation?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Explain the use of file option in exp command.
Why do we need integrity constraints in a database?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is oracle and what are its different editions?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is set verify off in oracle?
How to define default values for formal parameters?
What is a named program unit?
How is it different from a normal table?
What are the ways tablespaces can be managed and how do they differ?
How are extents allocated to a segment?
How to get a create statement for an existing table?
Can a formula column referred to columns in higher group ?