Oracle 1Z0-144 : Oracle Database 11g: Program with PL/SQL

아는 것과 시험장에서 풀어내는 것은 다릅니다. ITDumpsKR의 1Z0-144 모의고사는 실제 시험 환경을 그대로 재현해 103문항을 시간 제한 속에 연습할 수 있게 해 줍니다. 2026년 Oracle Database 11g: Program with PL/SQL 응시 전에 실전 감각을 미리 다듬어 두십시오.

Oracle 1Z0-144 시험 개요:

Oracle 1Z0-144 시험 요강 주제:

1Z0-144 시험에 대해 자주 묻는 질문

최신 Other Oracle Certification 1Z0-144 무료샘플문제

문제 #1

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

A. A function can return multiple values using a single return clause,
B. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
C. A function can contain zero or more parameters that are transferred from the calling environment.
D. A procedure can contain a return statement without a value.

문제 #2

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

A. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.
B. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled
C. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.
D. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

문제 #3

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What would be the outcome when the code is executed?

A. It executes successfully.
B. It gives an error because the SAL variable is not visible in the increase function.
C. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.
D. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.

문제 #4

Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

A. Reference tables indirectly by using views.
B. When adding new items to a package, add them to the beginning of the package.
C. When adding new items to a package, add them to the end of the package.
D. Reference tables directly avoid using views.

문제 #5

Identify two features of obfuscation. (Choose two.)

A. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
B. Only the wrap utility can obfuscate multiple programs at a time.
C. SQL' Plus cannot process the obfuscated source files.
D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
E. The Import and Export utilities accept wrapped files.

질문과 대답: