Q1. Which two statements are true about triggers? (Choose two.) 

A. All the triggers that are created on a table cannot be disabled simultaneously. 

B. Any user who has the alter privilege on a table can create a trigger using that table. 

C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database. 

D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation. 

View Answer

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

Q3. View the Exhibit and examine the code: 

Which statement is true about the COMPILE_CODE procedure? 

A. It gives an error in line 6. 

B. It gives an error in line 8. 

C. It gives an error in line 5. 

D. It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure. 

E. It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure. 

View Answer

Q4. Which statements are true about database triggers? (Choose all that apply.) 

A. They can invoke only PL/SQL procedures 

B. They can include SQL and PL/SQL or calls to Java procedures. 

C. They are implicitly fired by an event that must occur within an application 

D. They are implicitly fired when a triggering event occurs, depending on which user is connected 

View Answer

Q5. Consider the following scenario: 

Local procedure a calls remote procedure B 

Procedure A was compiled at 8 AM. 

Procedure A was modified and recompiled at 9 AM. 

Remote procedure B was later modified and recompiled at 11 AM. 

The dependency mode is set to timestamp. 

Which statement correctly describes what happens when procedure A is invoked at 1 PM? 

A. Procedure A is invalidated and recompiled immediately. 

B. There is no effect on procedure A and it runs successfully. 

C. Procedure B is invalidated and recompiled again when invoked. 

D. Procedure A is invalidated and recompiles when invoked the next time. 

View Answer

Q6. What is the correct definition of the persistent state of a packaged variable? 

A. It is a private variable defined in a procedure or function within a package body whose 

value is consistent within a user session. 

B. It is a public variable in a package specification whose value is consistent within a user session. 

C. It is a private variable in a package body whose value is consistent across all current active sessions. 

D. It is a public variable in a package specification whose value is always consistent across all current active sessions. 

View Answer

Q7. Examine the following code: 

Which statement is true about the execution of the above code? 

A. It executes and displays null. 

B. It executes and the condition returns true. 

C. It executes and control goes to the else statement. 

D. It fails because no value is assigned to the v_myage variable. 

View Answer

Q8. View the exhibit and examine the structure of the EMPLOYEE table. 

EMPLOYEE_SEQ is an existing sequence. 

Examine the following block of code: 

Which statement is true about the above block of code? 

A. It consists of two transactions 

B. It consists of a single transaction, 

C. The data is automatically committed after the block execution ends, 

D. It gives an error on execution because sequences cannot be used in anonymous blocks. 

View Answer

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

Q10. Which statements are true about PL/SQL procedures? (Choose all that apply.) 

A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself. 

B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time. 

C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance. 

D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java. 

View Answer