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

Identify two features of obfuscation. (Choose two.)

  1. The Import and Export utilities accept wrapped files.

  2. SQL#39; Plus cannot process the obfuscated source files.

  3. Only the wrap utility can obfuscate multiple programs at a time.

  4. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.

  5. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View

Answer: A,C

Question No: 2

Which two statements are true about anonymous blocks and named subprograms? (Choose two)

  1. Subprograms are by default executed with definer#39;s rights.

  2. The declare section is optional for both anonymous blocks and subprograms.

  3. Both anonymous blocks and subprograms execute by default with invoker#39;s rights.

  4. The declare section is mandatory for anonymous blocks and optional for subprograms.

Answer: A,B

Question No: 3

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

  1. Delete operations cannot be performed using the instead of triggers.

  2. The instead or triggers must be created to add or modify data through any view.

  3. The instead of triggers can be written only for views, and the before and after timing options are not valid.

  4. The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.

Answer: B,C

Question No: 4

Which two statements are correct about PL/SQL package components? (Choose two)

  1. A package must have both specification and body.

  2. A package body can exist without the package specification.

  3. A package specification can exist without the package body.

  4. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

Answer: C,D

Question No: 5

View the Exhibit and examine the structure of the AUDIR_CUST table. Exhibit Missing

CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger code:

Latesttests 2018 PDF and VCE

Which statement is true about the above trigger?

  1. It gives an error on compilation because it should be a statement-level trigger.

  2. It compiles and fires successfully when the credit limit is updated in the customer table.

  3. It gives an error on compilation because of the commit command in the trigger code

  4. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.

Answer: D

Question No: 6

Examine the following block of code:

Latesttests 2018 PDF and VCE

Which line in the above code would result in errors upon execution?

  1. line 5

  2. line 8

  3. line 2

  4. line 7

Answer: B

Question No: 7

View the Exhibit to examine the PL/SQL code.

Latesttests 2018 PDF and VCE

SERVEROUTPUT is on for the session.

Which statement is true about the execution of the code?

  1. The execution fails because of the misplaced else clause.

  2. The execution is successful even if there is no employee with EMPLOYEE_ID 115.

  3. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.

  4. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.

Answer: C

Question No: 8

View Exhibit1 and examine the structure of the employees table.

Latesttests 2018 PDF and VCE

View Exhibit2 and examine the code.

Latesttests 2018 PDF and VCE

What would be the outcome when the code is executed?

  1. It executes successfully.

  2. It gives an error because the SAL variable is not visible in the increase function.

  3. It gives an error because the increase function cannot be called from the

    RAISE_SALARY procedure.

  4. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.

Answer: A

Question No: 9

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

Latesttests 2018 PDF and VCE

Execute the following block of code:

Latesttests 2018 PDF and VCE

What is the outcome?

  1. It gives an error because group functions cannot be used in anonymous blocks

  2. It executes successfully and correctly gives the result of the sum of salaries in department 60.

  3. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.

  4. It gives an error because the variable name and column name are the same in the where clause of the select statement.

Answer: C

Question No: 10

Which two statements are true about the continue statement? (Choose two.)

  1. The PL/SQL block execution terminates immediately.

  2. The CONTINUE statement cannot appear outside a loop.

  3. The loop completes immediately and control passes to the statement after end loop.

  4. The statements after the continue statement in the iteration are executed before terminating the LOOP.

  5. The current iteration of the loop completes immediately and control passes to the next iteration of the loop

Answer: B,E

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