Oracle 1Z0-147 Online Practice Questions and Exam Preparation

Oracle 1Z0-147 Online Questions & Answers

• Question 31:

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

  A. Packages can be nested.
  B. You can pass parameters to packages.
  C. A package is loaded into memory each time it is invoked.
  D. The contents of packages can be shared by many applications.
  E. You can achieve information hiding by making package constructs private.
  D. The contents of packages can be shared by many applications.
  E. You can achieve information hiding by making package constructs private.

• Question 32:

  Examine this code: What occurs?

  

  A. Employee 108 has his email name updated based on the return result of the function.
  B. The statement fails because functions called from SQL expressions cannot perform DML.
  C. The statement fails because the function does not contain code to end the transaction.
  D. The SQL statement executes successfully, because UPDATE and DELETE statements are ignored in stored functions called from SQL expressions.
  E. The SQL statement executes successfully and control is passed to the calling environment.
  B. The statement fails because functions called from SQL expressions cannot perform DML.

• Question 33:

  Which statement about triggers is true?

  A. You use an application trigger to fire when a DELETE statement occurs.
  B. You use a database trigger to fire when an INSERT statement occurs.
  C. You use a system event trigger to fire when an UPDATE statement occurs.
  D. You use an INSTEAD OF trigger to fire when a SELECT statement occurs.
  B. You use a database trigger to fire when an INSERT statement occurs.

• Question 34:

  Which code can you use to ensure that the salary is not increased by more than 10% at a time nor is it ever decreased?

  A. ALTER TABLE emp ADD CONSTRAINT ck_sal CHECK (sal BETWEEN sal AND sal*1.1);
  B. CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal ON emp FOR EACH ROW WHEN (new.sal andlt; old.sal OR new.sal andgt; old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( -20508, 'Do not decrease salary nor increase by more than 10%'); END;
  C. CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal ON emp WHEN (new.sal andlt; old.sal OR new.sal andgt; old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease salary nor increase by more than 10%'); END;
  D. CREATE OR REPLACE TRIGGER check_sal AFTER UPDATE OF sal ON emp WHEN (new.sal andlt; old.sal OR -new.sal andgt; old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease salary nor increase by more than 10%'); END;
  B. CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal ON emp FOR EACH ROW WHEN (new.sal andlt; old.sal OR new.sal andgt; old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( -20508, 'Do not decrease salary nor increase by more than 10%'); END;

• Question 35:

  Examine this procedure:

  

  This procedure must invoke the UPD_BAT_STAT procedure and pass a parameter.

  Which statement, when added to the above procedure, will successfully invoke the UPD_BAT_STAT procedure?

  A. EXECUTE UPD_BAT_STAT(V_ID);
  B. UPD_BAT_STAT(V_ID);
  C. RUN UPD_BAT_STAT(V_ID);
  D. START UPD_BAT_STAT(V_ID);
  B. UPD_BAT_STAT(V_ID);

• Question 36:

  What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?

  A. The rows are selected and ordered.
  B. The validity of the SQL statement is established.
  C. An area of memory is established to process the SQL statement.
  D. The SQL statement is run and the number of rows processed is returned.
  E. The area of memory established to process the SQL statement is released.
  D. The SQL statement is run and the number of rows processed is returned.

• Question 37:

  Examine this code:

  

  What does the BFILENAME function do?

  A. It reads data from an external BFILE.
  B. It checks for the existence of an external BFILE.
  C. It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system.
  D. It creates a directory object for use with the external BFILEs.
  C. It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system.

• Question 38:

  Examine this package:

  The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session.

  You execute the procedure PROC1 from SQL*Plus with the command:

  EXECUTE pack_cur.proc1

  What is the output in your session?

  A. ERROR at line 1:
  B. Row is Row is: Row is:
  C. Row is: 1 Row is: 2 Row is: 3
  D. Row is: 4 Row is: 5 Row is: 6
  C. Row is: 1 Row is: 2 Row is: 3

• Question 39:

  Which statement is true?

  A. Stored functions can be called from the SELECT and WHERE clauses only.
  B. Stored functions do not permit calculations that involve database links in a distributed environment.
  C. Stored functions cannot manipulate new types of data, such as longitude and latitude.
  D. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application.
  D. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application.

• Question 40:

  Examine this package: How many public procedures are in the MANAGE_EMPS package?

  

  A. one
  B. two
  C. three
  D. four
  E. five
  F. none
  F. none