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