[2023年05月12日] 1z1-149 PDFで最近更新された問題です集試験点数を伸ばそう [Q31-Q56]

[2023年05月12日] 1z1-149 PDFで最近更新された問題です集試験点数を伸ばそう

1z1-149完全版問題集には無料PDF問題で合格させる

Oracle 1Z0-149認定試験は、Oracle Database 19cでのPL/SQLプログラミングの知識とスキルを評価するために設計されています。この認定は、PL/SQLを日常的に扱うプロフェッショナルの知識を検証し、Oracleデータベースで働く開発者、データベース管理者、アナリストに強く推奨されています。この試験に合格することで、PL/SQLプログラムの設計と実装、プログラムユニットの管理、PL/SQLの高度な機能の使用に熟練していることを証明できます。

 

質問 # 31
Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

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

正解：B、D

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

• A. It can be used to control a user's privileges on PL/SQL objects at run time.
• B. It can be used to obtain information about all identifiers when compiling a procedure.
• C. It is deprecated in Oracle 12c.
• D. It can be used to control execution of specific portions of the PL/SQL code conditionally.

正解：B

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

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

正解：B

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

• A. A package definition must have a specification and body.
• B. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
• C. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
• D. Package specifications can be compiled without their bodies.
• E. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

正解：B、D

質問 # 35
Examine these statements from a block of code:

Which two are true? (Choose two.)

• A. Only the PRICE column can be updated in the PRODUCTS table.
• B. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
• C. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
• D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
• E. 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、D

質問 # 36
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. CBAC cannot be used to secure definer's rights.
• 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 CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
• F. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
• G. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

正解：C、E、G

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

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

正解：C、E

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

• A. ALTER
• B. SELECT
• C. DROP
• D. DELETE
• E. INSERT
• F. UPDATE
• G. CREATE

正解：B、E、F

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

• A. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
• 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. Internally defined exceptions can be handled only by the OTHERS exception handler.
• E. All declared exceptions are raised implicitly by the runtime system.

正解：A、C

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

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

正解：A、B、F

質問 # 41
Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

• A. In line 1, add the default parameter DEFAULT 2000.
• B. In line 2, change IN OUT mode to IN mode.
• C. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
• D. In line 1, change IN OUT mode to IN mode.
• E. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
• F. In line 2, add the default parameter DEFAULT 2000.

正解：A、B

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

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

正解：B、C

質問 # 43
Which two are true about collections and RECORD types? (Choose two.)

• A. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
• B. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
• C. Only associative arrays and nested tables can have elements of RECORD type.
• D. Collections and RECORD types are always dense.
• E. All collections and RECORD types can be stored in table columns.
• F. A variable of RECORD type can contain fields of another RECORD type or any collection type.

正解：A、C

質問 # 44
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.

正解：D

質問 # 45
Examine this anonymous block of code:

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

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

正解：C、F

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

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

正解：A

質問 # 47
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

• A. It will run successfully producing a result of 4.
• B. It will run successfully producing a result of 5.
• C. DEP_VU must be manually recompiled to successfully run this code.
• D. It will result in an error because table depts has been altered.

正解：A

質問 # 48
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

• A. PACKAGES
• B. ANONYMOUS BLOCK
• C. DATABASE LINKS
• D. TRIGGER BODY
• E. VARIABLES

正解：A、C

質問 # 49
Which two are true about INDEX-BY tables? (Choose two.)

• A. The index can be integer only.
• B. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
• C. INDEX-BY table types can be created in PL/SQL blocks only.
• D. The index can be integer or string.
• E. INDEX-BY table types can be created with the CREATE TYPE statement.

正解：C、D

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

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

正解：A、C

質問 # 51
Examine these statements:

Which two are true? (Choose two.)

• A. The bank_activity_proc will not compile because of the commit.
• B. Neither table will have a row inserted and committed.
• C. Only one table will have a row inserted and committed.
• D. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
• E. Both tables will have a row inserted and committed.

正解：C、D

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

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

正解：A

質問 # 53
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.

正解：C

質問 # 54
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

• A. Only trailing optional parameters can be omitted in the invocation call.
• B. The actual parameters must be specified in the same order as the formal parameters are declared.
• C. Any optional parameters can be omitted in the invocation call.
• D. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
• E. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

正解：B、C

質問 # 55
Examine these statements which execute successfully:

Which anonymous block executes successfully?

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

正解：B

質問 # 56
......

この試験は、SQLと基本的なプログラミングの概念をよく理解している経験豊富な開発者を対象として設計されています。候補者はまた、Oracle Database 19c SQL構文に精通しており、データベースアーキテクチャについて良い理解を持っている必要があります。

Oracle Database 19c: Program with PL/SQL 認定は業界で高く評価されており、PL/SQL プログラミングと Oracle Database 19c の強い理解が証明されます。この認定は、データベース開発、管理、または管理のキャリアを進めたい専門家に最適です。また、Oracle Database 19c: Program with PL/SQL 認定は、専門家の収益力や就職機会を増やすのに役立ちます。

 

100%更新されたのはOracle 1z1-149限定版PDF問題集：https://jp.fast2test.com/1z1-149-premium-file.html

無料Oracle Database PL/SQL Developer Certified Professional 1z1-149公式認定ガイドPDFダウンロード：https://drive.google.com/open?id=1ZuHcIUZyShmKBowm29TtEVEMLP0yLuR3