無料Oracle Database PL/SQL Developer Certified Professional 1Z0-149究極の学習ガイド（更新された67問あります) [Q25-Q48]

無料Oracle Database PL/SQL Developer Certified Professional 1Z0-149究極の学習ガイド（更新された67問あります)

トップクラスの1Z0-149練習試験問題

質問 # 25
Which three statements are true about passing parameters to subprograms? (Choose three.)

• A. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
• B. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
• C. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
• D. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
• E. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
• F. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
• G. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

正解：A、C、E

質問 # 26
Which is the correct method to implement a local subprogram in an anonymous block?

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

正解：A

質問 # 27
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

• A. It will always automatically initialize v_raise.
• B. It will always return a run time error because v_raise is not initialized.
• C. It will always return a compile time error because it lacks an EXCEPTION section.
• D. It will set all salaries to NULL if it executes successfully.
• E. It will set all salaries to 0 if it executes successfully.
• F. It might return a run time error depending on who invokes it.

正解：A、D

質問 # 28
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

• A. ERROR
• B. SEVERE
• C. ALL
• D. ENABLE
• E. DISABLE

正解：B、C

質問 # 29
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

• A. Conditional compilation is disabled by default.
• B. PL/SQL code can be compiled and executed based on different versions of the operating system.
• C. The PL/SQL compiler can conditionally include selected parts of a program.
• D. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
• E. PL/SQL code can be compiled and executed based on different versions of Oracle.

正解：C、E

質問 # 30
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

• A. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
• B. It will fail at lines 6 and 7.
• C. It will fail only at line 7.
• D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

正解：C

質問 # 31
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

• A. line 2
• B. line 7
• C. line 1
• D. line 6
• E. line 3
• F. line 8

正解：C、D

質問 # 32
Which three are true regarding code based access control (CBAC)? (Choose three.)

• A. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
• B. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
• C. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
• D. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
• E. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
• F. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
• G. CBAC cannot be used to secure definer's rights.

正解：B、C、F

質問 # 33
Which two are true about exception handling? (Choose two.)

• A. All declared exceptions are raised implicitly by the runtime system.
• B. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
• C. Internally defined exceptions can be handled only by the OTHERS exception handler.
• D. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
• E. Predefined exceptions are globally declared in the standard package.

正解：D、E

質問 # 34
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

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

正解：A、D、E

質問 # 35
Which two are true about implicit data type conversion? (Choose two.)

• A. Comparison between character value and a number value always implicitly converts the character value to the number data type.
• B. Collections can be implicitly converted to records.
• C. Implicit data type conversion can negatively impact performance.
• D. RAW data types are always implicitly converted to a CLOB when used in a query.
• E. ROWIDS are always implicitly converted to a number when used in a query.

正解：A、C

質問 # 36
Examine this code:

What will be the outcome?

• A. It will execute successfully and will display the user-defined error message.
• B. It will result in an error as the range of the error code can only be from "-2000 to -2999."
• C. It will result in an error as the range of the error code can only be from "-1000 to -2000."
• D. It will result in an error as the range of the error code can only be from "-20000 to -20999."

正解：D

質問 # 37
Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

• A. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
• B. Initialization of loan_amount can be done while using this packaged variable in another program.
• C. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
• D. This will not compile successfully because the min_bal constant must be initialized.
• E. This program unit will compile successfully.
• F. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
• G. Initialization of min_bal can be done while using this packaged constant in another program.

正解：C、D、F

質問 # 38
For which three SYSTEM EVENTS can triggers be created? (Choose three.)

• A. BEFORE GRANT
• B. AFTER AUDIT
• C. DDL
• D. SHUTDOWN
• E. SERVERERROR
• F. BEFORE ANALYZE
• G. STARTUP

正解：D、E、G

質問 # 39
Examine this DECLARE section:

Which line will cause an error upon execution?

• A. line 2
• B. line 6
• C. line 5
• D. line 4
• E. line 3

正解：B

質問 # 40
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 a PL/SQL bytecode format.
• D. If set to NATIVE, programs are stored in platform dependent machine code.
• E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

正解：D、E

質問 # 41
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

• A. The check is enforced by this clause for direct access and access through dynamic SQL.
• B. It can be used in the declaration of object types.
• C. It must be specified in the heading of a package body.
• D. It can be used for individual procedures and functions declared in a package specification.
• E. It must be specified in the heading of a package specification.

正解：B、D

解説：
https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

質問 # 42
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.
• B.
• C.
• D.
• E.

正解：A、D

質問 # 43
Which two blocks of code display a numerical zero? (Choose two.)

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

正解：A、D

質問 # 44
Which two are true about packages? (Choose two.)

• A. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
• B. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
• C. A package definition must have a specification and body.
• 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.

正解：B、E

質問 # 45
Which is true about EXIT and CONTINUE statements?

• A. They must use labels.
• B. They must have a WHEN condition.
• C. They can be used in any type of loop.
• D. They have the same effect on the execution of a loop.

正解：C

質問 # 46
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 must differ in name.
• C. Each procedure must use named notation to specify the corresponding actual parameters.
• D. Each procedure can be a packaged subprogram.
• E. Each procedure must use positional notation to specify the corresponding actual parameters.
• F. Each procedure can be a standalone subprogram.
• G. Each procedure's formal parameters can differ in data type or name.

正解：D、E、G

質問 # 47
Which three are true about anonymous blocks and subprograms? (Choose three.)

• A. Anonymous blocks cannot use packaged variables.
• B. A FUNCTION subprogram must return one or more values.
• C. PROCEDURE subprograms can accept parameters.
• D. Anonymous blocks must always start with the Declare keyword.
• E. Named subprograms are stored in the database server.
• F. Named subprograms cannot be called from other packages.
• G. FUNCTION subprograms must be called and passed through one or more parameters.

正解：B、C、E

質問 # 48
......

Oracle 1z1-149認定試験に合格することで、候補者はPL / SQLプログラミングの熟練度とOracle Database 19cを使用した効率的で効果的なデータベースアプリケーションの開発能力を示すことができます。この認定は、Oracleデータベースを使用する開発者や将来的に使用する予定のある開発者にとって貴重な資産であり、プロフェッショナルな開発への取り組みとデータベースプログラミングの専門知識を示します。

Oracle 1z1-149 認定試験は、PL/SQL プログラミングにおける専門知識を潜在的な雇用主に示す素晴らしい方法です。この認定試験は、Oracle Database 19c 上で PL/SQL を使用してデータベースアプリケーションを開発および管理するスキルと知識を検証します。この認定試験はグローバルに認められており、あなたのキャリア発展にとって貴重な資産となります。また、この認定試験は、スキルを開発するために時間と労力を投資したことを示し、就職市場で他の候補者と差をつけることができます。

 

合格させるOracle 1Z0-149試験問題でテスト復刻エンジンとPDF：https://www.goshiken.com/Oracle/1Z0-149-mondaishu.html

実際問題を使って1Z0-149問題集無料サンプル問題と練習テストエンジン：https://drive.google.com/open?id=1Avwkgj2wWdtjpai2nJvicUlmdhUY7kkg