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

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

Latesttests 2018 PDF and VCE

Examine the following code:

Latesttests 2018 PDF and VCE

What is the outcome?

  1. It is created successfully.

  2. It gives an error because the return clause condition is invalid.

  3. It gives an error because the usage of the host variables is invalid.

  4. It gives an error because the data type of the return clause is invalid.

Answer: B

Question No: 22

Which three statements are true about wrapping? (Choose three.)

  1. The PL/SQL wrapper detects and reports only syntax errors.

  2. The PL/SQL wrapper detects and reports both syntax and semantic errors.

  3. When wrapping a package or object type, both the body and specification should be wrapped.

  4. When wrapping a package or object type, only the body should be wrapped, not the specification.

  5. To change a wrapped object, the original source code needs to be modified and then wrapped again

  6. To change a wrapped object, the wrapped code can be unwrapped, modified In a text file, and then wrapped again.

Answer: D,E,F

Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/wrap.htm#BEHJJHAG

Question No: 23

View the Exhibit and examine the code:

Latesttests 2018 PDF and VCE

Which statement is true about the COMPILE_CODE procedure?

  1. It gives an error in line 6.

  2. It gives an error in line 8.

  3. It gives an error in line 5.

  4. It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.

  5. It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.

Answer: D

Question No: 24

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

You need to create a trigger to ensure that customers in category “A” and “B” have a credit limit of more than 8000.

Examine the following trigger.

Latesttests 2018 PDF and VCE

Which statement is correct about the outcome of this trigger?

  1. It compiles successfully and fires whenever the specified condition is met.

  2. It compiles successfully but does not fire even when the condition is met

  3. It gives an error on compilation because the new qualifier is prefixed with a colon.

  4. It gives an error on compilation because the new qualifier can be used only in row-level triggers.

Answer: A

Question No: 25

Which three statements are true about anonymous blocks and subprograms? (Choose three.)

  1. Only subprograms can be parameterized.

  2. Only subprograms are persistent database objects.

  3. Both anonymous blocks and subprograms can be parameterized.

  4. Both anonymous blocks and subprograms are persistent database objects

  5. Only subprograms can return values that persist after the execution of the subprogram.

  6. Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.

Answer: B,E,F

Question No: 26

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

  1. When a query returns multiple rows

  2. When a column name in a where clause is unknown at compile time.

  3. When the number of columns selected in a query is not known until run time

  4. When a table needs to be created based on an existing table structure at run time

  5. When privileges need to be granted to a new user to access an existing schema at run time

Answer: B,C

Question No: 27

Examine the following code:

Latesttests 2018 PDF and VCE

The above code generates an error on execution.

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

  1. Use the TO_DATE function in line 2.

  2. Use the TO_DATE function in line 7.

  3. Use the TO_NUMBER function in line 6.

  4. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.

Answer: A

Question No: 28

Which statement is true about triggers on data definition language (DDL) statements?

  1. They can be used to track changes only to a table or index.

  2. They can be defined by all users in the database or only by a specific user.

  3. They are fired only when the owner of the object Issues the DDL statement.

  4. They can be used to track changes to a table, table space, view, or synonym.

Answer: D

Question No: 29

Examine the following DECLARE section of PL/SQL block:

Latesttests 2018 PDF and VCE

Which line in the above declaration would generate an error?

  1. Line 2

  2. Line 3

  3. Line 4

  4. Line 5

  5. Line 6

Answer: D

Question No: 30

View Exhibit1 and examine the structure of the DO table.

Latesttests 2018 PDF and VCE

View Exhibit2 and examine the code.

Latesttests 2018 PDF and VCE

The anonymous block gives an error on execution. What is the reason?

  1. The assignment in line 7 is not valid.

  2. The SQL does not support the Boolean data type.

  3. A null value cannot be applied to the bind arguments In the using clause in line 10

  4. The names of bind variables must be the same as the using clause bind arguments in line 10

Answer: A

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