Online Access Free 1Z0-149 Exam Questions

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?

• A.
• B.
• C.
• D.
• E.

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

• A.Explicit cursor can return more than one record.
• B.%Isopen is always false in Explicit Cursor.
• C.%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
• D.Implicit cursor returns only one record.
• E.%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
• F.%Isopen is always false in Implicit Cursor.
• G.%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

Which is the correct method to implement a local subprogram in an anonymous block?

• A.
• B.
• C.
• D.

Which is true about counter variables in a FOR loop?

• A.It cannot be NULL.
• B.It must explicitly be declared.
• C.It can be modified in the body of the loop.
• D.It is accessible outside the body of the loop.

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

• A.The NOCOPY hint asks the compiler to pass the actual parameters by value.
• B.The NOCOPY hint asks the compiler to pass the actual parameters by reference.
• C.A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
• D.A deterministic function's results always depend on the state of session variables.
• E.The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
• F.A function is deterministic if it always returns the same result for a specific combination of input values.
• G.The PARALLEL_ENABLE clause can be specified for a nested function.