Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. 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.
Answer: C
Q2. View the Exhibit to examine the PL/SQL code:
SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?
A. The output is x = y.
B. It produces an error.
C. The output Is x != y.
D. The output Is Can't tell if x and y are equal or not.
Answer: A
Q3. 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.
Answer: C,D
Q4. Which three statements are true about wrapping? (Choose three.)
A. The PL/SQL wrapper detects and reports only syntax errors.
B. The PL/SQL wrapper detects and reports both syntax 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.
Answer: D,E,F
Explanation: Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHJJHAG
Q5. 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
Answer: B
Q6. Examine the following block of code:
Which line in the above code would result in errors upon execution?
A. line 5
B. line 8
C. line 2
D. line 7
Answer: B
Q7. Which two statements are true about database triggers? (Choose two.)
A. Each trigger can be of any size.
B. Each trigger can be of a maximum size of 32 KB.
C. A trigger can contain a maximum of 32 lines of code.
D. Triggers fired by DML statements cannot cascade simultaneously.
E. Both DML and DDL statements can cascade any number of triggers,
F. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers
Answer: B,E
Explanation: Reference: http://www.dba-oracle.com/m_trigger.htm
Q8. View the exhibit and examine the structure of the EMPLOYEES table
The salary of EMPLOYEE_ID 195 is 2800.
You execute the following code
What is the outcome?
A. It gives an error because only the innermost block is labeled.
B. It gives an error because the same variable name cannot be used across all the nested blocks.
C. It executes successfully and displays the resultant values in the following sequence-1000, 2800 50000, 2800.
D. It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.
Answer: C
Q9. View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:
Which statement is true about the above trigger?
A. It gives an error on compilation because it should be a statement-level trigger.
B. It compiles and fires successfully when the credit limit is updated in the customer table.
C. It gives an error on compilation because of the commit command in the trigger code
D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
Answer: D
Q10. 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 displays 1 2 3 cant: 45 45 cnt: 45
B. All the blocks execute successfully and the anonymous block displays 1 2 3 cut: 0 45 cart: 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.
Answer: A
Q11. 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.
Answer: C
Explanation: Reference:
http://www.techonthenet.com/oracle/exceptions/when_others.php
Q12. View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
EMPLOYEES
DEPAERTMENT
EMP_BY_DEPT
Examine the following code:
What is the outcome on execution of the above code?
A. It executes successfully but the output statements show different values.
B. It executes successfully and both output statements show the same values.
C. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.
D. It gives an error because the INSERT SELECT construct cannot be used with the FORALL
Answer: A
Q13. View the exhibit to examine the PL/SQL code.
Which statement is true about the exception handlers in the PL/SQL code?
A. All the exceptions in the code are trapped by the exception handler.
B. All the "no data found" errors in the code are trapped by the exception handler.
C. The PL/SQL program does not execute because an exception is not declared in the declare section.
D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.
Answer: B
Q14. Examine the following code:
What is the outcome?
A. The procedure is created successfully and displays the values 20 and 30 when it is called.
B. The procedure gives errors because the parameters should be in out mode.
C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.
D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.
Answer: C
Q15. Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)
A. setting the UTL_FILE_DIR initialization parameter
B. running the UTLMAIL.SQL and prvtmail.plb scripts
C. setting the SMTP_OUT_SERVER initialization parameter
D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory
E. granting read and WRITE privileges to control the type of access to files in the operating system
Answer: B,C