1Z0-144 | All About Top Quality 1Z0-144 exam
Q1. 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.
Answer: A
Q2. 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.
Answer: A
Q3. View the Exhibit to examine the PL/SQL code.
SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?
A. The execution fails because of the misplaced else clause.
B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
Answer: C
Q4. View the Exhibit and examine the code and its outcome on execution:
What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)
A. MY_PROC2 is not recompiled.
B. MY_PROC1 is recompiled but remains unchanged.
C. MY_PROC2 is recompiled but remains unchanged.
D. MY_PROC1 is recompiled without the debugging code.
Answer: A,D
Q5. View the Exhibit and examine the structure of the EMP table.
Which stages are performed when the above block is executed? (Choose all that apply)
A. Bind
B. Parse
C. Fetch
D. Execute
Answer: B,C,D
Q6. Identify two features of obfuscation. (Choose two.)
A. The Import and Export utilities accept wrapped files.
B. SQL' Plus cannot process the obfuscated source files.
C. Only the wrap utility can obfuscate multiple programs at a time.
D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
Answer: A,C
Q7. You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.
The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.
Which construct should be used to handle this requirement?
A. The SQLERRM function
B. The PRAGMA EXCEPTION_INIT function
C. The RAISE_APPLICATION_ERROR procedure
D. A user-defined exception used with a raise statement
Answer: B
Explanation:
Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/exceptioninit_pragma.htm#LNPL S01315
Q8. Which three statements are true about anonymous blocks and subprograms? (Choose three.)
A. Only subprograms can be parameterized.
B. Only subprograms are persistent database objects.
C. Both anonymous blocks and subprograms can be parameterized.
D. Both anonymous blocks and subprograms are persistent database objects
E. Only subprograms can return values that persist after the execution of the subprogram.
F. Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.
Answer: B,E,F
Q9. Which two statements are true about the exit statement encountered in loop? (Choose two)
A. The PL/SQL block execution terminates immediately after the exit statement.
B. The loop completes immediately and control passes to the statement after end loop
C. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
Answer: B,D
Explanation: Reference: http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm
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