[2022年08月] 最新の1Z0-144試験問題集には合格保証が付きます [Q11-Q33]

[2022年08月] 最新の1Z0-144試験問題集には合格保証が付きます

信頼できるOther Oracle Certification 1Z0-144問題集PDFで2022年08月11日に更新された問題

Oracle 1Z0-144 認定試験の出題範囲：

トピック	出題範囲
トピック 1	PL SQLでメッセージを出力する
トピック 2	INTO句を使用してSQL文から返された値を保持する
トピック 3	％ROWTYPE属性を使用してレコードを作成する

質問 11
View the Exhibit and examine the structure of the departments table in SCOTT's schema.

Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the
procedure.
Which two statements are true in the above scenario? (Choose two.)

A. SCOTT should grant only the execute privilege for the procedure to JONES.
B. JONES executes the procedure with invoker's rights.
C. JONES executes the procedure with definer's rights.
D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

正解: A,C

質問 12
Which statements are true about database triggers? (Choose all that apply.)

A. They can include SQL and PL/SQL or calls to Java procedures.
B. They are implicitly fired when a triggering event occurs, depending on which user is connected
C. They are implicitly fired by an event that must occur within an application
D. They can invoke only PL/SQL procedures

正解: B,D

解説:
Reference:http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch15.htm

質問 13
Which two statements are true about the exit statement encounteredin loop? (Choose two)

A. The PL/SQL block execution terminates immediately after the exit statement.
B. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
C. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
D. The loop completes immediately and control passes to the statement after end loop

正解: B,D

解説:
Reference:http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm

質問 14
Examine the following code:

Which statement is true about the execution of the above code?

A. It executes and control goes to the else statement.
B. It fails because no value is assigned to the v_myage variable.
C. It executes and the condition returns true.
D. It executes and displays null.

正解: A

解説:
Explanation/Reference:
Explanation:

質問 15
Examine the following package specification:

Which statement is true?

A. g_comm has a value of 15 at 9:03 AM for both Jones and smith
B. g_comm has a value of 20 at 9:06 AM for both Jones and smith
C. g_comm has a value of 15 at 9:06 AM only for Jones
D. g_comm has a value of 10 at 9:03 AM for both Jones and smith

正解: C

解説:
Package variable state is scoped at the session level. So the only user who can see G_COMM=15 will be Jones

質問 16
View the Exhibit to examine the PL/SQL code.

Which statement is true about the execution of the code?

A. The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler
B. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock.
C. The exception raised in the code is handled by the exception handler for the PAST_DUE exception.
D. It does not execute because you cannot declare an exception with a similar name in the subblock.

正解: A

解説:
Explanation/Reference:
Explanation:

質問 17
In which of the following scenarios would you recommend using PL/SQL records?

A. when you want to retrieve an entire row from a table and perform calculations
B. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
C. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked
D. when you know the number of elements in advance and the elements are usually accessed sequentially

正解: B,C

質問 18
View the Exhibit and examine the structure of the employees table.

Execute the following block of code:

What is the outcome?

A. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
B. It gives an error because group functions cannot be used in anonymous blocks
C. It executes successfully and correctly gives the result of the sum of salaries in
department 60.
D. It gives an error because the variable name and column name are the same in the where clause of the select statement.

正解: A

質問 19
Identify two situations where the DBMS_SQL package should be used. (Choose two.)

A. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.
B. The select list is not known until run time.
C. You do not know how many columns a select statement will return, or what their data
types will
D. The dynamic SQL statement retrieves rows into records.

正解: B,C

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

A. Only subprograms can return values that persist after the execution of the subprogram.
B. Both anonymous blocks and subprograms can be parameterized.
C. Only subprograms are persistent database objects.
D. Only subprograms can be parameterized.
E. Both anonymous blocks and subprograms are persistent database objects
F. Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.

正解: A,C,F

質問 21
View the Exhibit and examine the structure of the departments table in SCOTT's schema.

Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)

A. SCOTT should grant only the execute privilege for the procedure to JONES.
B. JONES executes the procedure with invoker's rights.
C. JONES executes the procedure with definer's rights.
D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

正解: A,C

質問 22
View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?

A. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.
B. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.
C. It does not execute because the definition of type population is indexed by varchar2.
D. It executes successfully and gives the desired output.

正解: D

質問 23
Identify two situations where the DBMS_SQL package should be used. (Choose two.)

A. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.
B. You do not know how many columns a select statement will return, or what their data types will.
C. The dynamic SQL statement retrieves rows into records.
D. TheSELECTlist is not known until run time.

正解: B,D

質問 24
Which statement is true about transactions in PL/SQL?

A. A transaction can span multiple blocks.
B. SERVERPOINTS cannot be created in a PL/SQL block.
C. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.
D. A block can contain only a single transaction.

正解: A

解説:
Explanation/Reference:
Explanation:

質問 25
What is the correct definition of the persistent state of a packaged variable?

A. It is a private variable in a package body whose value is consistent across all current active sessions.
B. It is a public variable in a package specification whose value is consistent within a user session.
C. It is a public variable in a package specification whose value is always consistent across all current active sessions.
D. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.

正解: B

質問 26
Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

A. line 2
B. line 4
C. line 3
D. line 5

正解: C,D

解説:
Explanation/Reference:
Explanation:

質問 27
View Exhibit1 and examine the structure of the product table.

View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.

You then create the following trigger on the product table.
CREATE OR REPLACE TRIGGER check_price__trg BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price ON product FOR EACH ROW WHEN (nev.prod_id <> NVX(old.prod_id,0) OR New.prod__list_price <> NVL(old.prod_list_price, 0) ) BEGIN check_price (: new.prod_id) ; END /
Examine the following update command for an existing row in the product table.
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Why does it generate an error?

A. Because the column list specified with UPDATE in the trigger is not valid
B. Because both the procedure and trigger access the same table
C. Because the procedure call in the trigger is not valid
D. Because the WHEN clause cannot be used with a row-level trigger
E. Because the condition specified in the when clause is not valid

正解: E

質問 28
Which two statements are true about the %ROWTYPE attribute? (Choose two.)

A. It is used to declare a record that can hold multiple rows of a table.
B. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
C. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.
D. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.

正解: B,C

質問 29
The STRING_TAB table has the following structure:

View the Exhibit and examine the code.

What is the outcome on execution?

A. It displays Output buffer not long enough. This is my test string.-.
B. It displays only Output buffer not long enough, and exits the anonymous block.
C. It does not display any of the MEMS_PUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedure.
D. It displays only This is my test string. - Because EXCEPTION should have been defined in the anonymous block to get the error message.

正解: A

解説:
Explanation/Reference:
Explanation:

質問 30
View Exhibit1 and examine the structure of the DO table. View Exhibit2 and examine the code.

The anonymous block gives an error on execution. What Is the reason?

A. The assignment in line 7 is not valid.
B. The SQL does not support the Boolean data type.
C. The names of bind variables must be the same as the using clause bind arguments in line 10
D. A null value cannot be applied to the bind arguments In the using clause in line 10

正解: A

質問 31
View the Exhibit to examine the PL/SQL code. The record for the employee withemployee__id 100 in the employees table is as follows;

Identify the correct output for the code.

A. King current sysdate 24000
B. King current sysdate 1500
C. King 17-JUN-87 1500
D. King 17-JUN-87 24000

正解: D

質問 32
View the Exhibit to examine the PL/SQL code:

DECLARE
x NUMBER := 5;
y NUMBER := NULL;
BEGIN
IF x != y THEN - yields NULL, not TRUE
DBMS_OUTPUT.PUT_LINE('x != y'); - not run
ELSIF x = y THEN - also yields NULL
DBMS_OUTPUT.PUT_LINE('x = y');
ELSE
DBMS_OUTPUT.PUT_LINE
('Can't tell if x and y are equal or not.');
END IF;
END;
/
SREVROUPUT is on for the session. Which statement is true about the output of the PL/SQL block?