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 ...
Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
