Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 61:

  When creating a function, in which section will you typically find the RETURN keyword?

  A. HEADER only
  B. DECLARATIVE
  C. EXECUTABLE and HEADER
  D. DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING
  C. EXECUTABLE and HEADER

• Question 62:

  Examine this code:

  

  Which two statements are true? (Choose two.)

  A. This function is invalid.
  B. This function can be used against any table.
  C. This function cannot be used in a SELECT statement.
  D. This function can be used only if the two parameters passed in are not null values.
  E. This function will generate a string based on 2 character values passed into the function.
  F. This function can be used only on tables where there is a p_first and p_last column.
  B. This function can be used against any table.
  E. This function will generate a string based on 2 character values passed into the function.

• Question 63:

  Examine this code: There are no foreign key integrity constraints on the EMPLOYEES and DEPARTMENTS tables. Which statement performs a successful update to the EMPLOYEES table?

  

  A. UPDATE departments SET department_id = change_dept(10, 'Finance') WHERE department_id = 10;
  B. UPDATE employees SET department_id = change_dept(10, 'Finance') WHERE department_id = 10;
  C. UPDATE departments SET department_id = change_dept(270, 'OUTSOURCE') WHERE department_name = 'Payroll';
  D. UPDATE employees, change_dept(270, 'Outsource') SET department_id = DEPARTMENTS.CURRVAL;
  B. UPDATE employees SET department_id = change_dept(10, 'Finance') WHERE department_id = 10;

• Question 64:

  Examine this code:

  

  Which statements accurately call the stored function CALC_SAL ? (Choose two.)

  A. UPDATE employees (calc_sal(salary)) SET salary = salary * calc_sal(salary);
  B. INSERT calc_sal(salary) INTO employees WHERE department_id = 60;
  C. DELETE FROM employees(calc_sal(salary)) WHERE calc_sal(salary) andgt; 1000;
  D. SELECT salary, calc_sal(salary) FROM employees WHERE department_id = 60;
  E. SELECT last_name, salary, calc_sal(salary) FROM employees ORDER BY calc_sal(salary);
  D. SELECT salary, calc_sal(salary) FROM employees WHERE department_id = 60;
  E. SELECT last_name, salary, calc_sal(salary) FROM employees ORDER BY calc_sal(salary);

• Question 65:

  Examine this code:

  

  Which three are valid calls to the add_dept procedure ? (Choose three.)

  A. add_dept;
  B. add_dept( 'Accounting');
  C. add_dept( , 'New York');
  D. add_dept(p_location=andgt; 'New York');
  A. add_dept;
  B. add_dept( 'Accounting');
  D. add_dept(p_location=andgt; 'New York');

• Question 66:

  What is a conditional predicate in a DML trigger?

  A. A conditional predicate allows you to specify a WHEN-LOGGING-ON condition in the trigger body.
  B. A conditional predicate means you use the NEW and OLD qualifiers in the trigger body as a condition.
  C. A conditional predicate allows you to combine several DML triggering events into one in the trigger body.
  D. A conditional predicate allows you to specify a SHUTDOWN or STARTUP condition in the trigger body.
  C. A conditional predicate allows you to combine several DML triggering events into one in the trigger body.

• Question 67:

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

  Which two does the INSTEAD OF clause in a trigger identify? (Choose two.)

  A. The view associated with the trigger.
  B. The table associated with the trigger.
  C. The event associated with the trigger.
  D. The package associated with the trigger.
  E. The statement level or for each row association to the trigger.
  A. The view associated with the trigger.
  C. The event associated with the trigger.

• Question 69:

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

  Which command must you issue to allow users to access the UPD_TEAM_STAT trigger on the TEAM table?

  A. GRANT SELECT,INSERT,UPDATE,DELETE ON TEAM TO PUBLIC;
  B. GRANT SELECT,INSERT,UPDATE,DELETE ON UPD_TEAM_STAT TO PUBLIC;
  C. GRANT EXECUTE ON TEAM TO PUBLIC
  D. GRANT SELECT, EXECUTE ON TEAM, UPD_TEAM_STAT TO PUBLIC;
  A. GRANT SELECT,INSERT,UPDATE,DELETE ON TEAM TO PUBLIC;