we provide Top Quality Oracle 1Z0-144 free exam which are the best for clearing 1Z0-144 test, and to get certified by Oracle Oracle Database 11g: Program with PL/SQL. The 1Z0-144 Questions & Answers covers all the knowledge points of the real 1Z0-144 exam. Crack your Oracle 1Z0-144 Exam with latest dumps, guaranteed!
♥♥ 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
Q21. View Exhibit1 and examine the structure of the DO table.
View Exhibit2 and examine the code.
The anonymous block gives an error on execution. What is the reason?
A. The assignment in line 7 is not valid.
B. The SQL does not support the Boolean data type.
C. A null value cannot be applied to the bind arguments In the using clause in line 10
D. The names of bind variables must be the same as the using clause bind arguments in line 10
Answer: A
Q22. View Exhibit 1 and examine the structure of the EMP and dept tables.
View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.
What is the outcome on compilation?
A. It compiles and executes successfully.
B. It gives an error on compilation because it is not a row-level trigger.
C. It gives an error on compilation because the exception section Is used in the trigger.
D. It compiles successfully but gives an error on execution because it is not a row-level trigger.
Answer: B
Q23. Which statements correctly describe the features of functions and procedures? (Choose all that apply.)
A. A procedure can contain a return statement without a value.
B. A function can return multiple values using a single return clause,
C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
D. A function can contain zero or more parameters that are transferred from the calling environment.
Answer: A
Explanation: Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm (using the return statement)
Q24. What is the correct definition of the persistent state of a packaged variable?
A. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.
B. It is a public variable in a package specification whose value is consistent within a user session.
C. It is a private variable in a package body whose value is consistent across all current active sessions.
D. It is a public variable in a package specification whose value is always consistent across all current active sessions.
Answer: B
Q25. Which type of exceptions is qualified as no predefined Oracle server errors?
A. the exceptions that are explicitly raised by the program and can be caught by the exception handler
B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit
Answer: C
Q26. 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
Q27. 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
Q28. View the Exhibit and examine the structure of the employees table.
Execute the following block of code:
What is the outcome?
A. It gives an error because group functions cannot be used in anonymous blocks
B. It executes successfully and correctly gives the result of the sum of salaries in
department 60.
C. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
D. It gives an error because the variable name and column name are the same in the where clause of the select statement.
Answer: C
Q29. 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
Q30. Which statement is true about triggers on data definition language (DDL) statements?
A. They can be used to track changes only to a table or index.
B. They can be defined by all users in the database or only by a specific user.
C. They are fired only when the owner of the object Issues the DDL statement.
D. They can be used to track changes to a table, table space, view, or synonym.
Answer: D
