1Z0-149 無料問題集「Oracle Database 19c: Program with PL/SQL」

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

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

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

（A）WHEN

（B）DECLARE

（C）FETCH

（D）OPEN-FOR

（E）OPEN

（F）CLOSE

（G）INTO

（A）It can be used to obtain information about all identifiers when compiling a procedure.

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

（C）It is deprecated in Oracle 12c.

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

（A）The actual parameter must be a variable when calling a subprogram with an OUT parameter.

（B）OUT parameters returning values to calling subprograms act like constants in the called subprogram.

（C）IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

（D）IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

（E）Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

（F）PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

（G）IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

（A）Each procedure must use named notation to specify the corresponding actual parameters.

（B）Each procedure can be a standalone subprogram.

（C）Each procedure can be a packaged subprogram.

（D）Each procedure can be a nested subprogram.

（E）Each procedure's formal parameters must differ in name.

（F）Each procedure's formal parameters can differ in data type or name.

（G）Each procedure must use positional notation to specify the corresponding actual parameters.

（A）15000

（B）5000

（C）2500

（D）10000

（A）

（B）

（C）

（D）