Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 91:

  Examine the code examples. Which one is correct?

  A. CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution; /
  B. CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution /
  C. CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;
  D. CREATE OR REPLACE TRIGGER authorize_action CALL log_execution BEFORE INSERT ON EMPLOYEES; /
  B. CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution /

• Question 92:

  Which type of argument passes a value from a procedure to the calling environment?

  A. VARCHAR2
  B. BOOLEAN
  C. OUT
  D. IN
  C. OUT

• Question 93:

  Examine this code:

  

  Which statement is true?

  A. If you remove the package specification, then the package body and the stand alone stored function CALC_HEIGHT are removed.
  B. If you remove the package body, then the package specification and the stand alone stored function CALC_HEIGHT are removed.
  C. If you remove the package specification, then the package body is removed.
  D. If you remove the package body, then the package specification is removed.
  E. If you remove the stand alone stored function CALC_HEIGHT , then the METRIC_CONVERTER package body and the package specification are removed.
  F. The stand alone function CALC_HEIGHT cannot be created because its name is used in a packaged function.
  C. If you remove the package specification, then the package body is removed.

• Question 94:

  Examine this code:

  

  Why does this code cause an error when compiled?

  A. An insert statement is not allowed in a subprogram declaration.
  B. Procedure LOG_EXEC should be declared before any identifiers.
  C. Variable v_name should be declared before declaring the LOG_EXEC procedure.
  D. The LOG_EXEC procedure should be invoked as EXECUTE log_exec within the AUDIT_EMP procedure.
  C. Variable v_name should be declared before declaring the LOG_EXEC procedure.

• Question 95:

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

  You have a table with the following definition: CREATE TABLE long_tab (id NUMBER, long_col LONG); You need to convert the LONG_COL column from a LONG data type to a LOB data type. Which statement accomplishes this task?

  A. ALTER TABLE long_tab MODIFY (LONG_COL CLOB);
  B. EXECUTE dbms_lob.migrate(long_tab, long_col, clob)
  C. EXECUTE dbms_manage.lob.migrate(long_tab, long_col, clob)
  D. EXECUTE utl_lob.migrate(long_tab, long_col, clob)
  E. EXECUTE utl_manage_lob.migrate(long_tab, long_col, clob)
  A. ALTER TABLE long_tab MODIFY (LONG_COL CLOB);

• Question 97:

  Which three are valid ways to minimize dependency failure? (Choose three.)

  A. querying with the SELECT * notation
  B. declaring variables with the %TYPE attribute
  C. specifying schema names when referencing objects
  D. declaring records by using the %ROWTYPE attribute
  E. specifying package.procedure notation while executing procedures
  A. querying with the SELECT * notation
  B. declaring variables with the %TYPE attribute
  D. declaring records by using the %ROWTYPE attribute

• Question 98:

  Examine this code: Why does this code cause an error when compiled?

  

  A. An insert statement is not allowed in a subprogram declaration.
  B. Procedure LOG_EXEC should be declared before any identifiers.
  C. Variable v_name should be declared before declaring the LOG_EXEC procedure.
  D. The LOG_EXEC procedure should be invoked as EXECUTE log_exec within the AUDIT_EMP procedure.
  C. Variable v_name should be declared before declaring the LOG_EXEC procedure.

• Question 99:

  Examine this procedure:

  

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

  A. EXECUTE INSERT_TEAM;
  B. EXECUTE INSERT_TEAM(3, V_NAME=andgt;'LONGHORNS', V_CITY=andgt;'AUSTIN');
  C. EXECUTE INSERT_TEAM(3,'AUSTIN','LONGHORNS');
  D. EXECUTE INSERT_TEAM (V_ID := 3, V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
  E. EXECUTE INSERT_TEAM (3,'LONGHORNS');
  B. EXECUTE INSERT_TEAM(3, V_NAME=andgt;'LONGHORNS', V_CITY=andgt;'AUSTIN');
  C. EXECUTE INSERT_TEAM(3,'AUSTIN','LONGHORNS');

• Question 100:

  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';