最新的Oracle Database 19c: Program with PL/SQL - 1z1-149免費考試真題

A.

B.

C.

D.

A. Both can have only constants as actual parameters for IN mode parameters.

B. Both can be invoked from within SQL statements.

C. In a function every RETURN statement must specify an expression.

D. In a function, every execution path must lead to a RETURN statement.

E. In a procedure the RETURN statement cannot specify an expression.

F. The ACCESSIBLE BY clause can be used only for procedures.

A. A package definition must have a specification and body.

B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

C. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

D. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

E. Package specifications can be compiled without their bodies.

A. It is deprecated in Oracle 12c.

B. It can be used to control a user's privileges on PL/SQL objects at run time.

C. It can be used to obtain information about all identifiers when compiling a procedure.

D. It can be used to control execution of specific portions of the PL/SQL code conditionally.

A. Collections can be implicitly converted to records.

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

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

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

E. Implicit data type conversion can negatively impact performance.

A. They must use labels.

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

C. They must have a WHEN condition.

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

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

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

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

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

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