Q1. View Exhibit 1 and examine the structure of the EMP and dept tables. 

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table. 

What is the outcome on compilation? 

A. It compiles and executes successfully. 

B. It gives an error on compilation because it is not a row-level trigger. 

C. It gives an error on compilation because the exception section Is used in the trigger. 

D. It compiles successfully but gives an error on execution because it is not a row-level trigger. 

View Answer

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

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

Q4. Examine the following partial declare section from a block of PL/SQL code 

Which line(s) in the above code are NOT valid? (Choose all that apply.) 

A. line 2 

B. line 3 

C. line 4 

D. line 5 

View Answer

Q5. View the Exhibit and examine the structure of the customer table. 

You need to create a trigger to ensure that customers in category “A” and “B” have a credit 

limit of more than 8000. 

Examine the following trigger. 

Which statement is correct about the outcome of this trigger? 

A. It compiles successfully and fires whenever the specified condition is met. 

B. It compiles successfully but does not fire even when the condition is met 

C. It gives an error on compilation because the new qualifier is prefixed with a colon. 

D. It gives an error on compilation because the new qualifier can be used only in row-level triggers. 

View Answer

Q6. View the Exhibit to examine the PIVSQL 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 Answer

Q7. Examine the following partial code: 

Which statement is correct about the unnamed block of code at the end of a package body? 

A. It generates an error because all the blocks of code in a package body must be named. 

B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification. 

C. It acts as a package initialization block that executes once, when the package is first invoked within the user session. 

D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value. 

View Answer

Q8. Which statement is true about transactions in PL/SQL? 

A. A transaction can span multiple blocks. 

B. A block can contain only a single transaction. 

C. SERVERPOINTS cannot be created in a PL/SQL block. 

D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block. 

View Answer

Q9. Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor. 

A. when you want to lock the rows fetched by the cursor 

B. when you want to update or delete the result set without affecting the rows in the table C. when you want the database not to wait if the requested rows are locked by another user 

D. when you want to ensure that the current rows fetched by the cursor are updated or deleted 

View Answer

Q10. Examine the following PL/SQL code: 

Which statement is true about the fetch statements in the PL/SQL code? 

A. Each fetch retrieves the first row and assigns values to the target variables. 

B. Each fetch retrieves the next consecutive row and assigns values to the target variables. 

C. They produce an error because you must close and reopen the cursor before each fetch -statement. 

D. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error. 

View Answer