exam questions

Exam 1z0-148 All Questions

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

Exam 1z0-148 topic 1 question 3 discussion

Actual exam question from Oracle's 1z0-148
Question #: 3
Topic #: 1
[All 1z0-148 Questions]

Examine the section of code taken from a PL/SQL program:

PLSQL_OPTIMIZE_LEVEL PARAMETER is set to 3.
Which two statements are true?

  • A. Calls to TESTPROC will always be inlined as it is compiled with PLSQL_OPTIMIZE_LEVEL=3.
  • B. Calls to TESTPROC are never inlined in both lines commented as Call1 and Call 2.
  • C. Calls to TESTPROC are not inlined in the line commented as Call 1.
  • D. Calls to TESTPROC are inlined in both lines commented as Call 1 and Call 2.
  • E. Calls to TESTPROC might be inlined in the line commented as Call 2.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
Reference:
https://docs.oracle.com/cd/E18283_01/appdev.112/e17126/tuning.htm

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
chaoyuim
Highly Voted 4 years, 7 months ago
C , E see here : https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/inline_pragma.htm#LNPLS01362
upvoted 9 times
...
v323rs
Highly Voted 5 years, 4 months ago
I think answer C,E
upvoted 7 times
...
Angelos_ang
Most Recent 2 years, 4 months ago
Selected Answer: CE
https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/inline_pragma.htm#LNPLS01362
upvoted 1 times
...
Rakeshpro
2 years, 4 months ago
Multiple pragmas can affect the same declaration or statement. Each pragma applies its own effect to the statement. If PRAGMA INLINE(subprogram,'YES') and PRAGMA INLINE(identifier,'NO') have the same subprogram, then 'NO' overrides 'YES'. One PRAGMA INLINE(subprogram,'NO') overrides any number of occurrences of PRAGMA INLINE(subprogram,'YES'), and the order of these pragmas is not important.
upvoted 1 times
Rakeshpro
2 years, 4 months ago
The INLINE pragma affects only the immediately following declaration or statement, and only some kinds of statements. When the INLINE pragma immediately precedes a declaration, it affects: Every invocation of the specified subprogram in that declaration Every initialization value in that declaration except the default initialization values of records When the INLINE pragma immediately precedes one of these statements, the pragma affects every invocation of the specified subprogram in that statement: Assignment CALL Conditional CASE CONTINUE WHEN EXECUTE IMMEDIATE EXIT WHEN LOOP RETURN The INLINE pragma does not affect statements that are not in the preceding list.
upvoted 1 times
...
...
chrishillinger
2 years, 5 months ago
Selected Answer: CE
Agree with chaoyuim - CE
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago