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

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

  1. Each trigger can be of any size.

  2. Each trigger can be of a maximum size of 32 KB.

  3. A trigger can contain a maximum of 32 lines of code.

  4. Triggers fired by DML statements cannot cascade simultaneously.

  5. Both DML and DDL statements can cascade any number of triggers,

  6. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers

Answer: B,E

Reference: http://www.dba-oracle.com/m_trigger.htm

Question No: 12

View the exhibit and examine the structure of the products table.

Latesttests 2018 PDF and VCE

Examine the following code

Latesttests 2018 PDF and VCE

Which statement is true when the procedure DELETE_DETAILS is invoked?

  1. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

  2. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.

  3. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

  4. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

Answer: A

Explanation: In this case, the debug output will only occur if there is an exception.

Question No: 13

You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.

The procedure should return an quot;errorquot; condition to the caller in a manner consistent with other Oracle server errors.

Which construct should be used to handle this requirement?

  1. The SQLERRM function

  2. The PRAGMA EXCEPTION_INIT function

  3. The RAISE_APPLICATION_ERROR procedure

  4. A user-defined exception used with a raise statement

Answer: B

Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/exceptioninit_pragma.htm#LNPL S01315

Question No: 14

View the exhibit and examine the structure of the EMPLOYEE table.

EMPLOYEE_SEQ is an existing sequence. Examine the following block of code:

Latesttests 2018 PDF and VCE

Which statement is true about the above block of code?

  1. It consists of two transactions

  2. It consists of a single transaction,

  3. The data is automatically committed after the block execution ends,

  4. It gives an error on execution because sequences cannot be used in anonymous blocks.

Answer: A

Question No: 15

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 is the outcome when the code is executed?

  1. Both blocks compile and execute successfully when called.

  2. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.

  3. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.

  4. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.

Answer: A

Question No: 16

The STRING_TAB table has the following structure:

Latesttests 2018 PDF and VCE

View the Exhibit and examine the code.

Latesttests 2018 PDF and VCE

What is the outcome on execution?

  1. It displays

    Output buffer not long enough. This is my test string.-.

  2. It displays only

    Output buffer not long enough, and exits the anonymous block.

  3. It displays only

    This is my test string. – Because EXCEPTION should have been defined in the anonymous block to get the error message.

  4. It does not display any of the MEMS_PUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedure.

Answer: A

Question No: 17

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

  1. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

  2. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

  3. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

  4. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

Answer: B,C

Question No: 18

Examine the following snippet of PL/SQL code:

Latesttests 2018 PDF and VCE

View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.

Latesttests 2018 PDF and VCE

Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

  1. OPEN c1 (NULL, 3000);

  2. OPEN c1 (emp_job, 3000);

  3. OPEN c1 (3000, emp_salary);

  4. OPEN c1 (‘ST_CLERK’, 3000)

  5. OPEN c1 (EMP_job, emp_salary);

Answer: D

Question No: 19

What is the correct definition of the persistent state of a packaged variable?

  1. It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.

  2. It is a public variable in a package specification whose value is consistent within a user session.

  3. It is a private variable in a package body whose value is consistent across all current active sessions.

  4. It is a public variable in a package specification whose value is always consistent across all current active sessions.

Answer: B

Question No: 20

Examine the following package specification.

SQLgt;CREATE OR REPLACE PACKAGE emp_pkf IS

PROCEDURE search_emp (empdet NUMBER); PROCEDURE search_emp (empdet DATE);

PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 PROCEDURE search_emp (empdet NUMBER); RETURN DATE

END emp_pkg

/

The package is compiled successfully

Why would it generate an error at run tune?

  1. Because function cannot be overload

  2. Because function cannot differ only in return type.

  3. Because all the functions and procedures In the package cannot have the same number of parameters with the same parameter name

  4. Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types

Answer: B

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