Answer / tulsi

The main use of ON DELETE CASCADE is to delete the child
records automatically from a table when the related records
from master table is deleted.

Assign the ON DELETE CASCADE clause while creating the
foreign key

Answer / vilas

Yes,its true and won't display any error while deleting the
master table.

Answer / ansupriya

If child record exists user cannot delete parent record.
Using on delete cascade on foreign constraint user can delete parent record .
Same time automatically it will delete the child record.

Difference between global and parameter variables?

0 Answers   TCS,

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

What are the basic techniques of indexing?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

Is mariadb nosql?

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---

Why is %isopen always false for an implicit cursor?

0 Answers  

---

Which sql most popular?

0 Answers  

---

Can we insert delete data in view?

0 Answers  

---

How do I add a database to sql?

0 Answers  

---