Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam : 1Z0-144
Title
: Oracle Database 11g:
Program with PL/SQL
Version : demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Which of the following cannot be created and stored in the database?
A. NESTED TABLE
B. VARRAY
C. RECORD
D. ASSOCIATIVE ARRAY
Answer: C
2 . In which of the following categories will the EVAL_CHANGE_TRIGGER fall?
A. A Statement-level trigger and an AFTER trigger
B. An AFTER trigger and a BEFORE trigger
C. A Row-level trigger and a statement-level trigger
D. An INSTEAD OF trigger and a statement-level trigger
Answer: A
3 .Which of the following procedures are provided by the DBMS_OUTPUT package?
Each correct answer represents a complete solution. Choose all that apply.
A. SLEEP
B. NEW_LINE
C. APPEND
D. DISABLE
E. ENABLE
Answer: B, D, E
4. You work as an Application Developer for Tech-Mart Inc. The company uses an Oracle
database.
The database contains a table named Employees that contains employee records. You
are required to define a trigger on the Salary column of the Employees table to ensure that
whenever an employee's salary is updated, the salary is not increased by more than 20%
at a time nor is it ever decreased. To accomplish this, you execute the following statement:
What will happen when you execute the statement?
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
A. The statement will execute successfully and the trigger will be created.
B. The statement will execute successfully and the trigger will be created, but the trigger
will fail when the Salary column of the Employees table is updated.
C. The statement will fail because a trigger cannot be defined on a particular column of a
table .
D. The statement will fail because the OLD and NEW qualifiers are not prefixed with a
colon (: ).
Answer: A
5 .You work as an Application Developer for Dolliver Inc. The company uses an Orac