Want to know Examcollection 1Z0-144 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: Program with PL/SQL certification experience? Study Vivid Oracle 1Z0-144 answers to Up to date 1Z0-144 questions at Examcollection. Gat a success with an absolute guarantee to pass Oracle 1Z0-144 (Oracle Database 11g: Program with PL/SQL) test on your first attempt.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-144 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-144 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-144-exam-dumps.html
Q51. You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)
A. It should be an after trigger.
B. It should be a before trigger.
C. It should be a row-level trigger.
D. It should be a statement-level trigger.
E. It can be a before or an after trigger.
Answer: A,C
Q52. 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
Q53. View Exhibit1 and examine the structure of the employees table.
View Exhibit2 and examine the code.
What would be the outcome when the code is executed?
A. It executes successfully.
B. It gives an error because the SAL variable is not visible in the increase function.
C. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.
D. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.
Answer: A
Q54. Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = ‘Tom Jones’:
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?
A. The SAME_NAME variable inherits only the data type from the CUST_NAME variable.
B. The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.
C. The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.
D. The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error
Answer: D
Q55. ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:
Which statement is correct about the above code?
A. It gives an error in line 3
B. It gives an error in line 4
C. It gives an error in line 6
D. It executes successfully and displays the output.
Answer: D
Q56. View Exhibit1 and examine the structure of the employees table.
User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA:
SQL_CREATE DICTORY my_dir AS '/temp/my_files* ;
SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code.
You issue the following command: You issue the following command:
SQL_EXEC sal_5tatus ('MY_DIR', ‘EMPREPORT.TXT')
What is the outcome?
A. It executes successfully and creates the report.
B. It gives an error because the text file should be opened in append mode.
C. It gives an error because the "no data found" condition is not handled to come out of the loop.
D. It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.
E. It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.
Answer: A
Q57. 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
Q58. 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.
Answer: B
Q59. 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
Q60. 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
