結果を保証するには最新2024年08月無料Oracle 1Z0-149で練習しよう [Q13-Q37]

結果を保証するには最新2024年08月無料Oracle 1Z0-149で練習しよう

有効な問題最新版を無料で試そう1Z0-149試験問題集解答

Oracle 1Z0-149試験を正常に完了すると、PL/SQLを使用した堅牢で効率的なデータベースアプリケーションの開発における候補者の習熟度が示されています。この認定は、IT業界で高く評価されており、データベース開発の分野でのキャリアの成長と進歩を求める専門家に競争力を提供します。

この試験は、ブロック、データ型、制御構造、コレクション、サブプログラム、例外を含むPL/SQLプログラミングに関連するさまざまなトピックをカバーする80の多肢選択質問で構成されています。候補者は、JSONサポート、多型テーブル機能、シャードなど、Oracle Database 19Cの最新機能に精通していることが期待されています。

 

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

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

正解：B

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

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

• A. PL/SQL code can be compiled and executed based on different versions of Oracle.
• B. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
• 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. The PL/SQL compiler can conditionally include selected parts of a program.

正解：A、E

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

正解：D

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

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

正解：C、D、F

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

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

正解：D

質問 # 19
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

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

正解：D

質問 # 20
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

• A. It will always automatically initialize v_raise.
• B. It will always return a run time error because v_raise is not initialized.
• C. It will always return a compile time error because it lacks an EXCEPTION section.
• D. It might return a run time error depending on who invokes it.
• E. It will set all salaries to 0 if it executes successfully.
• F. It will set all salaries to NULL if it executes successfully.

正解：A、F

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

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

正解：B、F、G

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

正解：A、E

質問 # 23
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

• A. Function based indexes remain usable when replacing the function on which the index depends.
• B. This clause can be used only for procedures and functions.
• C. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
• D. A function definition can be modified without dropping and re-creating it.
• E. Object privileges to execute a replaced function are retained by those users who had the privileges.

正解：D、E

質問 # 24
Examine these statements which execute successfully:

Which anonymous block executes successfully?

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

正解：B

質問 # 25
Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

• A. A severe compilation warning is generated.
• B. An information compilation warning is generated.
• C. A performance compilation warning is generated.
• D. It fails compilation.
• E. There are no compilation warnings or errors.

正解：C

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

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

正解：C、E、G

質問 # 27
Which two are true about collections and RECORD types? (Choose two.)

• A. Only associative arrays and nested tables can have elements of RECORD type.
• B. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
• C. A variable of RECORD type can contain fields of another RECORD type or any collection type.
• D. All collections and RECORD types can be stored in table columns.
• E. Collections and RECORD types are always dense.
• F. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

正解：A、B

質問 # 28
Which two are true about implicit data type conversion? (Choose two.)

• A. ROWIDS are always implicitly converted to a number when used in a query.
• 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. Collections can be implicitly converted to records.
• E. Comparison between character value and a number value always implicitly converts the character value to the number data type.

正解：C、E

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

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

正解：A

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

Which two are true? (Choose two.)

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

正解：C、D

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

正解：A、D

質問 # 32
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、C

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

正解：B、D、F

質問 # 34
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 9.
• B. It returns an error in line 2.
• C. It returns an error in line 4.
• D. It executes and displays output.

正解：C

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

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

正解：B、D、F

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

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

正解：A、B

質問 # 37
......

Oracle 1z1-149試験、またはOracle Database 19c：PL / SQLでプログラムを行うための試験は、Oracle Database 19cおよびそのプログラミング言語であるPL / SQLで作業したい候補者のスキルをテストするように設計されています。この認定試験は、PL / SQLを使用してデータベースオブジェクトを作成、管理、操作する必要がある開発者およびデータベース管理者を対象としています。試験は、候補者のPL / SQL言語構造、プログラム構造、およびデータベースオブジェクトに関する知識をテストします。

 

1Z0-149ブレーン問題集PDF、Oracle 1Z0-149試験問題詰合せ：https://jp.fast2test.com/1Z0-149-premium-file.html

2024年最新の1Z0-149サンプル問題は信頼され続ける1Z0-149テストエンジン：https://drive.google.com/open?id=1_WqH7SkBPuRgkLe5dU60IKMsB01sU6C9