Your session has sqi_mode set to default.

Oracle 1z0-909 Question Answer

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

Change DATE () to DAY ().

Change "O'Hagen" to 'o\'Hagen'.

Change date () to CURRENT_TIMESTAMP () .

Change " NULL " to NULL.

Change " NULL " to ' NULL ' .

Change "O'Hagen" to "O\'Hagen".

1z0-909 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"