[2023年12月30日] 365日更新、有効な1Z0-149知能問題集 [Q10-Q33]

[2023年12月30日] 365日更新、有効な1Z0-149知能問題集

ベスト品質の1Z0-149試験問題集でOracleテスト高得点を目指そう

Oracle 1Z0-149 認定試験は、PL/SQLプログラミングにおける専門知識を証明したいデータベース専門家にとって必須の要件です。データベース開発、管理、プログラミングに関連する広範なトピックをカバーし、Oracle Database 19cの機能とベストプラクティスの理解が必要です。この試験に合格することは、認定された専門家にとって新しいキャリアチャンスと高い給与をもたらす貴重な成果です。

 

質問 # 10
Examine this code:

What will be the outcome?

• A. It will result in an error as the range of the error code can only be from "-2000 to -2999."
• B. It will execute successfully and will display the user-defined error message.
• C. It will result in an error as the range of the error code can only be from "-1000 to -2000."
• D. It will result in an error as the range of the error code can only be from "-20000 to -20999."

正解：D

質問 # 11
Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

• A. It returns an error in line 4.
• B. It executes and displays output.
• C. It returns an error in line 9.
• D. It returns an error in line 2.

正解：A

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

正解：B、C

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

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

正解：B

質問 # 14
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

• A. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
• B. %Isopen is always false in Implicit Cursor.
• C. %Isopen is always false in Explicit Cursor.
• D. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
• E. Implicit cursor returns only one record.
• F. Explicit cursor can return more than one record.
• G. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

正解：B、F、G

質問 # 15
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. Collections can be implicitly converted to records.
• C. ROWIDS are always implicitly converted to a number when used in a query.
• D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
• E. Implicit data type conversion can negatively impact performance.

正解：D、E

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

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

正解：A、D

質問 # 17
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 Error in calling block
• B. Error in inner block
• C. Error in inner block Error in outer block
• D. Error in inner block Error in calling block

正解：B

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

正解：C

質問 # 19
Which three are true about anonymous blocks and subprograms? (Choose three.)

• A. Anonymous blocks cannot use packaged variables.
• B. Named subprograms are stored in the database server.
• C. PROCEDURE subprograms can accept parameters.
• D. Named subprograms cannot be called from other packages.
• E. Anonymous blocks must always start with the Declare keyword.
• F. FUNCTION subprograms must be called and passed through one or more parameters.
• G. A FUNCTION subprogram must return one or more values.

正解：B、C、G

質問 # 20
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

• A. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
• B. The PARALLEL_ENABLE clause can be specified for a nested function.
• C. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
• D. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
• E. A deterministic function's results always depend on the state of session variables.
• F. A function is deterministic if it always returns the same result for a specific combination of input values.
• G. The NOCOPY hint asks the compiler to pass the actual parameters by value.

正解：A、C、F

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

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

正解：A、D、G

質問 # 22
Examine this DECLARE section:

Which two lines are valid? (Choose two.)

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

正解：E、F

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

正解：A、F

質問 # 24
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

• A. No update happens even though the procedure executes successfully.
• B. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
• C. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
• D. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
• E. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

正解：B、E

質問 # 25
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. A function definition can be modified without dropping and re-creating it.
• 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. Object privileges to execute a replaced function must be regranted to those users who had the privilege.

正解：B、C

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

正解：A、B

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

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

正解：C、E、F

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

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

正解：B、D、G

質問 # 29
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 constants, to which values cannot be assigned by the subprogram.
• C. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
• D. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
• E. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
• F. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
• G. The actual parameter must be a variable when calling a subprogram with an OUT parameter.

正解：B、F、G

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

Which three are true? (Choose three.)

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

正解：B、C、F

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

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

正解：A、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.

正解：B、E

質問 # 33
......

注目すべき時短になる1Z0-149オールインワン試験ガイド：https://www.passtest.jp/Oracle/1Z0-149-shiken.html

検証された材料は決まってこれ！1Z0-149：https://drive.google.com/open?id=1ZETYgi36OhfM1zABm-bb_JJNzhzvsBha