Oracle
1Z0-882 · Question #53
1Z0-882 Question #53: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.
Question
You wish to create a trigger on the
city' table that will check the value of the District' field before any INSERT. The trigger needs to change it to" Unknown" for an empty string or NULL. CREATE TRIGGER City_bi BEFORE INSERT ON CITY FOR EACH ROW BEGIN IF OLD. District IS NULL OR OLD.District= . . THEN SET NEW.District='Unknown'; END IF : END; Does the CREATE TRIGGER statement accomplish this goal?Options
- AYes; the trigger works correctly.
- BNo; FOR EACH ROW is invalid syntax.
- CNo; the syntax should be CREATE TRIGGER city-bi ON city BEFORE INSERT....
- DNo; the OLD keyword cannot be used in an INSERT trigger.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.