パスできる1Z0-149試験最速合格保証2023問題集！ [Q23-Q48]

パスできる1Z0-149試験最速合格保証2023問題集！

1Z0-149問題集完全版問題で試験学習ガイド

Oracle 1Z0-149 試験は、データ操作、例外処理、データベースオブジェクトの作成と管理、トリガーやパッケージなどの高度な機能の使用など、PL/SQL プログラミングに関連する広範なトピックをカバーしています。また、SQL プログラミングとデータベース管理に関する知識も試験対象となります。これらは、PL/SQL 開発者にとって必須のスキルです。

1z1-149試験は、PL/SQLプログラミングの概念、データベース設計、データ操作、エラーハンドリング、パフォーマンスチューニングなど、広範なトピックをカバーしています。また、動的SQL、コレクション、オブジェクト指向プログラミングなどの高度なPL/SQL機能に関する知識も評価されます。この試験に合格することは、個人がPL/SQLとOracle Database 19cを使用して複雑なデータベースアプリケーションを開発するために必要なスキルと知識を持っていることを示し、世界的に認められ、IT業界で高く評価されるOracle PL/SQL Developer Certified Associate資格を取得することになります。

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

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

正解：A、D

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

質問 # 24
Which three are true about DDL triggers? (Choose three.)

A. They fire only when a DDL statement is executed by the owner of the trigger.
B. They must be created in a disabled state.
C. They can be fired either before or after a DDL statement executes.
D. They must be created in an enabled state.
E. They cannot include the WHEN clause.
F. They can be fired when a privilege is granted to a user.
G. They can be fired when a table is truncated.

正解：A、C、G

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

質問 # 26
Examine these statements:

Which is true?

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

正解：B

質問 # 27
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

A. The RETURNING clause can be used for remote or parallel deletes.
B. The RETURNING INTO clause and bulk binds may not be used together.
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 INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

正解：A、E

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

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

正解：B

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

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

正解：A、B、F

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

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

正解：B、E、G

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

正解：B、C

質問 # 32
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 "-20000 to -20999."
B. It will result in an error as the range of the error code can only be from "-1000 to -2000."
C. It will result in an error as the range of the error code can only be from "-2000 to -2999."
D. It will execute successfully and will display the user-defined error message.

正解：A

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

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

正解：B、C、E

質問 # 34
Which is true about EXIT and CONTINUE statements?

A. They can be used in any type of loop.
B. They have the same effect on the execution of a loop.
C. They must use labels.
D. They must have a WHEN condition.

正解：A

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

正解：C

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

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

正解：B

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

正解：C、D

質問 # 38
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 salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
C. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
D. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
E. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

正解：C、E

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

正解：C

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

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

正解：A、D

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

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

正解：C、E

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

Which two are true? (Choose two.)

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

正解：A、E

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

正解：A、F

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

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

正解：A、B、D

質問 # 45
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. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
C. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.
D. Any optional parameters can be omitted in the invocation call.
E. Only trailing optional parameters can be omitted in the invocation call.

正解：A、D

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

正解：B、D

質問 # 47
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?