From 123-CBT Computer Based Training
Oracle9i Database Admin Create a Database 

...efits of using stored program units, and the functions of
Oracle-supplied packages. Retrieve information about stored objects, identify the common situations when dependent objects may have an
INVALID status, and the functions of the control file with the types of information stored. Retrieve control file information, multiplex a control file, and identify the uses of redo log
more...
Oracle8i Database Admin Create Databases 

...Identify the benefits of stored program units. Match the
Oracle-supplied packages with their functions. Retrieve information about invalid objects in a specified database by querying the required data dictionary view. Retrieve information about a stored program unit specification by using the
Oracle SQL*Plus
Worksheet. Identify the common situations when dependent objects may have an
more...
Oracle8 Database Administration - Create Databases 

...Identify the benefits of stored program units.
Match the
Oracle-supplied packages with their functions.
Retrieve information about invalid objects in a specified database by querying the required data dictionary view.
Retrieve information about a stored program unit specification by using the
Oracle SQL Worksheet.
Identify the common situations when dependent objects may have an invalid
more...
Oracle Database 10g PL SQL Fundamentals Part 2 

... Identify features of the PL/
SQL wrapper utility.
Match
Oracle-supplied packages with their uses.
Match procedures provided by the
DBMS_OUTPUT package with their features.
Identify features of the
UTL_FILE package.
Identify features of the
HTP package.
Identify the syntax for sending e-mail messages using the UTL_MAIL package.
Match components of the DBMS_SCHEDULER package with
more...
Oracle Database 10g PL SQL Fundamentals Part 3 

...pendencies, manipulate large objects, and use some of the
Oracle-supplied packages. The student will also learn about the compilation tools and their options.
Learn To:
Match the stages in the execution of
SQL statements with their descriptions.
Identify features of dynamic SQL.
Identify the features of the
DBMS_SQL package.
Identify guidelines for standardizing constants and
more...