Q1. Which type of exceptions is qualified as no predefined Oracle server errors? 

A. the exceptions that are explicitly raised by the program and can be caught by the exception handler 

B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler 

C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly 

D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit 

View Answer

Q2. View the Exhibit and examine the structure of the employees table. 

Examine the following block of code: 

What is the outcome when the above code is executed? 

A. It executes successfully. 

B. It gives an error because decode cannot be used in a PL/SQL block. 

C. It gives an error because the AVG function cannot be used in a PL/SQL block 

D. It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block. 

E. It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block. 

View Answer

Q3. 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. A null value cannot be applied to the bind arguments In the using clause in line 10 

D. The names of bind variables must be the same as the using clause bind arguments in line 10 

View Answer

Q4. 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 Answer

Q5. 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. It traps all the exceptions that are not already trapped. 

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

View Answer

Q6. 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. 

View Answer

Q7. Examine the following package specification: 

Which statement is true? 

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

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

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 

View Answer

Q8. Examine the following code: 

Which two statements are true about the above function? (Choose two.) 

A. It can be used only in a parallelized query. 

B. It can be used in both a parallelized query and a parallelized DML statement. 

C. It can be used only in a parallelized data manipulation language (DML) statement. 

D. It can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in parallel. 

E. It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimization. 

View Answer

Q9. View Exhibit1 and examine the structure of the EMP table. 

View Exhibit2 and examine the code created by the user SCOTT: 

SCOTT grants the necessary privileges to green to access the EMP table and execute the package. 

Examine the following sequence of activities: 

SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command. 

SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command. 

green starts a session while SCOTT’s session is running and issues THE SQL>EXEC 

CURS_PKG.NEXT command. 

SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command. 

The EMP table contains sequential EMPNOS from 100 through 108. 

Which statement correctly describes the output? 

A. SCOTT’s session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT’s session shows an error. 

B. SCOTT’s session shows the EMPNO 100, GREEN'S session shows EMPNO 100, and SCOTT’s session shows the EMPNO 101. 

C. SCOTT’s session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT’s session shows the second EMPNO 101. 

D. SCOTT’s session shows the EMPNO 100, GREEN'S session shows EMPNO 101, and SCOTT’s session shows the second EMPNO 102. 

View Answer

Q10. Examine the following PL/SQL code: 

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

A. It executes successfully. 

B. It generates a run-time exception. 

C. It does not execute because of syntax error 

D. It executes successfully and generates a warning. 

View Answer