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.8. Exam Essentials

Know how to create database directory objects. Directory objects are required for use in the Data Pump Export and and Data Pump Import programs.

Know the syntax for how to insert data with either a list of values or a subquery. A list of values requires the keyword VALUES, while a subquery does not.

Know the difference between DELETE TABLE and TRUNCATE TABLE. DELETE TABLE generates undo and must be committed for the changes to be made permanent. TRUNCATE TABLE does not generate undo and issues an implicit commit.

Know that PL/SQL functions have a RETURN clause. Functions have a datatype and a RETURN clause. The other PL/SQL programs do not.

Know how to enable and disable triggers. Use the ALTER TRIGGER statement to enable ...

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