[2023年05月] 厳密検証された1Z0-149問題集と解答で1Z0-149問題集と正解付き [Q14-Q37]

[2023年05月] 厳密検証された1Z0-149問題集と解答で1Z0-149問題集と正解付き

ベストOracle Database PL/SQL Developer Certified Professional学習ガイドは1Z0-149試験合格させます

Oracle 1Z0-149試験に合格した候補者は、Oracle Database 19c PL/SQL開発者認定プロフェッショナル資格を取得します。この認定は、PL/SQLプログラミングの優れた標準として世界的に認知され、雇用主に高く評価されています。これにより、候補者はPL/SQLプログラミングのコンセプトに深い理解を持ち、Oracle Database 19c環境で複雑なソリューションを効果的に設計および実装できることが証明されます。

Oracle 1Z0-149試験は、サブプログラム、カーソル、トリガーの作成と使用の熟練度を試験するものです。候補者は、例外処理、コレクション、動的SQLの理解を証明する必要があります。また、SQL言語とPL/SQLとの統合についても熟知している必要があります。この試験は、75の多肢選択問題から構成され、120分間の試験時間があります。

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

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

正解：C

質問 # 15
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. The PL/SQL compiler can conditionally include selected parts of a program.
C. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
D. PL/SQL code can be compiled and executed based on different versions of Oracle.
E. PL/SQL code can be compiled and executed based on different versions of the operating system.

正解：B、D

質問 # 16
Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

A. Error in inner block Error in outer block
B. Error in inner block
C. Error in inner block Error in calling block
D. Error in inner block Error in outer block Error in calling block

正解：B

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

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

正解：D、E、G

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

Which two are true? (Choose two.)

A. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
B. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
C. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
D. Only the PRICE column can be updated in the PRODUCTS table.
E. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

正解：A、B

質問 # 19
Which three statements can process a dynamic multi-row query? (Choose three.)

A. OPEN
B. OPEN-FOR
C. FETCH
D. CLOSE
E. DECLARE
F. INTO
G. WHEN

正解：B、C、D

質問 # 20
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. Call HR.HELPER.H1 from the SH schema.
B. Call HR.API.P1 from the HR schema.
C. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
D. Call HR.HELPER.H1 from the HR schema.
E. Call HR.API.P1 from the SH schema.

正解：A、E

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

正解：D

質問 # 22
Which block of code displays the error message "Incorrect price value"?

正解：D

質問 # 23
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 for individual procedures and functions declared in a package specification.
C. It can be used in the declaration of object types.
D. It must be specified in the heading of a package body.
E. It must be specified in the heading of a package specification.

正解：B、C

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

質問 # 24
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 Definer is missing from MYPROC.
B. It executes successfully.
C. It results in an error because Authid Current_User is missing from MYPROC.
D. It results in an error because USERB doesn't have select privilege on USERA.EMP.

正解：B

質問 # 25
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

正解：B

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

A. This clause can be used only for procedures and functions.
B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
C. Object privileges to execute a replaced function are retained by those users who had the privileges.
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.

正解：C、E

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

正解：C

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

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

正解：A、B

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

正解：A、B

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

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

正解：A、C、D

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

A. In a function, every execution path must lead to a RETURN statement.
B. In a function every RETURN statement must specify an expression.
C. The ACCESSIBLE BY clause can be used only for procedures.
D. Both can be invoked from within SQL statements.
E. Both can have only constants as actual parameters for IN mode parameters.
F. In a procedure the RETURN statement cannot specify an expression.

正解：A、B、F

質問 # 32
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 will always automatically initialize v_raise.
C. It might return a run time error depending on who invokes it.
D. It will set all salaries to 0 if it executes successfully.
E. It will always return a run time error because v_raise is not initialized.
F. It will set all salaries to NULL if it executes successfully.

正解：B、F

質問 # 33
Examine this DECLARE section:

Which line will cause an error upon execution?

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

正解：B

質問 # 34
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 min_bal can be done while using this packaged constant in another program.
C. This will not compile successfully because the min_bal constant must be initialized.
D. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
E. Initialization of loan_amount can be done while using this packaged variable in another program.
F. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
G. This program unit will compile successfully.

正解：C、D、F

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