Exam 1z0-149 topic 1 question 37 discussion

Actual exam question from Oracle's 1z0-149

Question #: 37
Topic #: 1

[All 1z0-149 Questions]

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

A. It will set all salaries to 0 if it executes successfully.
B. It will always return a compile time error because it lacks an EXCEPTION section.
C. It might return a run time error depending on who invokes it.
D. It will always automatically initialize v_raise.
E. It will set all salaries to NULL if it executes successfully.
F. It will always return a run time error because v_raise is not initialized.

Show Suggested Answer

Suggested Answer: DE 🗳️

by jm9999 at July 20, 2023, 8:55 p.m.

Comments

Submit Cancel

mattiamarraffa

2 months, 1 week ago

Selected Answer: DE

D and E are correct

upvoted 1 times

...

egznrd

3 months, 1 week ago

I think C and E are correct

upvoted 2 times

AlCoholic69

1 week ago

C is a trap because yes any sql might fail if invoking user doesn't have privilege. But D is correct because all variables are inistialized to NULL. E is correct because anything + null is null

upvoted 2 times

...

jm9999

4 months, 3 weeks ago

Is setting v_raise to null equivalent to initializing v_raise?

upvoted 4 times

...

Exam 1z0-149 All Questions

View all questions & answers for the 1z0-149 exam