1Z0-149 Real Exam Questions and Verified Answers

Question 1 Multiple choice

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.)

A
line 1
B
line 6
C
line 8
D
line 2
E
line 3
F
line 7

Show answer and explanation

Correct answers: A, B

Question 2 Multiple choice

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

A
DECLARE
B
OPEN
C
INTO
D
OPEN-FOR
E
FETCH
F
WHEN
G
CLOSE

Show answer and explanation

Correct answers: D, E, G

Question 3 Multiple choice

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

A
Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
B
The default value is NATIVE.
C
If set to NATIVE, programs are stored in platform dependent machine code.
D
It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
E
If set to NATIVE, programs are stored in a PL/SQL bytecode format.

Show answer and explanation

Correct answers: C, D

Question 4 Multiple choice

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.)

A
In line 1, change IN OUT mode to IN mode.
B
In line 2, change IN OUT mode to IN mode.
C
In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
D
In line 1, add the default parameter DEFAULT 2000.
E
In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
F
In line 2, add the default parameter DEFAULT 2000.

Show answer and explanation

Correct answers: B, D

Question 5 Single choice

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.

Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

A
Error in inner block
B
Error in inner block Error in outer block
C
Error in inner block Error in calling block
D
Error in inner block Error in outer block Error in calling block

Show answer and explanation

Correct answer: A

Question 6 Single choice

Examine these statements:

Which is true?

A
It will result in a compilation error for protected_proc because calling_proc does not exist.
B
It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
C
It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
D
With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

Show answer and explanation

Correct answer: A

Question 7 Single choice

In which type of trigger can :OLD and :NEW identifiers be used?

A
ROW
B
AFTER SUSPEND
C
AFTER STATEMENT
D
BEFORE STATEMENT

Show answer and explanation

Correct answer: A

Question 8 Multiple choice

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

A
PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
B
IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
C
IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
D
The actual parameter must be a variable when calling a subprogram with an OUT parameter.
E
IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
F
OUT parameters returning values to calling subprograms act like constants in the called subprogram.
G
Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

Show answer and explanation

Correct answers: B, C, D

Question 9 Multiple choice

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

A
DISABLE
B
ENABLE
C
ERROR
D
ALL
E
SEVERE

Show answer and explanation

Correct answers: D, E

Question 10 Multiple choice

Which two are true about collections and RECORD types? (Choose two.)

A
A variable of RECORD type can contain fields of another RECORD type or any collection type.
B
Only associative arrays and nested tables can have elements of RECORD type.
C
All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
D
Collections and RECORD types are always dense.
E
All collections and RECORD types can be stored in table columns.
F
VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Show answer and explanation

Correct answers: B, F