Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 31:

  View the Exhibit and examine the structure of the EMP table.

  

  Examine the following block of code:

  

  Which stages are performed when the above block is executed? (Choose three.)

  A. Bind
  B. Parse
  C. Fetch
  D. Execute
  B. Parse
  C. Fetch
  D. Execute

• Question 32:

  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
  D. The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error

• Question 33:

  Examine the following code:

  

  The above code generates an error on execution.

  What must you do to ensure that the code executes successfully?

  A. Use the TO_DATE function in line 2.
  B. Use the TO_DATE function in line 7.
  C. Use the TO_NUMBER function in line 6.
  D. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.
  A. Use the TO_DATE function in line 2.

• Question 34:

  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.
  B. Only subprograms are persistent database objects.
  C. Both anonymous blocks and subprograms can be parameterized.
  F. Both anonymous blocks and subprograms can return values that persist in SQL*Plus variables after their execution.

• Question 35:

  Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

  A. Reference tables indirectly by using views.
  B. Reference tables directly and avoid using views.
  C. When adding new items to a package, add them to the end of the package.
  D. When adding new items to a package, add them to the beginning of the package.
  A. Reference tables indirectly by using views.
  C. When adding new items to a package, add them to the end of the package.

• Question 36:

  Consider the following scenario:

  Local procedure A calls remote procedure B.

  Procedure B was compiled at 8 AM.

  Procedure A was modified and recompiled at 9 AM.

  Remote procedure B was later modified and recompiled at 11 AM.

  The dependency mode is set to TIMESTAMP.

  Which statement correctly describes what happens when procedure A is invoked at 1 PM?

  A. Procedure A is invalidated and recompiled immediately.
  B. There is no effect on procedure A and it runs successfully.
  C. Procedure B is invalidated and recompiled again when invoked.
  D. Procedure A is invalidated and recompiles when invoked the next time.
  D. Procedure A is invalidated and recompiles when invoked the next time.

• Question 37:

  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
  C. King current sysdate 1500

• Question 38:

  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.
  A. It should be an after trigger.
  D. It should be a statement-level trigger.

• Question 39:

  View the Exhibit and examine the code.

  

  Why does the code give an error on execution?

  A. because the WORD_LIST variable is not visible in PROCEDURE WORDING
  B. because the LEXICON variable is not visible in PROCEDURE ADD_ENTRY
  C. because the LEXICON variable is not initialized in PROCEDURE WORDING
  D. because the WORD_LIST parameter in IN OUT mode cannot be of a RECORD data type
  A. because the WORD_LIST variable is not visible in PROCEDURE WORDING

• Question 40:

  Examine the following DECLARE section of PL/SQL block:

  

  Which line in the above declarations would generate an error?

  A. Line 2
  B. Line 3
  C. Line 4
  D. Line 5
  E. Line 6
  A. Line 2