1Z0-149 Online Practice Questions and Answers

Which statement is true about user-defined records?

A. They can be returned from a function.

B. Field types must match column types.

C. The number of fields must match the number of columns in a table.

D. Field names must match selected column names.

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'?

A. It fails compilation.

B. There are no compilation warnings or errors.

C. A severe compilation warning is generated.

D. A performance compilation warning is generated.

E. An information compilation warning is generated.

Which block of code displays the error message "Incorrect price value"?

A. Option A

B. Option B

C. Option C

D. Option D

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

A. Each procedure can be a nested subprogram.

B. Each procedure's formal parameters can differ in data type or name.

C. Each procedure must use named notation to specify the corresponding actual parameters.

D. Each procedure's formal parameters must differ in name.

E. Each procedure can be a packaged subprogram.

F. Each procedure must use positional notation to specify the corresponding actual parameters.

G. Each procedure can be a standalone subprogram.

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

A. DISABLE

B. ENABLE

C. ERROR

D. ALL

E. SEVERE

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

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

Which is true about counter variables in a FOR loop?

A. It must explicitly be declared.

B. It can be modified in the body of the loop.

C. It cannot be NULL.

D. It is accessible outside the body of the loop.

Examine these statements which execute successfully:

Which anonymous block executes successfully?

A. Option A

B. Option B

C. Option C

D. Option D

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

A. CREATE

B. DROP

C. UPDATE

D. SELECT

E. DELETE

F. ALTER

G. INSERT

Examine these statements from a block of code: Which two are true? (Choose two.)

A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

B. Only the PRICE column can be updated in the PRODUCTS table.

C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.