Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 101:

  You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?

  A. DROP TRIGGER business_hour;
  B. DELETE TRIGGER business_hour;
  C. REMOVE TRIGGER business_hour;
  D. ALTER TRIGGER business_hour REMOVE;
  E. DELETE FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'BUSINESS_HOUR';
  A. DROP TRIGGER business_hour;

• Question 102:

  You have the following table:

  

  You create this trigger:

  

  What are the results in the EMP_LOG table?

  

  A. B. C.
  D. No rows are inserted.
  B

• Question 103:

  When using a PL/SQL stored package, how is a side effect defined?

  A. changes only to database tables
  B. changes only to packaged public variables defined in a package body
  C. changes only to packaged public variables defined in a package specification
  D. changes to database tables or packaged public variables defined in a package body
  E. changes to database tables or packaged variables defined in a package specification
  E. changes to database tables or packaged variables defined in a package specification

• Question 104:

  Examine this procedure:

  

  Which two statements will successfully invoke this procedure in iSQL*Plus? (Choose two.)

  A. EXECUTE UPD_BAT_STAT;
  B. EXECUTE UPD_BAT_STAT(V_AB=andgt;10, V_ID=andgt;31);
  C. EXECUTE UPD_BAT_STAT(31,'FOUR','TWO');
  D. UPD_BAT_STAT(V_AB=andgt;10, V_ID=andgt;31);
  E. RUN UPD_BAT_STAT;
  A. EXECUTE UPD_BAT_STAT;
  B. EXECUTE UPD_BAT_STAT(V_AB=andgt;10, V_ID=andgt;31);

• Question 105:

  You need to implement a virtual private database (vpd). In order to have the vpd functionality, a trigger is required to fire when every user initiates a session in the database. What type of trigger needs to be created?

  A. DML trigger
  B. System event trigger
  C. INSTEAD OF trigger
  D. Application trigger
  B. System event trigger

• Question 106:

  You create a DML trigger. For the timing information, which are valid with a DML trigger? (Choose all that apply.)

  A. DURING
  B. IN PLACE OF
  C. ON SHUTDOWN
  D. BEFORE
  E. ON STATEMENT EXECUTION
  D. BEFORE

• Question 107:

  You need to create a DML trigger. Which five pieces need to be identified? (Choose five.)

  A. table
  B. DML event
  C. trigger body
  D. package body
  E. package name
  F. trigger name
  G. system event
  H. trigger timing
  A. table
  B. DML event
  C. trigger body
  F. trigger name
  H. trigger timing

• Question 108:

  Which table should you query to determine when your procedure was last compiled?

  A. USER_PROCEDURES
  B. USER_PROCS
  C. USER_OBJECTS
  D. USER_PLSQL_UNITS
  C. USER_OBJECTS

• Question 109:

  Which two statements are true about LOBs? (Choose two.)

  A. BFILES are stored in the database.
  B. All LOBs have read and write access.
  C. NCLOB represents a multi-byte character object.
  D. The Oracle9i server performs implicit conversions between BLOBs and NUMBER data types.
  E. The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types.
  C. NCLOB represents a multi-byte character object.
  E. The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types.

• Question 110:

  The add_player , upd_player_stat , and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable?

  A. in the package body
  B. in a database trigger
  C. in the package specification
  D. in each procedure's DECLARE section, using the exact same name in each
  A. in the package body