Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 51:

  Procedure PROCESS_EMP references the table EMP . Procedure UPDATE_EMP updates rows of table EMP through procedure PROCESS_EMP . There is a remote procedure QUERY_EMP that queries the EMP table through the local procedure PROCESS_EMP . The dependency mode is set to TIMESTAMP in this session. Which two statements are true? (Choose two.)

  A. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated.
  B. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
  C. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
  D. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time.
  E. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time.
  B. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
  E. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time.

• Question 52:

  Examine this package:

  

  If you add an IF statement to the ADD_PLAYER procedure, which additional step must you perform?

  A. Recompile the ADD_PLAYER procedure.
  B. Recompile both the BB_PACK specification and body.
  C. Recompile the BB_PACK specification.
  D. Recompile the BB_PACK body.
  D. Recompile the BB_PACK body.

• Question 53:

  You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL . What is the most appropriate location to store the code that calculates the discount?

  A. a stored procedure on the server
  B. a block of code in a PL/SQL library
  C. a standalone procedure on the client machine
  D. a block of code in the body of the program unit ORDERTOTAL
  E. a local subprogram defined within the program unit ORDERTOTAL
  E. a local subprogram defined within the program unit ORDERTOTAL

• Question 54:

  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 55:

  Examine this code:

  

  Which statement is true?

  A. This statement creates a stored procedure named get_sal.
  B. This statement returns a raise amount based on an employee id.
  C. This statement creates a stored function named get_sal with a status of invalid.
  D. This statement creates a stored function named get_sal.
  E. This statement fails.
  E. This statement fails.

• Question 56:

  Which statements are true? (Choose all that apply.)

  A. If errors occur during the compilation of a trigger, the trigger is still created.
  B. If errors occur during the compilation of a trigger you can go into SQL*Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.
  C. If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL*Plus to see the compilation errors.
  D. If errors occur during the compilation of a trigger you can go into SQL*Plus and query the USER_ERRORS data dictionary view to see compilation errors.
  A. If errors occur during the compilation of a trigger, the trigger is still created.
  C. If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL*Plus to see the compilation errors.
  D. If errors occur during the compilation of a trigger you can go into SQL*Plus and query the USER_ERRORS data dictionary view to see compilation errors.

• Question 57:

  Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two.)

  A. It persists across transactions within a session.
  B. It persists from session to session for the same user.
  C. It does not persist across transactions within a session.
  D. It persists from user to user when the package is invoked.
  E. It does not persist from session to session for the same user.
  A. It persists across transactions within a session.
  E. It does not persist from session to session for the same user.

• Question 58:

  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 59:

  When using a packaged function in a query, what is true?

  A. The COMMIT and ROLLBACK commands are allowed in the packaged function.
  B. You can not use packaged functions in a query statement.
  C. The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.
  D. The packaged function can execute an INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.
  E. The packaged function can execute an INSERT, UPDATE, or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCES is used.
  C. The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.

• Question 60:

  The creation of which four database objects will cause a DDL trigger to fire? (Choose four.)

  A. index
  B. cluster
  C. package
  D. function
  E. synonyms
  F. dimensions
  G. database links
  A. index
  B. cluster
  C. package
  D. function