O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required