Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 21:

  Which part of a database trigger determines the number of times the trigger body executes?

  A. trigger type
  B. trigger body
  C. trigger event
  D. trigger timing
  A. trigger type

• Question 22:

  Examine this package:

  

  Which statement will successfully assign .333 to the V_PLAYER_AVG variable from a procedure outside the package?

  A. V_PLAYER_AVG := .333;
  B. BB_PACK.UPD_PLAYER_STAT.V_PLAYER_AVG := .333;
  C. BB_PACK.V_PLAYER_AVG := .333;
  D. This variable cannot be assigned a value from outside of the package.
  D. This variable cannot be assigned a value from outside of the package.

• Question 23:

  An internal LOB is _____.

  A. a table
  B. a column that is a primary key
  C. stored in the database
  D. a file stored outside of the database, with an internal pointer to it from a database column
  C. stored in the database

• Question 24:

  Which two describe a stored procedure? (Choose two.)

  A. A stored procedure is typically written in SQL.
  B. A stored procedure is a named PL/SQL block that can accept parameters.
  C. A stored procedure is a type of PL/SQL subprogram that performs an action.
  D. A stored procedure has three parts: the specification, the body, and the exception handler part .
  E. The executable section of a stored procedure contains statements that assign values, control execution, and return values to the calling environment.
  B. A stored procedure is a named PL/SQL block that can accept parameters.
  C. A stored procedure is a type of PL/SQL subprogram that performs an action.

• Question 25:

  You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to enable all triggers on the EMPLOYEES table. Which command accomplishes this?

  A. You cannot enable multiple triggers on a table in one command.
  B. ALTER TRIGGERS ON TABLE employees ENABLE;
  C. ALTER employees ENABLE ALL TRIGGERS;
  D. ALTER TABLE employees ENABLE ALL TRIGGERS;
  D. ALTER TABLE employees ENABLE ALL TRIGGERS;

• Question 26:

  Examine this code:

  

  Which three are valid calls to the add_dept procedure ? (Choose three.)

  A. add_dept;
  B. add_dept( 'Accounting');
  C. add_dept( , 'New York');
  D. add_dept(p_location=andgt; 'New York');
  A. add_dept;
  B. add_dept( 'Accounting');
  D. add_dept(p_location=andgt; 'New York');

• Question 27:

  You want to create procedures, functions and packages. Which privilege do you need?

  A. EXECUTE CODE object privilege
  B. CREATE ANY CODE object privilege
  C. CREATE PACKAGE system privilege
  D. CREATE PROCEDURE system privilege
  E. CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges
  D. CREATE PROCEDURE system privilege

• Question 28:

  Examine the trigger heading: CREATE OR REPLACE TRIGGER salary_check BEFORE UPDATE OF sal, job ON emp FOR EACH ROW Under which condition does this trigger fire?

  A. when a row is inserted into the EMP table
  B. when the value of the SAL or JOB column in a row is updated in the EMP table
  C. when any column other than the SAL and JOB columns in a row are updated in the EMP table
  D. only when both values of the SAL and JOB columns in a row are updated together in the EMP table
  B. when the value of the SAL or JOB column in a row is updated in the EMP table

• Question 29:

  How can you migrate from a LONG to a LOB data type for a column?

  A. Use the DBMS_MANAGE_LOB.MIGRATE procedure.
  B. Use the UTL_MANAGE_LOB.MIGRATE procedure.
  C. Use the DBMS_LOB.MIGRATE procedure.
  D. Use the ALTER TABLE command.
  E. You cannot migrate from a LONG to a LOB data type for a column.
  D. Use the ALTER TABLE command.

• Question 30:

  Examine this package:

  The product table has more than 1000 rows.

  You execute the procedure PROC1 from SQL*Plus with the command:

  EXECUTE pack_cur.PROC1;

  You then execute the procedure PROC2 from SQL*Plus with the command EXECUTE pack_cur.PROC1;

  What is the output in your session from the PROC2 procedure?

  A. ERROR at line 1:
  B. Row is : Row is: Row is:
  C. Row is: 1 Row is: 2 Row is: 3
  D. Row is: 4 Row is: 5 Row is: 6
  D. Row is: 4 Row is: 5 Row is: 6