Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 131:

  The add_player procedure inserts rows into the PLAYER table. Which command will show this direct dependency?

  A. SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'PLAYER';
  B. SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'ADD_PLAYER';
  C. SELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR';
  D. SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'TABLE';
  A. SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'PLAYER';

• Question 132:

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

  A. A function must have a return statement in its body to execute successfully.
  B. Client-side functions can be used in SQL statements.
  C. A stored function that is called from a SQL statement can return a value of any PL/SQL variable data type.
  D. From SQL*Plus, a function can be executed by giving the command EXECUTE functionname; .
  E. A stored function increases efficiency of queries by performing functions on the server rather than in the application.
  A. A function must have a return statement in its body to execute successfully.
  E. A stored function increases efficiency of queries by performing functions on the server rather than in the application.