Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 71:

  Which two statements are true about the INSTEAD OF triggers? (Choose two.)

  A. DELETE operations cannot be performed using the INSTEAD OF triggers.
  B. The INSTEAD OF triggers must be created to add or modify data through any view.
  C. The INSTEAD OF triggers can be written only for views, and the BEFORE and AFTER timing options are not valid.
  D. The CHECK option for views is not enforced when insertions or updates to the view are performed by using the INSTEAD OF triggers.
  C. The INSTEAD OF triggers can be written only for views, and the BEFORE and AFTER timing options are not valid.
  D. The CHECK option for views is not enforced when insertions or updates to the view are performed by using the INSTEAD OF triggers.

• Question 72:

  Which two statements are true about statement-level and row-level triggers? (Choose two.)

  A. A row trigger fires once even if no rows are affected.
  B. A statement trigger fires once even if no rows are affected.
  C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
  D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
  B. A statement trigger fires once even if no rows are affected.
  C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

• Question 73:

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

  

  View Exhibit 2 and examine the code of the packages that you have created.

  

  You issue the following command: SQL> DROP PACKAGE manage_emp; What is the outcome?

  A. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
  B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
  C. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.
  D. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.
  B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

• Question 74:

  View Exhibit 1 and examine the structure of the EMP and DEPT tables.

  

  View Exhibit 2 and examine the trigger code that is defined on the DEPT table to enforce the UPDATE and DELETE RESTRICT referential actions on the primary key of the DEPT table.

  

  What is the outcome on compilation?

  A. It compiles and executes successfully.
  B. It gives an error on compilation because it is not a row-level trigger.
  C. It gives an error on compilation because the EXCEPTION section is used in the trigger.
  D. It compiles successfully but gives an error on execution because it is not a row-level trigger.
  B. It gives an error on compilation because it is not a row-level trigger.

• Question 75:

  The STRING_TAB table has the following structure:

  

  View the Exhibit and examine the code.

  

  What is the outcome on execution?

  A. It displays Output buffer not long enough. This is my test string.-.
  B. It displays only Output buffer not long enough. and exits the anonymous block.
  C. It displays only This is my test string.
  D. It does not display any of the DBMS_OUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedure.
  C. It displays only This is my test string.

• Question 76:

  Identify two situations where the DBMS_SQL package should be used. (Choose two.)

  A. The SELECT list is not known until run time.
  B. The dynamic SQL statement retrieves rows into records.
  C. You do not know how many columns a SELECT statement will return, or what their data types will be.
  D. You must use the % FOUND SQL cursor attribute after issuing a dynamic SQL statement that is an INSERT or UPDATE statement.
  A. The SELECT list is not known until run time.
  C. You do not know how many columns a SELECT statement will return, or what their data types will be.

• Question 77:

  User SCOTT has been granted CREATE ANY TRIGGER and ALTER ANY TABLE by the DBA. HR is an existing schema in the database.

  SCOTT creates the following trigger:

  CREATE OR REPLACE TRIGGER drop_trigger

  BEFORE DROP ON hr.SCHEMA

  BEGIN

  RAISE_APPLICATION_ERROR (-20000, `Cannot drop object');

  END;

  SCOTT does not grant the EXECUTE privilege on this trigger to any other users.

  For which user(s) would this trigger fire by default when they drop an object in the HR schema?

  A. Only HR
  B. SCOTT and HR
  C. Only SCOTT
  D. SCOTT, HR, and SYS
  A. Only HR

• Question 78:

  View the Exhibit and examine the code:

  

  Which statement is true about the COMPILE_CODE procedure?

  A. It gives an error in line 6.
  B. It gives an error in line 8.
  C. It gives an error in line 5.
  D. It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.
  E. It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.
  E. It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.

• Question 79:

  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.
  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.

• Question 80:

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

  

  Examine the following block of code:

  

  What is the outcome when the above code is executed?

  A. It executes successfully.
  B. It gives an error because decode cannot be used in a PL/SQL block.
  C. It gives an error because the AVG function cannot be used in a PL/SQL block
  D. It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.
  E. It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.
  A. It executes successfully.