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: 41

Which statement is true about transactions in PL/SQL?

  1. A transaction can span multiple blocks.

  2. A block can contain only a single transaction.

  3. SERVERPOINTS cannot be created in a PL/SQL block.

  4. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.

Answer: A

Question No: 42

Examine the following code:

Latesttests 2018 PDF and VCE

Which statement is true about the execution of the above code?

  1. It executes and displays null.

  2. It executes and the condition returns true.

  3. It executes and control goes to the else statement.

  4. It fails because no value is assigned to the v_myage variable.

Answer: C

Question No: 43

Examine the following PL/SQL code:

Latesttests 2018 PDF and VCE

Which statement is true about the fetch statements in the PL/SQL code?

  1. Each fetch retrieves the first row and assigns values to the target variables.

  2. Each fetch retrieves the next consecutive row and assigns values to the target variables.

  3. They produce an error because you must close and reopen the cursor before each fetch

    -statement.

  4. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.

Answer: B

Question No: 44

View the Exhibit to examine the PL/SQL code:

Latesttests 2018 PDF and VCE

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

  1. The output is x = y.

  2. It produces an error.

  3. The output Is x != y.

  4. The output Is Can#39;t tell if x and y are equal or not.

Answer: A

Question No: 45

Which statements are true about PL/SQL procedures? (Choose all that apply.)

  1. Users with definer#39;s rights who are granted access to a procedure that updates a table must be granted access to the table itself.

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

  3. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.

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

Answer: B,D

Question No: 46

Examine the following package specification:

Latesttests 2018 PDF and VCE

Which statement is true?

  1. g_comm has a value of 15 at 9: 06 AM only for Jones

  2. g_comm has a value of 10 at 9: 03 AM for both Jones and smith

  3. g_comm has a value of 15 at 9: 03 AM for both Jones and smith

  4. g_comm has a value of 20 at 9: 06 AM for both Jones and smith

Answer: A Explanation:

Package variable state is scoped at the session level. So the only user who can see

G_COMM=15 will be Jones

Question No: 47

Examine the following PL/SQL code;

Latesttests 2018 PDF and VCE

The execution of the code produces errors. Identify the error in the code.

  1. The open cursor is missing

  2. The fetch clause is missing

  3. The exit when condition is missing

  4. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.

Answer: B

Question No: 48

Which two statements correctly differentiate functions and procedures? (Choose two.)

  1. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.

  2. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

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

  4. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.

Answer: B,C

Question No: 49

View Exhibit1 and examine the structure of the EMP table.

Latesttests 2018 PDF and VCE

View Exhibit2 and examine the code.

Latesttests 2018 PDF and VCE

EKPNOS 7845 and 7900 exist in the EMP table.

Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

  1. call in line 6

  2. call in line 7

  3. call in line 8

  4. call in line 9

Answer: C,D

Question No: 50

In which of the following scenarios would you recommend using associative arrays?

  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 on 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