Oracle 8i Certification Exam 2
Oracle 8i Database: Architecture and Administration - Exam 2, 1Z0-023
Back to Oracle 8i Certification Training Admin
|
Oracle® 8 Certified Database Administrator CBT Exams 1Z0-001, 013, 014, 015, 016.
|
n61314D
|
$1375.00
|
|
|
Oracle8i Certified Database Administrator Curriculum CBT Exams 1Z0-001, 023, 024, 025, 026.
|
n63312D
|
$1375.00
|
|
|
Oracle Certified Application Developer CBT
|
n61222D
|
$1750.00
|
|
Oracle 8i Certified Database Administrator Curriculum
CBT CD-ROM Details
63311 - Oracle 8i Database Administration: Manage an Instance
 In this course, participants will learn about the concepts and
procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
Learn To
Identify Oracle architectural components.
Use the Oracle Enterprise Manager (OEM) interface.
Manage an Oracle instance.
Use National Language Support (NLS).
Objectives
Unit 1: Oracle Architecture Components
• Identify the tasks of a database administrator.
• Match the terms associated with establishing a database connection with their descriptions.
• Identify the characteristics of a user process.
• Identify the characteristics of a server process.
• Match the memory structures of the System Global Area (SGA) with the information stored by them.
• Match the mandatory background processes with their functions.
• Match the different types of files existing in a database with the information stored in them.
• Match the non-database files with the information stored in them.
• Sequence the stages in processing a query.
• Identify the combinations of the shared pool components and the information stored in them.
• Identify the characteristics of the database buffer cache.
• Match the contents of the Program Global Area (PGA) with their uses.
• Identify the steps in the execute phase of a given DML statement.
• Identify the uses of a rollback segment.
• Identify the characteristics of a redo log buffer.
• Identify the events that cause the Database Writer (DBWR) to write to data files.
• Identify the events that cause the Log Writer (LGWR) to write to the redo log file.
• Identify the uses of System Change Numbers.
• Sequence the steps that occur during COMMIT processing.
• Identify the advantages of the fast COMMIT process used by Oracle.
Unit 2: Administration Tools
• Match the tools used by the DBA with the administrative tasks that they enable the DBA to perform.
• Specify the associated command for a given description.
• Identify the features of the Oracle Enterprise Manager (OEM) architectural components.
• Match the OEM console components with the tasks that they enable.
• Identify the OEM console service used to perform a given task.
• Match the OEM standard applications with the tasks that they enable you to perform.
• Match the components of the Performance Pack with their functions.
• Identify the steps performed to set up OEM for use.
• Match the application interface objects with their uses.
• Match the SQL Worksheet components with their uses.
Unit 3: Managing an Oracle Instance
• Identify the characteristics of the default database administrator user accounts.
• Set up the OS authentication on the NT platform.
• Set up a Password File Authentication on a NT platform by using the appropriate utility.
• Change the internal password by using the appropriate utility.
• Identify the uses of the parameters included in the parameter file.
• Identify the rules that govern the parameters specified in the parameter file.
• Identify the essential parameters for a parameter file.
• Identify the commonly modified parameters of a parameter file.
• Identify the tasks performed in each stage of an instance startup.
• Start up an instance by using the Oracle Instance Manager.
• Change a database state by using the Oracle Instance Manager.
• Identify the tasks performed in each stage of instance shutdown.
• Identify the features of dynamic performance views.
• Specify the associated dynamic performance view parameter for a given description.
• Display the current parameter values by using the V$PARAMETER dynamic performance view.
• Modify a dynamic initialization parameter by using the Oracle Instance Manager.
• Set up a restricted session to a database by using the Oracle Instance Manager.
• Terminate a user session by using the Oracle Instance Manager.
• Identify the differences between an alert file and a trace file.
• Specify the parameters that are used to control trace files.
• Identify the information stored in a given alert file.
Unit 4: National Language Support (NLS)
• Identify the features of NLS.
• Match the Oracle character encoding scheme classes with their descriptions.
• Identify the reasons for choosing a national character set that is specified in a CREATE DATABASE command.
• Identify combinations of the NLS parameters used for specifying the default conventions and
the session characteristics.
• Specify the derived NLS parameters given the descriptions.
• Override the default NLS behavior for an individual user by using the NLS_LANG environment variable.
• Change the NLS settings for a session by using the ALTER SESSION command.
• Specify the linguistic sort type by using the NLS_SORT parameter.
• Identify the combinations of SQL functions and their corresponding NLS Parameters.
• Retrieve the character sets for the database by using a view.
• Retrieve information about NLS settings by using views.
Back to Oracle 8i Certification Training Admin
63312 -Oracle8i Database Administration: Create a Database
This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts
associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered.
Learn To Identify and create a database. Identify the data dictionary views. Identify the data
dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files Identify tablespaces and data files.
Create a Database
Objectives
Unit 1: Creating a Database: Procedure
• Identify the guidelines for creating an OFA structure.
• Match the ORACLE_HOME subdirectories with their contents.
• Identify the factors to be considered when creating a database.
• Identify the requirements for creating a database.
• Identify the guidelines to be followed for planning a physical database design.
• Identify the steps involved in manually creating a database.
• Identify the registry entries that have to be specified for proper database functionality.
• Create a specified password file for a given instance by using the ORADIM80 utility.
• Create a specified parameter file by editing specific settings in the default init.ora file.
• Start a specified instance in the NOMOUNT mode by using Oracle SQL*Plus Worksheet.
• Identify the functionality of the CREATE DATABASE command options.
• Create a database with specified parameter values by using the CREATE DATABASE command.
• Identify the commonly encountered situations in which the CREATE DATABASE command fails.
• Identify the contents of a database after its creation.
Unit 2: Data Dictionary Views and Standard Packages
• Identify the types of information stored in the data dictionary.
• Identify the features of the data dictionary components.
• Create a data dictionary view for a specific database by executing the appropriate script.
• Identify the contents of the data dictionary view categories.
• Retrieve specific information by querying the Dictionary view.
• Create PL/SQL functionality for a specific database by executing the appropriate script.
• Match the administrative script categories with the views and package components they create.
• Identify the properties of stored procedures.
• Identify the properties of packages.
• 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 invalid status.
Unit 3: Maintaining Redo Log Files and Control Files
• Identify the functions of a control file.
• Identify the types of information stored in a control file.
• Identify the dynamic performance views and the information they contain about the control files.
• Multiplex a control file.
• Identify the uses of redo log groups.
• Identify the features of redo log members in a group.
• Match the parameters that limit the number of online redo log files with what they determine.
• Identify the situations in which a log switch occurs.
• Force a log switch by using Oracle Backup Manager.
• Identify the activities that are performed during a checkpoint.
• Force a checkpoint by using Oracle Backup Manager.
• Identify the functions of the initialization parameters that can be set to control database checkpoints.
• Identify the features of archive modes.
• Identify the command and dynamic performance views with the information they contain about the log and archive status of a database.
• Identify the dynamic performance views and the information they contain about online redo log groups and members.
• Add a redo log group by using Oracle Backup Manager.
• Add a online redo log member to a redo log group by using Oracle Backup Manager.
• Relocate the online redo log file by using Oracle SQL*Plus Worksheet.
• Drop an online redo log group by using Oracle Backup Manager.
• Drop a online redo log member by using Oracle Backup Manager.
• Reinitialize an online redo log file by using Oracle SQL*Plus Worksheet.
• Identify the factors to be considered while planning for the number of online redo log files.
• Identify the reasons for storing the online redo log files on different disks.
• Identify the factors that influence the sizing of the online redo log files.
• Identify the Log Writer (LGWR) errors and effects when specific online redo log members are not available.
• Identify the possible LGWR errors with their solutions.
Unit 4: Managing Tablespaces and Data Files
• Identify the logical database structure.
• Identify the components of the logical and physical structure of a database.
• Identify the relationships between database components.
• Identify the features of a tablespace.
• Identify the uses of a tablespace.
• Identify the features of a datafile.
• Differentiate between the types of tablespaces.
• Create a specified tablespace by using Oracle Storage Manager.
• Identify the segment storage allocation parameters and what they determine.
• Create a temporary tablespace by using Oracle Storage Manager.
• Add a datafile to a tablespace by using the Oracle Storage Manager.
• Enable automatic extension of a datafile in a tablespace by using Oracle Storage Manager.
• Resize a datafile by using Oracle SQL Worksheet.
• Change the values of the storage parameters by using Oracle Storage Manager.
• Identify the features of the modes in which a tablespace can be taken offline.
• Take a tablespace offline by using Oracle Storage Manager.
• Move a datafile of the Non-SYSTEM tablespace by using Oracle SQL*Plus Worksheet.
• Move a datafile belonging to the SYSTEM tablespace by using Oracle SQL*Plus Worksheet.
• Make a tablespace read-only by using Oracle Storage Manager.
• Sequence the steps to create a read-only tablespace on a read-only media.
• Drop a tablespace by using Oracle Storage Manager.
• Identify the effects of dropping a tablespace.
• Identify the benefits of using multiple tablespaces.
• Identify the benefits of specifying storage parameters for a tablespace.
• Identify the dynamic performance views and the information they contain.
Back to Oracle 8i Certification Training Admin
63313 -Oracle8i Database Administration: Manage Storage Structures
Participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes.
Learn To Identify the database storage structures and their relationships. Manage rollback segments. Manage temporary segments. Manage indexes.
Manage Storage Structures
Objectives
Unit 1: Storage Structures
• Identify the correct order of the components of the storage hierarchy.
• Match the types of data segments with their features.
• Identify the uses of index segments.
• Identify the situations that lead to the creation of various non-schema object segments.
• Identify the situations that lead to the creation of various non-schema object segments.
• Identify the considerations behind the precedence order of storage parameters.
• Coalesce free space in a given tablespace by using Oracle Tablespace Manager.
• Identify the correct sets of objects and their fragmentation propensity levels.
• Match the data block contents with their features.
• Match the block space utilization parameters with the information that they provide.
• Sequence the steps used by the Oracle Server to manage data within a block.
• Retrieve the information to check the current number of extents and blocks allocated to a segment by using Oracle SQL*Plus Worksheet.
• Retrieve the information to view the extents for a given segment by using Oracle SQL*Plus Worksheet.
• Write a query to check the extents for a given segment by using Oracle SQL*Plus Worksheet.
Unit 2: Managing Rollback Segments
• Identify the purposes of rollback segments.
• Identify the rollback segment type given its description.
• Sequence the steps for the process in which rollback segments are used by transactions.
• Identify the conditions under which rollback segments shrink.
• Sequence the steps that Oracle Server uses to ensure read consistency when a transaction occurs.
• Identify the factors to be considered while planning rollback segments.
• Create a rollback segment by using Oracle Storage Manager.
• Bring a rollback segment online by using the Oracle Storage Manager.
• Sequence the steps that Oracle Instance uses to acquire rollback segments when a database opens.
• Change the rollback segment storage parameters by using Oracle Storage Manager.
• Deallocate space from a rollback segment by using Oracle Storage Manager.
• Take a rollback segment offline by using Oracle Storage Manager.
• Remove rollback segment by using Oracle Storage Manager.
• Display the general information about rollback segments by using Oracle Storage Manager.
• Retrieve the statistics about rollback segments by using Oracle SQL*Plus Worksheet.
• Retrieve information about rollback segments with currently active transactions by using Oracle SQL*Plus Worksheet.
• Identify the solutions to the insufficient space for transactions problem.
• Identify solutions to the read-consistency error.
• Identify the solutions to the blocking session problem.
• Sequence the steps to resolve the error in taking a tablespace offline.
Unit 3: Managing Temporary Segments
• Identify the statements that require the use of temporary segments.
• Identify the features of temporary segments in PERMANENT tablespaces.
• Identify the features of temporary segments in temporary tablespaces.
• Identify the guidelines for using temporary segments.
• Retrieve temporary segment statistics by using Oracle SQL*Plus Worksheet.
• Retrieve the information about temporary segment activity by using Oracle SQL*Plus Worksheet.
Unit 4: Managing Indexes
• Match the types of indexes with their features.
• Identify the characteristics of B*Tree index.
• Identify the functions of a reverse key index.
• Match the components of a Bitmap index with their contents.
• Differentiate between B*tree indexes and Bitmap indexes.
• Create a normal B*Tree index by using Oracle Schema Manager.
• Create a reverse key index by using Server Manager.
• Create a Bitmap index by using Oracle Schema Manager.
• Modify the index storage parameters by using Oracle Schema Manager.
• Allocate index space by using Server Manager.
• Deallocate index space by using Server Manager.
• Identify the situations in which indexes need to be rebuilt.
• Identify the characteristics of index rebuilds.
• Retrieve index statistics by using Oracle SQL*Plus Worksheet.
• Drop a given index by using Oracle Schema Manager.
• Retrieve index information by using Oracle SQL*Plus Worksheet.
Back to Oracle 8i Certification Training Admin
63314 Oracle8i Database Administration: Manage Data Storage
Learn the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
Learn To Identify the characteristics of various tables and datatypes. Identify and manage
tables. Identify the characteristics and types of triggers and constraints. Identify and maintain data integrity. Identify clusters and index organized tables (IOTs). Identify and reorganize data.
Manage Data Storage
Objectives
Unit 1: Managing Tables
• Identify the information stored in a table row.
• Identify the features of the built-in scalar data types.
• Identify the components of the ROWID format.
• Identify the characteristics that distinguish VARRAYs from nested tables.
• Create a table by using Oracle Schema Manager.
• Identify the guidelines to be followed while creating tables.
• Identify the value for the PCTFREE parameter in a given situation.
• Identify the situations in which the row chaining and row migration events are triggered.
• Copy a table by using Oracle Schema Manager.
• Identify the storage parameters that, when modified, affect a table.
• Identify the block utilization parameters that, when modified, affect the table blocks.
• Modify the storage and block parameters of a table by using Oracle Schema Manager.
• Manually allocate extents by using Oracle SQL*Plus Worksheet.
• Identify the characteristics of the high water mark of a table.
• Deallocate the unused space in a table by using Oracle SQL*Plus Worksheet.
• Truncate a table by using Oracle SQL*Plus Worksheet.
• Identify the effects of truncating a table.
• Drop a table by using Oracle Schema Manager.
• Drop unused columns from a table.
• Retrieve table information by using Oracle SQL*Plus Worksheet.
• Retrieve the extent information from DBA_EXTENTS by using Oracle SQL*Plus Worksheet.
• Obtain the physical location of the rows in a table by using Oracle SQL*Plus Worksheet.
Unit 2: Maintaining Data Integrity
• Identify the features of integrity constraints.
• Identify the functions of the various types of declarative integrity constraints.
• Identify the data processing procedure for various constraint states.
• Match the deferred and immediate constraints with their features.
• Identify the procedure followed by the Oracle server to implement unique and primary keys.
• Identify the factors to be considered while performing DDL operations on the tables referenced by a foreign key.
• Identify the factors to be considered while performing DML operations on the foreign key-primary key related tables.
• Match the types of database triggers with the situations in which they are executed.
• Disable triggers by using Oracle SQL*Plus Worksheet.
• Enable triggers by using Oracle SQL*Plus Worksheet.
• Create an inline constraint using Oracle SQL*Plus Worksheet.
• Create an out-of-line constraint by using Oracle SQL*Plus Worksheet.
• Identify the guidelines for defining constraints.
• Disable constraints by using Oracle SQL*Plus Worksheet.
• Disable constraints in the validate mode by using Oracle SQL*Plus Worksheet.
• Enable a constraint in the novalidate mode by using Oracle SQL*Plus Worksheet.
• Enable constraints in the validate mode by using Oracle SQL*Plus Worksheet.
• Sequence the steps required for detecting constraint violations by using the EXCEPTIONS table.
• Drop constraints by using Oracle SQL*Plus Worksheet.
• Drop triggers by using Oracle Schema Manager.
• Identify the contents of the data dictionary views used for retrieving constraint information.
• Identify the data dictionary views to be used for retrieving specified information about triggers.
Unit 3: Clusters and Index-Organized Tables
• Match the methods for loading data into tables with their functions.
• Perform a serial direct load insert by using Oracle SQL*Plus Worksheet.
• Perform parallel direct load inserts by using the PARALLEL hint.
• Identify the features of SQL*Loader.
• Match the input files used by SQL*Loader with their purposes.
• Match the output files used by SQL*Loader with their purposes.
• Identify the differences between the conventional and direct path load data loading methods.
• Sequence the steps that occur when parallel direct load sessions are initiated to load data into a table.
• Identify the guidelines to minimize errors and maximize the performance of SQL*Loader.
• Load data into a table by using Oracle Schema Manager.
• Identify the methods of troubleshooting the problems that may occur during a SQL*Loader data load.
Unit 4: Loading and Reorganizing Data
• Identify the uses of the Export and Import utilities.
• Identify the objects that can be exported using different export modes.
• Identify the features of the export data paths.
• Match the command line parameters for the Export utility with their purposes.
• Match the command line parameters for the Import utility with their purposes.
• Identify the guidelines for using the Export and Import utilities.
• Export objects by using Oracle Data Manager.
• Import objects by using Oracle Data Manager.
• Identify the characteristics of the import process.
• Identify the NLS considerations for exporting and importing objects.
• Identify the features of a transportable tablespace.
• Sequence the steps required to transport a tablespace to another database.
• Identify the restrictions for transporting a tablespace.
Back to Oracle 8i Certification Training Admin
63315 - Oracle8i Database Administration: Manage Security
In this course, participants will learn about the concepts and tasks associated with managing security.
Learn To Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and password limits. Understand the concept of
resource limits and how to set them. Manage system and object privileges. Control the administration of privileges in a database. Use database auditing.
Manage Security
Objectives
Unit 1: Managing Users
• Match the components of a security domain with their functions.
• Identify the steps for creating a user.
• Create a user by using Oracle Security Manager.
• Identify the security feature available to an operating system user when a value for the OS_AUTHENT_PREFIX parameter is given.
• Identify the guidelines for creating a user.
• Maintain passwords by using Oracle Security Manager.
• Maintain account locks by using Oracle Security Manager.
• Change the user quota on a tablespace by using Oracle Security Manager.
• Drop a user by using Oracle Security Manager.
• Display the tablespace quotas for users from the data dictionary by using Oracle SQL*Plus Worksheet.
• Display the account status of users from the data dictionary by using Oracle SQL*Plus Worksheet.
Unit 2: Managing Resources and Password Security
• Identify the uses of profiles.
• Create a user profile by using Oracle Security Manager.
• Assign a user profile to an existing user by using Oracle Security Manager.
• Alter a user profile by using Oracle Security Manager.
• Drop a user profile by using Oracle Security Manager.
• Display the resource limits for a user by using Oracle SQL*Plus Worksheet.
• Match the features of password management offered by profiles with their descriptions.
• Create a new profile with password settings by using Oracle Security Manager.
• Identify the restrictions that are to be considered while adding a user-defined password function.
• Display password and locking information from the data dictionary by using Oracle SQL*Plus Worksheet.
Unit 3: User Resource Consumption
• Identify the implications of exceeding the profile limits.
• Enable the enforcement of resource limits by using Oracle Instance Manager.
• Display the resource limits for users from the data dictionary by using Oracle SQL*Plus Worksheet.
• Identify the resources whose limits are enforced at the session level.
• Match the main components of the Resource Manager to their description.
• Identify the process necessary to manage Resource Manager components.
Unit 4: Managing Privileges
• Identify the two types of privileges.
• Match the given system privileges with their features.
• Grant system privileges by using Oracle Security Manager.
• Distinguish between the SYSDBA and SYSOPER privileges.
• Sequence the steps to set up password file authentication.
• Control the dictionary protection mechanism of Oracle8i.
• Revoke system privileges by using Oracle Security Manager.
• Identify the implication of revoking a system privilege that is granted with the WITH ADMIN OPTION clause.
• Grant object privileges by using Oracle Security Manager.
• Revoke object privileges by using Oracle Security Manager.
• Identify the implication of revoking an object privilege that is granted using the WITH GRANT OPTION.
• Display the system privileges that are granted at the database level by using Oracle SQL*Plus Worksheet.
• Display the object privileges granted to users by using Oracle SQL*Plus Worksheet.
Unit 5: Managing Roles
• Identify the characteristics of a role.
• Identify the benefits of roles.
• Create a role by using Oracle Security Manager.
• Match the predefined roles with their descriptions.
• Modify a role by using Oracle Security Manager.
• Assign a role to a user by using Oracle Security Manager.
• Specify a role as a non-default role for a user by using Oracle Security Manager.
• Set a role for a session by using Oracle SQL*Plus Worksheet.
• Revoke a role from a user by using Oracle Security Manager.
• Drop a role from the database by using Oracle Security Manager.
• Identify the guidelines for creating roles.
• Display the role information from the data dictionary by using Oracle SQL*Plus Worksheet.
• Display information on active roles using SQL*Plus Worksheet.
Unit 6: Auditing
• Match the categories of auditing with their functions.
• Sequence the phases involved in database auditing.
• Match the values of the AUDIT_TRAIL parameter with their descriptions.
• Specify the commands to audit statements by using Oracle SQL*Plus Worksheet.
• Specify the command to audit a privilege by using Oracle SQL*Plus Worksheet.
• Specify the command to audit a schema object by using Oracle SQL*Plus Worksheet.
• Specify the command to disable an audit option using Oracle SQL*Plus Worksheet.
• Match the audit option views with the information they display.
• Identify the auditing guidelines.
• Move the AUD$ table to a non-system tablespace by using Oracle SQL*Plus Worksheet.
Back to Oracle 8i Certification Training Admin
|
