1Z0-144 Online Practice Questions and Answers

Which two tasks should be created as functions instead of as procedures? (Choose two.)

A. Reference host or bind variables in a PL/SQL block of code

B. Tasks that compute and return multiple values to the calling environment

C. Tasks that compute a value that must be returned to the calling environment

D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application

Which two statements are correct about the usage of parameters in functions? (Choose two.)

A. Functions can have only in mode parameters.

B. Functions called in SQL statements cannot have out or in out mode parameters.

C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms

D. Functions having in, out, or in out parameters can be called in PL/SQL procedures and anonymous blocks.

Identify two features of obfuscation. (Choose two.)

A. The Import and Export utilities accept wrapped files.

B. SQL' Plus cannot process the obfuscated source files.

C. Only the wrap utility can obfuscate multiple programs at a time.

D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.

E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View

ORDER_TOTAL is a column in the ORDERS table with the data type and size as NUMBER (8, 2). Examine the following code:

Which statement is correct about the above code?

A. It gives an error in line 3.

B. It gives an error in line 4.

C. It gives an error in line 6.

D. It executes successfully and displays the output.

View the Exhibit and examine the blocks of code that you plan to execute.

Which statement is true about the blocks of code?

A. All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.

B. All the blocks execute successfully and the anonymous block displays123cut: 045cart: 1.

C. The anonymous block gives an error because the function invocation in line 2 is not valid.

D. The procedure creation gives an error because the function invocation in line 1 is not valid.

Which two statements are correct about PL/SQL package components? (Choose two.)

A. A package must have both specification and body.

B. A package body can exist without the package specification.

C. A package specification can exist without the package body.

D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

Examine the following snippet of PL/SQL code:

View the Exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.

Identify OPEN statements for opening the cursor that fetches the result set consisting of employees with JOB_ID as `ST_CLERK' and SALARY greater than 3000. (Choose three.)

A. OPEN c1 (NULL, 3000);

B. OPEN c1 (emp_job, 3000);

C. OPEN c1 (3000, emp_salary);

D. OPEN c1 (`ST_CLERK', 3000)

E. OPEN c1 (emp_job, emp_salary);

Examine the following code: The above code generates an error on execution.

What must you do to ensure that the code executes successfully?

A. Use the TO_DATE function in line 2.

B. Use the TO_DATE function in line 7.

C. Use the TO_NUMBER function in line 6.

D. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.

Which three statements are true about wrapping? (Choose three.)

A. The PL/SQL wrapper detects and reports only syntactic errors.

B. The PL/SQL wrapper detects and reports both syntactic and semantic errors.

C. When wrapping a package or object type, both the body and specification should be wrapped.

D. When wrapping a package or object type, only the body should be wrapped, not the specification.

E. To change a wrapped object, the original source code needs to be modified and then wrapped again.

F. To change a wrapped object, the wrapped code can be unwrapped, modified in a text file, and then wrapped again.

Which two statements are true about the EXIT statement encountered in LOOP? (Choose two.)

A. The PL/SQL block execution terminates immediately after the EXIT statement.

B. The loop completes immediately and control passes to the statement after END LOOP.

C. The statements after the EXIT statement in the iteration are not executed before terminating the LOOP.

D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.