Oracle 1Z0-149 Exam Info and Free Practice Test PrepAwayETE [Q31-Q52]

NEW QUESTION 31
Which two are true about implicit data type conversion? (Choose two.)

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

NEW QUESTION 33
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 34
Examine this DECLARE section:

Which line will cause an error upon execution?

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

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

NEW QUESTION 37
Which three are true about the procedure overloading feature? (Choose three.)

NEW QUESTION 38
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

NEW QUESTION 39
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

NEW QUESTION 40
For which three SYSTEM EVENTS can triggers be created? (Choose three.)

NEW QUESTION 41
Which three statements can process a dynamic multi-row query? (Choose three.)

NEW QUESTION 42
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

NEW QUESTION 43
Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

NEW QUESTION 44
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 45
Examine these statements:

Which two are true? (Choose two.)

NEW QUESTION 46
Which three are true about PL/SQL subprograms? (Choose three.)

NEW QUESTION 47
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)

NEW QUESTION 48
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

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

NEW QUESTION 50
Examine these statements:

Which is true?

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

NEW QUESTION 52
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)