1Z0-149練習テスト問題は更新された67問題あります
Oracle 1Z0-149問題集で一発合格できる問題を試そう！
質問 # 22
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 variables, to which values can be assigned by the subprogram.
- C. OUT parameters returning values to calling subprograms act like constants in the called subprogram.
- D. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
- E. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the 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.
正解：E、F、G
質問 # 23
Which two blocks of code display a numerical zero? (Choose two.)
- A.
- B.
- C.
- D.
正解：A、B
質問 # 24
Which two are true about exception handling? (Choose two.)
- A. Internally defined exceptions can be handled only by the OTHERS exception handler.
- B. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
- C. All declared exceptions are raised implicitly by the runtime system.
- D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- E. Predefined exceptions are globally declared in the standard package.
正解：B、E
質問 # 25
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. DEP_VU must be manually recompiled to successfully run this code.
- B. It will result in an error because table depts has been altered.
- C. It will run successfully producing a result of 4.
- D. It will run successfully producing a result of 5.
正解：C
質問 # 26
For which three SYSTEM EVENTS can triggers be created? (Choose three.)
- A. BEFORE GRANT
- B. DDL
- C. BEFORE ANALYZE
- D. SHUTDOWN
- E. SERVERERROR
- F. AFTER AUDIT
- G. STARTUP
正解：D、E、G
質問 # 27
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. DISABLE
- B. ENABLE
- C. ALL
- D. SEVERE
- E. ERROR
正解：C、D
質問 # 28
Which three are true about PL/SQL subprograms? (Choose three.)
- A. A PL/SQL procedure can invoke an external code block written in a different programming language.
- B. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
- C. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
- D. Host variables can be referenced inside any PL/SQL subprogram.
- E. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- F. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- G. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
正解：A、C、G
質問 # 29
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING INTO clause and bulk binds may not be used together.
- B. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- C. The RETURNING INTO clause returns column values for rows affected by DML statements.
- D. When using the RETURNING INTO clause, the data returned can be only single column or expression.
- E. The RETURNING clause can be used for remote or parallel deletes.
正解：B、E
質問 # 30
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
質問 # 31
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
正解：D
質問 # 32
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
- B. The default value is NATIVE.
- C. If set to NATIVE, programs are stored in platform dependent machine code.
- D. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- E. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
正解：C、E
質問 # 33
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 executes and displays output.
- B. It returns an error in line 4.
- C. It returns an error in line 9.
- D. It returns an error in line 2.
正解：B
質問 # 34
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.
正解：A
質問 # 35
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 can be a nested subprogram.
- C. Each procedure's formal parameters must differ in name.
- D. Each procedure can be a packaged subprogram.
- E. Each procedure can be a standalone subprogram.
- F. Each procedure must use named notation to specify the corresponding actual parameters.
- G. Each procedure's formal parameters can differ in data type or name.
正解：A、D、G
質問 # 36
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 2
- B. line 3
- C. line 4
- D. line 6
- E. line 5
正解：D
質問 # 37
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It can be used to control execution of specific portions of the PL/SQL code conditionally.
- B. It is deprecated in Oracle 12c.
- C. It can be used to obtain information about all identifiers when compiling a procedure.
- D. It can be used to control a user's privileges on PL/SQL objects at run time.
正解：C
質問 # 38
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. CLOSE
- B. WHEN
- C. OPEN-FOR
- D. FETCH
- E. INTO
- F. OPEN
- G. DECLARE
正解：A、C、D
質問 # 39
Which three are valid PL/SQL variable names? (Choose three.)
- A. 1to7number
- B. #printer_name
- C. yesterday's_date
- D. v_fname
- E. Number_of_days_between_March_and_April
- F. leap$year
- G. printer_name#
正解：D、F、G
質問 # 40
......
Oracle 1Z0-149試験問題集で[2023年最新] 練習有効な試験問題集解答：https://jp.fast2test.com/1Z0-149-premium-file.html
1Z0-149問題集を掴み取れ！[最新2023]Oracle試験が合格できます：https://drive.google.com/open?id=1_WqH7SkBPuRgkLe5dU60IKMsB01sU6C9