OCA: Oracle 10g™ Administration I: Study Guide

7.9. Review Questions

1. Which of the following conditions prevents you from being able to insert into a view?

   1. A TO_NUMBER function on one of the base table columns

   2. A CONNECT BY clause in the view definition

   3. A column of type RAW

   4. All of the above

2. Changes made with an UPDATE statement are made permanent in the database after what occurs?

   1. DBWR flushes the changes to disk.

   2. You issue a SAVEPOINT statement.

   3. You issue a COMMIT statement.

   4. A checkpoint occurs.

3. Which of the following is not a PL/SQL program?

   1. Library

   2. Trigger

   3. Function

   4. Procedure

4. Why would you execute a CREATE OR REPLACE PROCEDURE statement instead of a DROP PROCEDURE and a CREATE PROCEDURE?

   1. It is less typing.

   2. There is no difference between the two.

   3. CREATE OR REPLACE PROCEDURE does not invalidate dependent objects. ...