ベストな準備プラン1Z0-149試験2023年最新のOracle Database PL/SQL Developer Certified Professional無制限67問題 [Q23-Q44]

ベストな準備プラン1Z0-149試験2023年最新のOracle Database PL/SQL Developer Certified Professional無制限67問題

注目すべき時短になる1Z0-149オールインワン試験ガイド

この試験は75問の選択式問題から構成され、時間制限は105分です。PL/SQL言語の基礎、プログラマティック構造、エラーハンドリング、およびデータベースの相互作用など、さまざまなトピックをカバーしています。候補者は、PL / SQLプログラミングのコンセプトを熟知し、ビジネス要件を満たす効率的で保守性の高いコードを書くことができることが期待されます。

質問 # 23
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 result in an error because table depts has been altered.
B. It will run successfully producing a result of 4.
C. It will run successfully producing a result of 5.
D. DEP_VU must be manually recompiled to successfully run this code.

正解：B

質問 # 24
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

正解：B

質問 # 25
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, add the default parameter DEFAULT 2000.
C. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
D. In line 1, change IN OUT mode to IN mode.
E. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
F. In line 2, change IN OUT mode to IN mode.

正解：A、F

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

正解：A

質問 # 27
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

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

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

正解：B、C、E

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

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

正解：B、D

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

Which two are true? (Choose two.)

A. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
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 WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

正解：A、E

質問 # 31
Examine this DECLARE section:

Which two lines are valid? (Choose two.)

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

正解：C、D

質問 # 32
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. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
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

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

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

正解：A

質問 # 34
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

A. Object privileges to execute a replaced function are retained by those users who had the privileges.
B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
C. This clause can be used only for procedures and functions.
D. Function based indexes remain usable when replacing the function on which the index depends.
E. A function definition can be modified without dropping and re-creating it.

正解：A、E

質問 # 35
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 1
B. line 7
C. line 6
D. line 2
E. line 8
F. line 3

正解：A、C

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

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

正解：C、E

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

A. It can be used in the declaration of object types.
B. It must be specified in the heading of a package specification.
C. The check is enforced by this clause for direct access and access through dynamic SQL.
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 body.

正解：A、D

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

質問 # 38
In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)

A. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
B. Call HR.HELPER.H1 from the HR schema.
C. Call HR.API.P1 from the HR schema.
D. Call HR.API.P1 from the SH schema.
E. Call HR.HELPER.H1 from the SH schema.

正解：D、E

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

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

正解：B、D

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

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

正解：B、E、G

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

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

正解：A、D、F

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

Which three are true? (Choose three.)

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

正解：A、B、G

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