Oracle Oracle Certifications 1Z0-144 Questions & Answers

• Question 71:

  Examine the following code: Which statement is true about the execution of the above code?

  

  A. It executes and displays null.

  B. It executes and the condition returns true.

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

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

  Correct Answer: C

• Question 72:

  Which system events can be used to create triggers that fire both at DATABASE and SCHEMA levels? (Choose two.)

  A. AFTER LOGON

  B. AFTER STARTUP

  C. BEFORE SHUTDOWN

  D. AFTER SERVERERROR

  Correct Answer: AD

  References: http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064

• Question 73:

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

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

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

  C. They are fired only when the owner of the object issues the DDL statement.

  D. They can be used to track changes to a table, tablespace, view, or synonym.

  Correct Answer: D

• Question 74:

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

  A. A package must have both specification and body.

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

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

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

  Correct Answer: CD

• Question 75:

  You create the following table and execute the following code:

  

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

  A. It executes successfully and all the rows are updated.

  B. It raises an exception but saves the inserted rows and the update to the first row.

  C. It gives an error but saves the inserted rows; however, no rows are updated.

  D. It gives an error and all the data manipulation language (DML) statements are rolled back.

  Correct Answer: B

• Question 76:

  You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.

  Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)

  A. It should be an after trigger.

  B. It should be a before trigger.

  C. It should be a row-level trigger.

  D. It should be a statement-level trigger.

  E. It can be a before or an after trigger.

  Correct Answer: AD

• Question 77:

  Examine the following code that you plan to execute:

  

  What correction should be performed in the above code?

  A. The PROC2 procedure code should be defined in the package body.

  B. The PROC3 procedure should be declared in the package specification.

  C. The PROC3 procedure header should be declared at the beginning of the package body.

  D. The variable x must be declared in the package body and removed from the specification,

  Correct Answer: A

• Question 78:

  ORDER_TOTAL is a column in the ORDERS table with the data type and size as NUMBER (8, 2). Examine the following code:

  

  Which statement is correct about the above code?

  A. It gives an error in line 3.

  B. It gives an error in line 4.

  C. It gives an error in line 6.

  D. It executes successfully and displays the output.

  Correct Answer: B

• Question 79:

  View the Exhibit and examine the blocks of code that you plan to execute.

  

  Which statement is true about the blocks of code?

  A. All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.

  B. All the blocks execute successfully and the anonymous block displays123cut: 045cart: 1.

  C. The anonymous block gives an error because the function invocation in line 2 is not valid.

  D. The procedure creation gives an error because the function invocation in line 1 is not valid.

  Correct Answer: A

• Question 80:

  View Exhibit 1 and examine the structure of the DO table.

  

  View Exhibit 2 and examine the code.

  

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

  A. The assignment in line 7 is not valid.

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

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

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

  Correct Answer: B