Solve

Question 7 (2 points) When the action Cascade propagates the changes that were made to a primary key out to the associated foreign key, which of the following are the outcomes? Select all that apply. Rows containing invalid foreign keys are deleted when the primary key is deleted. CO Rows containing valid foreign keys are inserted when the primary key is inserted. Invalid foreign keys are set to the new primary key value when a primary key is updated. OO Rows containing valid foreign keys are deleted when the primary key is deleted. Rows containing valid foreign keys are inserted when the primary key is duplicated. Question 8 (2 points) [=| @f) Listen The four types of joins or SELECT statements that relational databases allow are listed below. Also listed are the combinations that these statements select from the database tables. Match each join type with its associated selected combination. Instructions: Choose your responses from the drop-down menus below. Responses cannot be used more than once. All left and right table rows. regardless of match . 1. Inner join Only matching right table rows but all left table rows 2. Left join Only matching left and right table rows 3. Right join Only matching left table 4. Full join rows but all right table rows Oniestian 999 nnintel