問題集は全額返金保証付きの1z1-149問題集最大50%オフ [Q11-Q36]

問題集は全額返金保証付きの1z1-149問題集最大50%オフ

更新されたのは2023年05月合格させる1z1-149試験にはリアル練習テスト問題

質問 # 11
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

• A. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
• B. The PL/SQL compiler can conditionally include selected parts of a program.
• C. Conditional compilation is disabled by default.
• D. PL/SQL code can be compiled and executed based on different versions of the operating system.
• E. PL/SQL code can be compiled and executed based on different versions of Oracle.

正解：B、E

質問 # 12
Examine this DECLARE section:

Which two lines are valid? (Choose two.)

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

正解：A、D

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

• A.
• B.
• C.
• D.

正解：D

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

質問 # 15
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、E

質問 # 16
Which two are true about lexical units? (Choose two.)

• A. A character literal with zero characters has the BOOLEAN value NULL.
• B. All user-defined identifiers must start with an alphabet.
• C. Spaces can be embedded in delimiters.
• D. Character literals are case-sensitive.
• E. Identifiers include labels.

正解：B、D

質問 # 17
Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

• A. It will return an error at line 8.
• B. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
• C. It will return an error at line 3.
• D. It will return an error at line 2.
• E. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

正解：E

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

正解：B、C、F

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

• A. It must be specified in the heading of a package specification.
• B. The check is enforced by this clause for direct access and access through dynamic SQL.
• C. It must be specified in the heading of a package body.
• D. It can be used in the declaration of object types.
• E. It can be used for individual procedures and functions declared in a package specification.

正解：D、E

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

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

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

正解：A、E、F

質問 # 21
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 returns column values for rows affected by DML statements.
• C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
• D. The RETURNING clause can be used for remote or parallel deletes.
• E. When using the RETURNING INTO clause, the data returned can be only single column or expression.

正解：C、D

質問 # 22
Examine these statements which execute successfully:

Which anonymous block executes successfully?

• A.
• B.
• C.
• D.

正解：D

質問 # 23
Which three are true about PL/SQL subprograms? (Choose three.)

• A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
• B. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
• C. Host variables can be referenced inside any PL/SQL subprogram.
• D. A PL/SQL procedure can invoke an external code block written in a different programming language.
• E. 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.
• F. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
• G. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

正解：A、B、D

質問 # 24
Which two are true about packages? (Choose two.)

• A. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
• B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
• C. Package specifications can be compiled without their bodies.
• D. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.
• E. A package definition must have a specification and body.

正解：C、D

質問 # 25
Examine these statements:

Which is true?

• A. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
• B. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
• C. It will result in a compilation error for protected_proc because calling_proc does not exist.
• D. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

正解：C

質問 # 26
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. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
• C. Collections and RECORD types are always dense.
• D. Only associative arrays and nested tables can have elements of RECORD type.
• E. A variable of RECORD type can contain fields of another RECORD type or any collection type.
• F. All collections and RECORD types can be stored in table columns.

正解：B、D

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

Which two are true? (Choose two.)

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

正解：B、E

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

正解：C、F

質問 # 29
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 procedure
• C. a predefined PL/SQL-only data type like BOOLEAN
• D. a record declared in an anonymous block
• E. an associative array indexed by VARCHAR2
• F. a record declared in a package specification

正解：A、E、F

質問 # 30
Which statement is true about user-defined records?

• A. Field names must match selected column names.
• B. The number of fields must match the number of columns in a table.
• C. They can be returned from a function.
• D. Field types must match column types.

正解：B

質問 # 31
Examine these statements:

Which two are true? (Choose two.)

• A. The bank_activity_proc will not compile because of the commit.
• B. Both tables will have a row inserted and committed.
• C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
• D. Only one table will have a row inserted and committed.
• E. Neither table will have a row inserted and committed.

正解：C、D

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

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

正解：C、D、F

質問 # 33
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. 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. Internally defined exceptions can be handled only by the OTHERS exception handler.

正解：A、B

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

正解：A、E

質問 # 35
Which is true about counter variables in a FOR loop?

• A. It is accessible outside the body of the loop.
• B. It cannot be NULL.
• C. It can be modified in the body of the loop.
• D. It must explicitly be declared.

正解：B

質問 # 36
......

Oracle 1z1-149試験は、Oracle Database 19c認定を取得したいプロフェッショナル向けに設計されています。試験は、Oracle Database 19cを使用してPL/SQLプログラムを開発、デバッグ、実行するために必要な知識とスキルをテストします。試験は、プログラム構造、制御構造、コレクション、エラーハンドリングなど、PL/SQLに関連するさまざまなトピックをカバーしています。

Oracle 1Z0-149試験は、Oracleデータベースで使用されるSQLの手続き型言語拡張であるPL/SQLでのプログラミングの認定を取得したいと考えている専門家向けに設計されています。この試験は、Oracle Database 19c PL/SQL Developer Certified Associate認定を取得するための要件の1つです。

 

無料ダウンロードOracle 1z1-149リアル試験問題：https://jp.fast2test.com/1z1-149-premium-file.html

あなたを合格させる試験には100%検証済みの1z1-149試験問題：https://drive.google.com/open?id=1ZuHcIUZyShmKBowm29TtEVEMLP0yLuR3