1Z0-144 Online Practice Questions and Answers

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

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.

Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

A. The procedures can be either stand-alone or packaged.

B. The procedures should be created only as packaged subprograms.

C. The procedures should be created only as stand-alone subprograms.

D. Each subprogram's formal parameters should differ in both name and data type.

E. The formal parameters of each subprogram should differ in data type but can use the same names.

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.

Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)

A. It should be an after trigger.

B. It should be a before trigger.

C. It should be a row-level trigger.

D. It should be a statement-level trigger.

E. It can be a before or an after trigger.

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.

View the Exhibit and examine the structure of the EMPLOYEES table.

Execute the following block of code:

SQL > SET SERVEROUTPUT ON

What is the outcome?

A. It gives an error because the variable name and column name are the same in the WHERE clause of the SELECT statement.

B. It executes successfully and displays the sum of salaries in department 60.

C. It gives an error because group functions cannot be used in anonymous blocks.

D. It executes successfully and displays the incorrect sum of salaries in department 60.

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 output is No ROWS_FOUND.

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

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

View the Exhibit to examine the PL/SQL block.

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

A. It executes and the output is emprec.deptname:.

B. It executes and the output is emprec.deptname: Sales.

C. It produces an error because NULL is assigned to the emprec.empid field in the record.

D. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

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

View Exhibit 2 and examine the PIVSQL block of code.

What is the outcome?

A. It gives an error because the return type is not valid.

B. It gives an error because the record type is not defined within the function.

C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid.

D. It executes successfully and displays the names and salaries of all employees who earn the highest salary.

E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.

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

A. Only subprograms can be parameterized.

B. Only subprograms are persistent database objects.

C. Both anonymous blocks and subprograms can be parameterized.

D. Both anonymous blocks and subprograms are persistent database objects.

E. Only subprograms can return values that persist after the execution of the subprogram.

F. Both anonymous blocks and subprograms can return values that persist in SQL*Plus variables after their execution.