Oracle
1Z0-909 · Question #20
1Z0-909 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-909 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
SQL Fundamentals
Question
Your session has sqi_mode set to default. Examine this statement which executes successfully: Now examine this statement: Which two changes are required to the insert statement so that it inserts the correct data? - std_id = 10301 - firstname = Mary - lastname = O'Hagen - birthdate = November 26, 1997 - reg_date = the current date
Exhibit
Options
- AChange DATE () to DAY ().
- BChange "O'Hagen" to 'o'Hagen'.
- CChange date () to CURRENT_TIMESTAMP () .
- DChange " NULL " to NULL.
- EChange " NULL " to ' NULL ' .
- FChange "O'Hagen" to "O'Hagen".
Unlock 1Z0-909 to see the answer
You've previewed enough free 1Z0-909 questions. Unlock 1Z0-909 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.
Topics
#INSERT statements#NULL handling#Date functions#String literals