Act now and download your Oracle 1Z0-144 test today! Do not waste time for the worthless Oracle 1Z0-144 tutorials. Download Improved Oracle Oracle Database 11g: Program with PL/SQL exam with real questions and answers and begin to learn Oracle 1Z0-144 with a classic professional.
♥♥ 2017 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
Q11. 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.
Explanation: Reference: http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm
Q12. Which two statements are true about the %ROWTYPE attribute? (Choose two.)
A. It is used to declare a record that can hold multiple rows of a table.
B. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.
C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.
Q13. Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)
A. When a query returns multiple rows
B. When a column name in a where clause is unknown at compile time.
C. When the number of columns selected in a query is not known until run time
D. When a table needs to be created based on an existing table structure at run time
E. When privileges need to be granted to a new user to access an existing schema at run time
Q14. 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
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.
Q15. 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
Q16. Which statements are true about PL/SQL procedures? (Choose all that apply.)
A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.
Q17. 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)
Q18. View the Exhibit and examine the structure of the customer table.
You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000.
What is the outcome?
A. The trigger is fired, a message is displayed, and the update is successful
B. The trigger is fired and a message is displayed, but the update is rolled back.
C. The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.
D. The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.
Q19. Examine the following partial code:
Which statement is correct about the unnamed block of code at the end of a package body?
A. It generates an error because all the blocks of code in a package body must be named.
B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.
C. It acts as a package initialization block that executes once, when the package is first invoked within the user session.
D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.
Q20. View the Exhibit to examine the PL/SQL code.
The record for the employee with employee__id 100 in the employees table is as follows;
Identify the correct output for the code.
A. King 17-JUN-87 1500
B. King 17-JUN-87 24000
C. King current sysdate 1500
D. King current sysdate 24000