Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 41:

  This statement fails when executed: CREATE OR REPLACE TRIGGER CALC_TEAM_AVG AFTER INSERT ON PLAYER BEGIN INSERT INTO PLAYER_BAT_STAT (PLAYER_ID, SEASON_YEAR,AT_BATS,HITS) VALUES (:NEW.ID, 1997, 0,0); END; To which type must you convert the trigger to correct the error?

  A. row
  B. statement
  C. ORACLE FORM trigger
  D. before
  A. row

• Question 42:

  Which two tables or views track object dependencies? (Choose two).

  A. USER_DEPENDENCIES
  B. USER_IDEPTREE
  C. IDEPTREE
  D. USER_DEPTREE
  E. USER_DEPENDS
  A. USER_DEPENDENCIES
  C. IDEPTREE

• Question 43:

  Which four triggering events can cause a trigger to fire? (Choose four.)

  A. A specific error or any error occurs.
  B. A database is shut down or started up.
  C. A specific user or any user logs on or off.
  D. A user executes a CREATE or an ALTER table statement.
  E. A user executes a SELECT statement with an ORDER BY clause.
  F. A user executes a JOIN statement that uses four or more tables.
  A. A specific error or any error occurs.
  B. A database is shut down or started up.
  C. A specific user or any user logs on or off.
  D. A user executes a CREATE or an ALTER table statement.

• Question 44:

  You have an AFTER UPDATE row-level trigger on the table EMP . This trigger queries the EMP table and inserts the updating user's information into the AUDIT_TABLE . What happens when the user updates rows on the EMP table?

  A. A compile time error occurs.
  B. A runtime error occurs. The effect of trigger body and the triggering statement are rolled back.
  C. A runtime error occurs. The effect of trigger body is rolled back, but the update on the EMP table takes place.
  D. The trigger fires successfully. The update on the EMP table occurs, and data is inserted into the AUDIT_TABLE table.
  E. A runtime error occurs. The update on the EMP table does not take place, but the insert into the AUDIT_TABLE occurs.
  B. A runtime error occurs. The effect of trigger body and the triggering statement are rolled back.

• Question 45:

  Examine this code:

  

  Which statement is true?

  A. g_comm has a value of 15 at 9:06am for Smith.
  B. g_comm has a value of 15 at 9:06am for Jones.
  C. g_comm has a value of 20 at 9:06am for both Jones and Smith.
  D. g_comm has a value of 15 at 9:03am for both Jones and Smith.
  E. g_comm has a value of 10 at 9:06am for both Jones and Smith.
  F. g_comm has a value of 10 at 9:03 for both Jones and Smith.
  B. g_comm has a value of 15 at 9:06am for Jones.

• Question 46:

  Which two dictionary views track dependencies? (Choose two.)

  A. USER_SOURCE
  B. UTL_DEPTREE
  C. USER_OBJECTS
  D. DEPTREE_TEMPTAB
  E. USER_DEPENDENCIES
  F. DBA_DEPENDENT_OBJECTS
  D. DEPTREE_TEMPTAB
  E. USER_DEPENDENCIES

• Question 47:

  Which statement is true about removing packages?

  A. You must remove the package body first.
  B. Removing a package specification removes the body too.
  C. Removing the package body removes the specification too.
  D. You must remove both the package body and the specification separately.
  E. Removing a package specification removes all stand alone stored functions named in the specification.
  B. Removing a package specification removes the body too.

• Question 48:

  Which three are true regarding error propagation? (Choose three.)

  A. An exception cannot propagate across remote procedure calls.
  B. An exception raised inside a declaration immediately propagates to the current block.
  C. The use of the RAISE; statement in an exception handler reraises the current exception.
  D. An exception raised inside an exception handler immediately propagates to the enclosing block.
  A. An exception cannot propagate across remote procedure calls.
  C. The use of the RAISE; statement in an exception handler reraises the current exception.
  D. An exception raised inside an exception handler immediately propagates to the enclosing block.

• Question 49:

  Examine this code:

  

  What type of trigger is it?

  A. DML trigger
  B. INSTEAD OF trigger
  C. application trigger
  D. system event trigger
  E. This is an invalid trigger.
  E. This is an invalid trigger.

• Question 50:

  Which two dictionary views track dependencies? (Choose two.)

  A. USER_SOURCE
  B. UTL_DEPTREE
  C. USER_OBJECTS
  D. DEPTREE_TEMPTAB
  E. USER_DEPENDENCIES
  F. DBA_DEPENDENT_OBJECTS
  D. DEPTREE_TEMPTAB
  E. USER_DEPENDENCIES