あなたを合格させる1z1-149お手軽に試験合格リアル1z1-149練習問題集で更新されたのは2023年11月22日 [Q35-Q60]

あなたを合格させる1z1-149お手軽に試験合格リアル1z1-149練習問題集で更新されたのは2023年11月22日

2023年最新の実際に出ると確認されたで無料Oracle 1z1-149試験問題

Oracle 1z1-149試験の準備には、Oracle Universityのコース、練習問題、学習ガイドなど、さまざまなリソースを活用することができます。さらに、PL/SQLプログラミングとOracle Database 19cの実践的な経験を持つことが望ましいです。実践的な経験と試験の準備リソースを組み合わせることで、Oracle 1z1-149試験に合格し、Oracle Database 19c：Program with PL/SQL認定を取得する可能性を高めることができます。

Oracle 1Z0-149試験は、高度な機能や技術を利用してプログラムのパフォーマンスを最適化し、エラーハンドリングやデバッグ、データベーストリガーやカーソルの統合など、PL / SQLプログラミングに関連する幅広いトピックをカバーしています。受験者は、効率的で信頼性が高く、メンテナンス性が高いPL / SQLソリューションを設計および実装する能力を示すことが求められます。

Oracle 1z1-149試験に備えるために、候補者はPL / SQLプログラミングとOracle Database 19cの堅牢な理解を持つ必要があります。これは、実践的な経験、トレーニングコース、書籍、オンラインリソースなどの学習教材を通じて達成できます。また、候補者はサンプル試験問題を練習し、実際の試験に対する準備状況を把握するために練習試験を活用することが推奨されます。

 

質問 # 35
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. A package definition must have a specification and body.
• 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.

正解：C、E

質問 # 36
Which three are true about DDL triggers? (Choose three.)

• A. They must be created in an enabled state.
• B. They can be fired when a table is truncated.
• C. They fire only when a DDL statement is executed by the owner of the trigger.
• D. They must be created in a disabled state.
• E. They can be fired either before or after a DDL statement executes.
• F. They can be fired when a privilege is granted to a user.
• G. They cannot include the WHEN clause.

正解：B、C、E

質問 # 37
Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

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

正解：C

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

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

正解：C

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

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

正解：D、E、G

質問 # 40
Examine these statements which execute successfully:

Which anonymous block executes successfully?

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

正解：B

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

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

正解：C、D

質問 # 42
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

• A. It results in an error because Authid Current_User is missing from MYPROC.
• B. It results in an error because Authid Definer is missing from MYPROC.
• C. It executes successfully.
• D. It results in an error because USERB doesn't have select privilege on USERA.EMP.

正解：C

質問 # 43
Which three are true about the procedure overloading feature? (Choose three.)

• A. Each procedure can be a packaged subprogram.
• B. Each procedure's formal parameters can differ in data type or name.
• C. Each procedure's formal parameters must differ in name.
• D. Each procedure must use positional notation to specify the corresponding actual parameters.
• E. Each procedure can be a standalone subprogram.
• F. Each procedure can be a nested subprogram.
• G. Each procedure must use named notation to specify the corresponding actual parameters.

正解：A、B、D

質問 # 44
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

• A. When using the RETURNING INTO clause, the data returned can be only single column or expression.
• B. The RETURNING INTO clause and bulk binds may not be used together.
• C. The RETURNING INTO clause returns column values for rows affected by DML statements.
• D. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
• E. The RETURNING clause can be used for remote or parallel deletes.

正解：D、E

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

• A. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
• B. CBAC cannot be used to secure definer's rights.
• C. 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.
• D. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
• E. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
• F. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
• G. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

正解：A、D、G

質問 # 46
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

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

正解：D

質問 # 47
Which three are true about functions and procedures? (Choose three.)

• A. Both can be invoked from within SQL statements.
• B. The ACCESSIBLE BY clause can be used only for procedures.
• 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. Both can have only constants as actual parameters for IN mode parameters.
• F. In a procedure the RETURN statement cannot specify an expression.

正解：C、D、F

質問 # 48
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. 0
• B. 1
• C. 2
• D. 3

正解：A

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

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

正解：C、E

質問 # 50
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 fail at lines 6 and 7.
• B. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
• 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

質問 # 51
Which three are valid PL/SQL variable names? (Choose three.)

• A. leap$year
• B. v_fname
• C. printer_name#
• D. Number_of_days_between_March_and_April
• E. 1to7number
• F. yesterday's_date
• G. #printer_name

正解：A、B、C

質問 # 52
In which type of trigger can :OLD and :NEW identifiers be used?

• A. AFTER SUSPEND
• B. ROW
• C. AFTER STATEMENT
• D. BEFORE STATEMENT

正解：B

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

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

正解：A

質問 # 54
Which is true about counter variables in a FOR loop?

• A. It cannot be NULL.
• B. It must explicitly be declared.
• C. It is accessible outside the body of the loop.
• D. It can be modified in the body of the loop.

正解：A

質問 # 55
SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

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

正解：A

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

• 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. Implicit data type conversion can negatively impact performance.
• E. ROWIDS are always implicitly converted to a number when used in a query.

正解：C、D

質問 # 57
Which is true about the PLSCOPE_SETTINGS parameter?

• 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

質問 # 58
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. An information compilation warning is generated.
• B. It fails compilation.
• C. There are no compilation warnings or errors.
• D. A performance compilation warning is generated.
• E. A severe compilation warning is generated.

正解：D

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

正解：B

質問 # 60
......

1z1-149リアル試験問題解答は無料：https://www.passtest.jp/Oracle/1z1-149-shiken.html

1z1-149試験問題、リアル1z1-149練習問題集：https://drive.google.com/open?id=1c7qtd9vTkTKfjVe91R8JxVM_GRjdOZS4