최신 1Z0-144 무료덤프 - Oracle Database 11g: Program with PL/SQL

문제1

Examine the following PL/SQL code:

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

A. The program abruptly terminates and an exception is raised.

B. The program executes successfully and the query fetches a null value in the V_LNAME variable.

C. Program executes successfully, fetches a NULL value in the V_LNAME variable and an
exception is raised.

D. The program executes successfully and the output is No ROWS_FOUND.

정답: A

문제2

Which two statements correctly differentiate functions and procedures? (Choose two.)

A. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.

B. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.

D. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.

정답: B,C

문제3

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

A. Only SCOTT

B. SCOTT, HR, and SYS

C. Only HR

D. SCOTT and HR

정답: C

문제4

View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.

Examine the following sequence of commands issued by SCOTT:

What is the outcome?

A. SCOTT'S session displays 5, and then 0, greets session displays 0.

B. SCOTT'S session displays 5, and then 0; green's session displays 5.

C. SCOTT'S session displays 5, and then 5 again; green's session displays 5.

D. SCOTT'S session displays 5, and then 5 again, green's session displays 0.

정답: B

문제5

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

A. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.

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 in a package body whose value is consistent across all current active sessions.

정답: B

문제6

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

A. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

B. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

C. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

D. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

정답: B,C

문제7

Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)

A. It can be the first exception handler.

B. It can be the only exception handler for the code.

C. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.

D. It traps all the exceptions that are not already trapped.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Examine the following package specification:

Which statement is true?

A. g_comm has a value of 10 at 9: 03 AM for both Jones and smith

B. g_comm has a value of 15 at 9: 06 AM only for Jones

C. g_comm has a value of 15 at 9: 03 AM for both Jones and smith

D. g_comm has a value of 20 at 9: 06 AM for both Jones and smith

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제9

View Exhibit 1 and examine the structure of the EMP table.

View Exhlbit2 and examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

A. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

B. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

C. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

D. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

정답: C

문제10

View the Exhibit to examine the PL/SQL block.

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

A. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

B. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

C. It executes successfully and gives the desired output.

D. It does not execute because the definition of type population is indexed by VARCHAR2.

정답: C

최신 1Z0-144 무료덤프 - Oracle Database 11g: Program with PL/SQL

우리와 연락하기

유용한 링크

최신 업데이트