1Z0-149 Online Practice Questions and Answers

Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.

Which script will execute successfully?

A. Option A

B. Option B

C. Option C

D. Option D

Which is true about EXIT and CONTINUE statements?

A. They can be used in any type of loop.

B. They must have a WHEN condition.

C. They have the same effect on the execution of a loop.

D. They must use labels.

Which three are valid PL/SQL variable names? (Choose three.)

A. printer_name#

B. 1to7number

C. yesterday's_date

D. leap$year

E. Number_of_days_between_March_and_April

F. #printer_name

G. v_fname

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

A. Implicit cursor returns only one record.

B. Explicit cursor can return more than one record.

C. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

E. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

F. %Isopen is always false in Explicit Cursor.

G. %Isopen is always false in Implicit Cursor.

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.

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

A. Named subprograms cannot be called from other packages.

B. PROCEDURE subprograms can accept parameters.

C. A FUNCTION subprogram must return one or more values.

D. Anonymous blocks cannot use packaged variables.

E. Named subprograms are stored in the database server.

F. Anonymous blocks must always start with the Declare keyword.

G. FUNCTION subprograms must be called and passed through one or more parameters.

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

A. RAW data types are always implicitly converted to a CLOB when used in a query.

B. Collections can be implicitly converted to records.

C. ROWIDS are always implicitly converted to a number when used in a query.

D. Comparison between character value and a number value always implicitly converts the character value to the number data type.

E. Implicit data type conversion can negatively impact performance.

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

A. a record declared in an anonymous block

B. a record declared in a procedure

C. an associative array indexed by PLS_INTEGER

D. a record declared in a package specification

E. a predefined PL/SQL-only data type like BOOLEAN

F. an associative array indexed by VARCHAR2

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. Option A

B. Option B

C. Option C

D. Option D

E. Option E

Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

A. 5000

B. 15000

C. 2500

D. 10000