question archive Which of the following correctly describes the referential action specified by the ON UPDATE CASCADE subclause of the FOREIGN KEY clause? 1
Which of the following correctly describes the referential action specified by the ON UPDATE CASCADE subclause of the FOREIGN KEY clause? 1
Subject:Computer SciencePrice:1.87 Bought7
Which of the following correctly describes the referential action specified by the ON UPDATE CASCADE subclause of the FOREIGN KEY clause?
1. If a row from the parent table is updated, then matching rows in the child table are automatically set to NULL
2. If a row from the parent table is updated, then matching rows in the child table are automatically updated as well.
3. Ifa row from the parent table is deleted, then matching rows in the child tble are automatcally deeted as we
4. If a query attempts to delete a row from the parent table while tuples in a child table are dependent on it, then the query will
5. If a query attempts to update a row from the parent table while tuples in a child table are dependent on it, then the query will be rejected by the DBMS.
Option 1
Low Cost Option
Download this past answer in few clicks
1.87 USD
PURCHASE SOLUTION
Option 2
Custom new solution created by our subject matter experts
GET A QUOTE
rated 5 stars
Purchased 7 times
