Q1. You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:
Which two clauses should be used to fill in the blanks and complete the above code? (Choose two.)
A. ON SCHEMA
B. ON QRXABASE
C. AFTER LOGOFF
D. BEFORE LOGOFF
Answer: A,D
Q2. 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
Q3. Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)
A. Reference tables indirectly by using views.
B. Reference tables directly avoid using views.
C. When adding new items to a package, add them to the end of the package.
D. When adding new items to a package, add them to the beginning of the package.
Answer: A,C
Q4. 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
Q5. Examine the following PL/SQL code:
The server output is on for the session. Which statement is true about the execution of the code?
A. The code executes successfully and gives the desired output.
B. The code generates an error because the EMP_RECORD variable is not declared.
C. The code generates an error because the cursor is not opened before the FOR loop.
D. The code generates an error because the loop does not have the exit when clause.
Answer: A
Q6. You create the following table and execute the following code:
Which statement is true about the outcome of the above code?
A. It executes successfully and all the rows are updated.
B. It gives an error but saves the inserted rows and the update to the first row.
C. It gives an error but saves the inserted rows; however, no rows are updated.
D. It gives an error and all the data manipulation language (DML) statements are rolled back
Answer: A
Q7. Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)
A. AFTER LOGON
B. AFTER STARTUP
C. BEFORE SHUTDOWN
D. AFTER SERVERERROR
Answer: A,D
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064
Q8. The STRING_TAB table has the following structure:
View the Exhibit and examine the code.
What is the outcome on execution?
A. It displays
Output buffer not long enough.
This is my test string.-.
B. It displays only
Output buffer not long enough, and exits the anonymous block.
C. It displays only
This is my test string. - Because EXCEPTION should have been defined in the anonymous
block to get the error message.
D. It does not display any of the MEMS_PUTPUT messages and gives an error because a
transaction control statement cannot be used in the exception section of a procedure.
Answer: A
Q9. Examine the following snippet of PL/SQL code:
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.
A. OPEN c1 (NULL, 3000);
B. OPEN c1 (emp_job, 3000);
C. OPEN c1 (3000, emp_salary);
D. OPEN c1 (‘ST_CLERK’, 3000)
E. OPEN c1 (EMP_job, emp_salary);
Answer: D
Q10. Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003'
What is the implication of the above command?
A. It issues a warning whenever ERROR: 05003 occur during compilation.
B. It causes the compilation to fail whenever the warning ERROR.05003 occurs.
C. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.
D. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.
Answer: C