Exam Code: 1Z0-144 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Program with PL/SQL
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-144 Exam.
2016 Apr 1Z0-144 Study Guide Questions:
Q51. Which two statements correctly differentiate functions and procedures? (Choose two.)
A. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.
B. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.
C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.
D. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.
Q52. Examine the following PL/SQL code:
Which statement is true about the execution of the PL/SQL code?
A. It executes successfully.
B. It generates a run-time exception.
C. It does not execute because of syntax error
D. It executes successfully and generates a warning.
Explanation: Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm
Q53. 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.
Rebirth 1z0-144 exam:
Q54. View Exhibit 1 and examine the structure of the EMP table.
View Exhlbit2 and examine the code of the packages that you have created.
You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?
A. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
C. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.
D. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.
Q55. Which statement is true about transactions in PL/SQL?
A. A transaction can span multiple blocks.
B. A block can contain only a single transaction.
C. SERVERPOINTS cannot be created in a PL/SQL block.
D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.
Q56. View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
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
100% Guarantee 1z0-144 pdf free download:
Q57. View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:
Which statement is true about the above block of code?
A. It consists of two transactions
B. It consists of a single transaction,
C. The data is automatically committed after the block execution ends,
D. It gives an error on execution because sequences cannot be used in anonymous blocks.
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.
Q59. Which two tasks should be created as functions instead of as procedures? (Choose two.)
A. Reference host or bind variables in a PL7SQL block of code
B. Tasks that compute and return multiple values to the calling environment
C. Tasks that compute a value that must be returned to the calling environment
D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application
Functions are used to return a value. Functions must return only a single value.
Procedure are used to perform an action.
Both functions and procedures are using to do a special task or action. In functions it is
must to return a single value, where as in procedures it’s not compulsory
Q60. Which two statements are true about anonymous blocks and named subprograms?
A. Subprograms are by default executed with definer's rights.
B. The declare section is optional for both anonymous blocks and subprograms.
C. Both anonymous blocks and subprograms execute by default with invoker's rights.
D. The declare section is mandatory for anonymous blocks and optional for subprograms.