Answer Posted / deva
on delete cascade is used to delete the rows/constraints
which are in integrity/foreign key constraints.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is enter substitution variable in oracle?
What are the differences between number and binary_float in oracle?
Explain the different normalization forms?
Differentiate between function and procedure in oracle.
Give the various exception types.
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to write a left outer join with the where clause in oracle?
Explain a synonym?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to pass a cursor variable to a procedure?
How to create a new tablespace in oracle?
What do you mean by merge in oracle?
Whether any commands are used for months calculation? If so, what are they?
What is the sql query to concatenate column values from multiple rows in oracle?