Latesttests
2018 Jan Oracle Official New Released 1z0-144
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-144.html

Oracle Database 11g: Program with PL/SQL

Question No: 51

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

Latesttests 2018 PDF and VCE

View Exhlbit2 and examine the code of the packages that you have created.

Latesttests 2018 PDF and VCE

You issue the following command: SQLgt; DROP PACKAGE manage_emp; What is the outcome?

  1. It drops both the MANAGE_EMP AND EMP DET packages because of the cascading effect.

  2. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

  3. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

  4. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

Answer: B

Question No: 52

Which type of exceptions is qualified as no predefined Oracle server errors?

  1. the exceptions that are explicitly raised by the program and can be caught by the exception handler

  2. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler

  3. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly

  4. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

Answer: C

Question No: 53

View Exhibit 1 and examine the structure of the EMP and dept tables.

Latesttests 2018 PDF and VCE

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.

Latesttests 2018 PDF and VCE

What is the outcome on compilation?

  1. It compiles and executes successfully.

  2. It gives an error on compilation because it is not a row-level trigger.

  3. It gives an error on compilation because the exception section Is used in the trigger.

  4. It compiles successfully but gives an error on execution because it is not a row-level trigger.

Answer: B

Question No: 54

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.)

  1. It should be an after trigger.

  2. It should be a before trigger.

  3. It should be a row-level trigger.

  4. It should be a statement-level trigger.

  5. It can be a before or an after trigger.

Answer: A,C

Question No: 55

Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)

  1. It can be the first exception handler.

  2. It can be the only exception handler for the code.

  3. It traps all the exceptions that are not already trapped.

  4. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.

Answer: C

Reference: http://www.techonthenet.com/oracle/exceptions/when_others.php

Question No: 56

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

Latesttests 2018 PDF and VCE

You create the following trigger to ensure that customers belonging to category quot;Aquot; or quot;Bquot; in the customer table can have a credit limit of more than 8000.

Latesttests 2018 PDF and VCE

What is the outcome?

  1. The trigger is fired, a message is displayed, and the update is successful

  2. The trigger is fired and a message is displayed, but the update is rolled back.

  3. The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

  4. 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.

Answer: D

Question No: 57

Which two statements are true about triggers? (Choose two.)

  1. All the triggers that are created on a table cannot be disabled simultaneously.

  2. Any user who has the alter privilege on a table can create a trigger using that table.

  3. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.

  4. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.

Answer: C,D

Question No: 58

View the Exhibit to examine the PL/SQL code.

Latesttests 2018 PDF and VCE

The record for the employee with employee id 100 in the employees table is as follows;

Latesttests 2018 PDF and VCE

Identify the correct output for the code.

A. King 17-JUN-87 1500

B. King 17-JUN-87 24000

  1. King current sysdate 1500

  2. King current sysdate 24000

Answer: A

Question No: 59

Consider the following scenario:

Local procedure a calls remote procedure B Procedure A 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?

  1. Procedure A is invalidated and recompiled immediately.

  2. There is no effect on procedure A and it runs successfully.

  3. Procedure B is invalidated and recompiled again when invoked.

  4. Procedure A is invalidated and recompiles when invoked the next time.

Answer: D

Question No: 60

In which of the following scenarios would you recommend using PL/SQL records?

  1. when you want to retrieve an entire row from a table and perform calculations

  2. when you know the number of elements in advance and the elements are usually accessed sequentially

  3. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

  4. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked

Answer: C,D

100% Free Download!
Download Free Demo:1z0-144 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-144 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE