Oracle Exam 1Z0-909 Topic 8 Question 38 Discussion

Actual exam question for Oracle's 1Z0-909 exam

Question #: 38
Topic #: 8

[All 1Z0-909 Questions]

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

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'.

Show Suggested Answer

Suggested Answer: A, B

by Loreta at May 19, 2024, 11:37 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-909 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Shawn

2 days ago

I'm pretty sure the answer is B) and F). Escaping the single quote is the key to getting the last name correct. The other options seem like they could introduce more issues.

upvoted 0 times

...

Bethanie

15 days ago

The correct answers are B) and F) - we need to escape the single quote in 'O'Hagen' to 'O\\'Hagen'. The other changes don't seem necessary based on the provided information.

upvoted 0 times

...