Oracle Oracle Database 1Z0-144 Questions & Answers

• Question 11:

  View the Exhibit to examine the PL/SQL code.

  

  SERVEROUTPUT is on for the session.

  Which statement is true about the execution of the code?

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

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

  C. The execution fails and throws exceptions if no employee with EMPLOYEE_ID 115 is found.

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

  Correct Answer: C

• Question 12:

  Which statements correctly describe the features of functions and procedures? (Choose two.)

  A. A procedure can contain a RETURN statement without a value.

  B. A function can return multiple values using a single RETURN clause.

  C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement.

  D. A function can contain zero or more parameters that are transferred from the calling environment.

  Correct Answer: AD

• Question 13:

  Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

  

  A. The OPEN cursor is missing.

  B. The FETCH clause is missing.

  C. The EXIT WHEN condition is missing.

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

  Correct Answer: D

• Question 14:

  Examine the following PL/SQL code:

  

  Which statement is true about the execution of the PL/SQL code?

  A. It executes successfully.

  B. It generates a run-time exception.

  C. It does not execute because of syntax error.

  D. It executes successfully and generates a warning.

  Correct Answer: B

• Question 15:

  View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to GREEN.

  

  Examine the following sequence of commands issued by SCOTT:

  

  What is the outcome?

  A. SCOTT'S session displays 5, and then 0, GREEN'S session displays 0.

  B. SCOTT'S session displays 5, and then 0, GREEN'S session displays 5.

  C. SCOTT'S session displays 5, and then 5, again, GREEN'S session displays 0.

  D. SCOTT'S session displays 5, and then 5, again; GREEN'S session displays 5.

  Correct Answer: A

• Question 16:

  Which two statements are true about the EXIT statement encountered in LOOP? (Choose two.)

  A. The PL/SQL block execution terminates immediately after the EXIT statement.

  B. The loop completes immediately and control passes to the statement after END LOOP.

  C. The statements after the EXIT statement in the iteration are not executed before terminating the LOOP.

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

  Correct Answer: BC

• Question 17:

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

  A. Each trigger can be of any size.

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

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

  D. Triggers fired by DML statements cannot cascade simultaneously.

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

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

  Correct Answer: BF

• Question 18:

  You execute the following block of code: Which statement is true about the outcome?

  

  A. Both output statements show different values.

  B. Both output statements show exactly the same values.

  C. It gives an error because the nested blocks are not labeled.

  D. It gives an error because the V_CUSTOMER variable cannot have different types in the nested blocks.

  Correct Answer: A

• Question 19:

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

  A. The PL/SQL wrapper detects and reports only syntactic errors.

  B. The PL/SQL wrapper detects and reports both syntactic and semantic errors.

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

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

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

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

  Correct Answer: DEF

• Question 20:

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

  A. They can invoke only PL/SQL procedures.

  B. They can include SQL and PL/SQL or calls to Java procedures.

  C. They are implicitly fired by an event that must occur within an application.

  D. They are implicitly fired when a triggering event occurs, depending on which user is connected.

  Correct Answer: BD