Solve

motion if pointal Three action that databases can take when autocorrectin foreign key insertions and updates are listed below. Limitation on databases for each action are listed as weil Instructions: Match rach action to its associated limitation. Chome your responses from the drop-down menun below. Responses cannot be used more than anon. I cannot be used when a foreign key is NOT NULL. 1 Hastrict The value specified for it must be a valid primary 2 Set Null KEY It is applied when re 3. Set Default action in specificd austin 7 12 points] When the action Cascade propagates the changes that were made to a primary bry out to the associated foreign bry, which of the following are the outcomes? Select all that apply. Hows containing invalid foreign keys are deleted when the primary kay is Hows containing valid foreign kays are imcried when the primary key is inertand. Inadid foreignkeys are set to the new primary kay value when a primary key is Hows containing valid foreign keys are deleted when the primary kay is deleted. Hows containing valid forsign keys are imerted when the primary key is duplicated usnation ( points] The four types of joins or SELECT statements that relational database allow are listed below. Ahn listed are the combinations that these statements seled from the database Mich each join type with its anodated selected combination. Instruction: Choose your repames from the drop-down menus below. Response cannot be uned more Hun once. Only matching left table rows but all right table 1 Inner join Only matching left and 2 Left join right table news All left and right table 1 Right join rows, regardless of match 4. Full join Only matching right table rows but all left table news wastion " ( points] Your coworker than deckled to take an online course about the basics of dafshaves so that he can improve his job performance. As you study with him, he ways that he thinka attributes are essential in an ER diagram. Is this brumer faint OFal ustion 10 12 points Iyou needed the database to select values in acending onker, which of the following clauses should you use alory with the SELELI command? Select one Order By ALL Order By LIKE HINARY Order By LIKE INIT Order By NOT DESC Order By