Oracle

1Z0-882 · Question #70

When executing a stored routine, how is the SQL_MODE determined?

The correct answer is C. By the SQL_MODE that was set when the routine was defined. See the full explanation below for the reasoning.

Question

When executing a stored routine, how is the SQL_MODE determined?

Options

ABy the default SQL_MODE of the server
BBy the current SQL _MODE of the session
CBy the SQL_MODE that was set when the routine was defined
DBy using TRADITTIONAL regardless of any other settings

How the community answered

(34 responses)

A
6% (2)
B
18% (6)
C
71% (24)
D
6% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-882 Practice