2023 PassTestking Oracle 1Z0-149 Dumps and Exam Test Engine [Q20-Q35]

NEW QUESTION 20
Examine this DECLARE section:

Which line will cause an error upon execution?

NEW QUESTION 21
Which three are true about anonymous blocks and subprograms? (Choose three.)

NEW QUESTION 22
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

NEW QUESTION 23
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

NEW QUESTION 24
Which three are true about functions and procedures? (Choose three.)

NEW QUESTION 25
Which is true about counter variables in a FOR loop?

NEW QUESTION 26
Examine this code:
ALTER SESSION SET plsql_warnings=’ENABLE:ALL’;
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to ‘ENABLE: ALL’?

NEW QUESTION 27
Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

NEW QUESTION 28
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

NEW QUESTION 29
Which two blocks of code display a numerical zero? (Choose two.)

NEW QUESTION 30
Which three statements are true about passing parameters to subprograms? (Choose three.)

NEW QUESTION 31
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

NEW QUESTION 32
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

NEW QUESTION 33
Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product’s price is 1000.
With which option must “—placeholder” be replaced?

NEW QUESTION 34
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

NEW QUESTION 35
Examine these statements:

Which is true?