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

Bethanie

7 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

...

Gennie

9 days ago

I'm not sure about the changes. I think A) Change DATE() to DAY() might also be needed. What do you think?

upvoted 0 times

...

Aliza

12 days ago

I agree with Devorah. Those changes make sense to insert the correct data.

upvoted 0 times

...

Devorah

15 days ago

I think the correct changes are C) Change date() to CURRENT_TIMESTAMP() and F) Change \'O'Hagen\' to \'O\\'Hagen\'.

upvoted 0 times

...