最新の[2023年07月13日]1Z0-149試験問題集で有効で更新された問題集
無料お試しまもなく終了！100%有効な1Z0-149試験問題集には67問があります
質問 # 20
Which three are true about user-defined functions? (Choose three.)
- A. Functions can call only other functions.
- B. They can appear in the select list of a SELECT statement.
- C. They must be defined with at least one parameter.
- D. They can be used in ORDER BY and GROUP BY clauses.
- E. They can be executed as standalone commands.
- F. They can be used in CONNECT BY and START WITH clauses.
- G. They need not return any values.
正解：B、D、F
質問 # 21
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 execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
- D. It will fail only at line 7.
正解：D
質問 # 22
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.API.P1 from the HR schema.
- B. Call HR.HELPER.H1 from the HR schema.
- C. Call HR.API.P1 from the SH schema.
- D. Call HR.HELPER.H1 from the SH schema.
- E. Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
正解：C、D
質問 # 23
Which two are true about packages? (Choose two.)
- A. Package specifications can be compiled without their bodies.
- B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
- C. A package definition must have a specification and body.
- D. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
- E. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
正解：A、D
質問 # 24
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. Implicit data type conversion can negatively impact performance.
- D. ROWIDS are always implicitly converted to a number when used in a query.
- E. Comparison between character value and a number value always implicitly converts the character value to the number data type.
正解：C、E
質問 # 25
Which three are true about anonymous blocks and subprograms? (Choose three.)
- A. Anonymous blocks cannot use packaged variables.
- B. FUNCTION subprograms must be called and passed through one or more parameters.
- C. A FUNCTION subprogram must return one or more values.
- D. Named subprograms cannot be called from other packages.
- E. Anonymous blocks must always start with the Declare keyword.
- F. PROCEDURE subprograms can accept parameters.
- G. Named subprograms are stored in the database server.
正解：C、F、G
質問 # 26
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)
- A. an associative array indexed by PLS_INTEGER
- B. a record declared in a package specification
- C. a predefined PL/SQL-only data type like BOOLEAN
- D. a record declared in an anonymous block
- E. a record declared in a procedure
- F. an associative array indexed by VARCHAR2
正解：A、B、F
質問 # 27
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. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
- C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
- D. The actual parameter must be a variable when calling a subprogram with an OUT parameter.
- E. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
- F. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
- G. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
正解：C、D、G
質問 # 28
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 6
- B. line 8
- C. line 1
- D. line 7
- E. line 3
- F. line 2
正解：A、C
質問 # 29
Which three are true about the procedure overloading feature? (Choose three.)
- A. Each procedure can be a packaged subprogram.
- B. Each procedure must use positional notation to specify the corresponding actual parameters.
- C. Each procedure must use named notation to specify the corresponding actual parameters.
- D. Each procedure can be a standalone subprogram.
- E. Each procedure can be a nested subprogram.
- F. Each procedure's formal parameters must differ in name.
- G. Each procedure's formal parameters can differ in data type or name.
正解：A、B、G
質問 # 30
Which two blocks of code display a numerical zero? (Choose two.)
- A.
- B.
- C.
- D.
正解：B、C
質問 # 31
Which three are valid PL/SQL variable names? (Choose three.)
- A. 1to7number
- B. printer_name#
- C. v_fname
- D. leap$year
- E. Number_of_days_between_March_and_April
- F. yesterday's_date
- G. #printer_name
正解：B、C、D
質問 # 32
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
質問 # 33
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. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
- 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. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- F. CBAC cannot be used to secure definer's rights.
- G. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
正解：A、E、G
質問 # 34
In which type of trigger can :OLD and :NEW identifiers be used?
- A. AFTER SUSPEND
- B. ROW
- C. AFTER STATEMENT
- D. BEFORE STATEMENT
正解：B
質問 # 35
......
Oracle 1z1-149試験は、PL/SQLを使用してアプリケーションを開発およびプログラムする経験を持つ個人を対象としています。この試験は、Oracle Database 19cを使用した効率的でスケーラブルなデータベースアプリケーションの作成能力レベルをテストすることに焦点を当てています。試験は70問の多肢選択問題からなり、受験者は105分間で試験を完了する必要があります。
1Z0-149試験問題集で100%高得点させる1Z0-149試験解答がこちら：https://jp.fast2test.com/1Z0-149-premium-file.html
検証済みの1Z0-149試験問題成功確定させます：https://drive.google.com/open?id=1_WqH7SkBPuRgkLe5dU60IKMsB01sU6C9