There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
PassGuideApp uses Data Contexts to access data from the database.
PassGuideDB includes two tables Employees and Employees_details with a foreign key
constraint between them.
How can you ensure that the Employees_details records are deleted, when you delete a
corresponding record in the Employee table.
How can this be ensured? Select two.
A.
The foreign key constraint should be…
B.
The delete operation on the Employees table should be..
C.
PassGuideDB should be…
D.
..removed.
E.
..modified to include the ON DELETE CASCADE option
F.
..modified to include the ON UPDATE CASCADE option
G.
..modified to include the ON MODIFY CASCADE option
Explanation:
Answer is correct. Source: http://www.mysqltutorial.org/mysql-on-delete-cascade/
MySQL provides ON DELETE CASCADE referential action for a foreign key that allows you to delete data from child tables automatically when you delete the data from the parent table.
0
0
In the question MS SQL is mentioned, but this is true for that too.
0
0