Oracle Certification Training 9i
Includes:
Oracle 9i Certification - Certified Database Administration DBA Training Courses on CD-ROMs - Fundamentals 1 Curriculum
|
Intro. to Oracle Certification 9i - SQL Curriculum CD
|
n61130d
|
$387.00
|
|
|
Database Admin. Fundamentals I CD
|
n64311d
|
$645.00
|
|
|
Database Admin. Fundamentals II CD
|
n64321d
|
$387.00
|
|
|
Oracle 9i Performance Tuning CD
|
n64331d
|
$387.00
|
|
|
Complete Oracle Certification 9i CBT CD
includes SQL Curriculum, Database Admin. Fundamentals I & II
Curriculum and Oracle 9i Performance Tuning Curriculum
|
n61131d
|
$1100.00
|
|
Oracle Certification 9i Database Administration: Manage an Instance
 The Oracle9i Database Administration: Manage
An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and
procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using OEM and the steps to start
and shut down an instance. This course also explains the various dynamic performance views and initialization parameters and the globalization support that is provided.
Learn To
• Identify the memory structures of the SGA and the information stored in the database and nondatabase files.
• Identify the connection procedures and the processes generated during database connection.
• Identify the stages in processing a query and the memory structures used in query processing.
• Identify the steps of DML processing and the memory structures involved in DML processing.
• Identify the uses of SCN and the features of a process commit.
• Identify the tasks of a DBA and the Oracle Enterprise Manager tools used by a DBA.
• Identify the OEM console components, steps to set up these components, and the functions of the OEM DBA tools.
• Identify the default DBA user accounts and set up authentication methods to validate users.
• Identify the parameters stored in the parameter file, their uses, and the rules followed while specifying the parameters.
• Identify the tasks performed in the stages of instance startup and shutdown.
• Identify the characteristics and parameters of dynamic performance views and display the current parameter values by using V$PARAMETER.
• Modify a dynamic initialization parameter by using the Oracle Instance Manager and manage user sessions by using the Oracle Instance Manager.
• Identify the characteristics of trace and alert files, the parameters controlling the trace files, and the contents of alert files.
• Identify the character-encoding schemes and the reasons for choosing the national character sets for the database.
• Identify the database initialization parameters, the derived NLS parameters, and the way to
control the sort sequence.
• Retrieve the data dictionary information about the character sets and the NLS settings.
Objectives
Unit 1: Oracle Architecture Components 1 - 2 hours
• Match the memory structures of the SGA with the information that they store.
• Match the mandatory background processes with their functions.
• Match the different types of files existing in a database with the information that they store.
• Match database-related files with the information that they store.
• 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 Oracle security types with their functions.
• Sequence the stages in processing a query.
• Identify the information stored in the shared pool components.
• Identify the characteristics of the database buffer cache.
• Identify the features of buffer cache advisory.
• Match the contents of the Program Global Area 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 to write to the data files.
• Identify the events that cause the Log Writer to write to the redo log files.
• Identify the uses of system change numbers during commit processing.
• Sequence the steps that occur during the process of commit processing.
• Identify the advantages of the fast commit process used by the Oracle server.
Unit 2: Administration Tools 1 - 2 hours
• Identify the tasks of a database administrator.
• Match the utilities used by the DBA with the administrative tasks that they enable the DBA to perform.
• Identify the features of the Universal Installer.
• Match the features of the OEM architectural components with their functions.
• Match the OEM Console components with the tasks that they perform.
• Match the OEM services with their tasks.
• Sequence the steps performed to set up OEM for use.
• Match the OEM DBA Management Pack applications with the tasks that they enable you to perform.
• Match the components in the additional management packs with their functions
Unit 3: Managing an Oracle Instance 2 hours
• Identify the characteristics of the default DBA user accounts.
• Set up a NT log on to the Oracle database without a password by using NT User Manager.
• Match the REMOTE_LOGIN_PASSWORDFILE parameters with their functions.
• Set up a password file authentication on an NT platform by using the ORAPWD utility.
• Change the SYS password by using the ORAPWD utility.
• Identify the uses of the parameters included in the parameter file.
• Identify the rules that govern the parameter values specified in the parameter file.
• Identify the essential parameters for an Oracle instance.
• Match the undo mode initialization parameters with their functions.
• Match the license parameters with their functions.
• Identify the commonly modified parameters of a parameter file.
• Identify the features of SPFILE.
• Identify the guidelines that you use to create a SPFILE.
• Identify the features of SPFILE in Real Application Clusters.
• Match the stage of instance startup with the correct description.
• Identify the methods that are used to start an instance.
• Start an Oracle instance by using the OEM Console.
• Change a database state by using the OEM Console.
• Identify the features of a quiesced database state.
• Match the shutdown stages with the tasks performed in each stage.
• Identify the conditions with which the instance is shutdown in each shutdown mode.
• Identify the features of dynamic performance views.
• Match the columns of the V$SPPARAMETER view with the data they store.
• Match the associated dynamic performance view with a given description.
• Display the current parameter values by using the V$PARAMETER dynamic performance view.
• Match the dynamic buffer cache parameters with the values they store.
• Modify a dynamic initialization parameter by using the OEM Console.
• Change the database mode by using the OEM Console.
• Terminate a user session by using the OEM Console.
• Identify the differences between an alert file and a trace file.
• Match the trace file parameters with the values that they store.
• Identify the information stored in a given alert file.
Unit 4: Globalization Support 2 hours
• Identify the features of Globalization Support.
• Match the character-encoding scheme classes with their descriptions.
• Identify the features of the character sets.
• Identify the combinations of the Globalization Support parameters used for specifying the default conventions and session characteristics.
• Match the derived Globalization Support parameters with their descriptions.
• Override the default Globalization Support behavior for an individual session by using the NLS_LANG environment variable.
• Change the Globalization Support settings for a session by using the ALTER SESSION command.
• Specify the linguistic sort type by using the NLS_SORT parameter.
• Identify the SQL statement that uses an SQL function and a Globalization Support parameter to generate the given output on its execution.
• Identify the features of various semantics.
• Select the tests that are performed on data during the scan.
• Identify the steps that are used in the scanning process.
• Retrieve the character sets for the database by using the nls_database_parameters view.
• Retrieve information about Globalization Support settings by using views.
Oracle Certification 9i Database Administration: Create a Database
The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i.
Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course
discusses how to create and maintain databases. The course also covers the new features of Oracle9i, such as Oracle Managed Files and Undo tablespaces, and the new features of the LogMiner utility.
Learn To
• Discuss the guidelines for creating an OFA structure and the information in the ORACLE_HOME subdirectories.
• Identify the requirements and factors considered while creating a database, the guidelines for
planning the physical database design, the registry entries that must be specified for proper database functionality, and create a password file.
• Identify the types of parameter files, create a parameter file by editing settings in the init.ora file, and start an instance in the NOMOUNT mode.
• Identify the command options of the CREATE DATABASE command, the situations in which it fails, create a database by using the CREATE DATABASE command and identify its content after creation.
• Identify the benefits of using Oracle-Managed Files and manage data files, control files, and online redo log files using OMF.
• Describe the data dictionary structure, identify the data dictionary categories, and retrieve data dictionary information.
• Execute catproc.sql and identify the uses of administrative scripts categories.
• Identify the properties of stored procedures and packages, the benefits 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 groups, the features of members, and the parameter values of redo log files.
• Identify the situations in which log switches and checkpoints occur, force log switches and checkpoints, and identify the functions of parameters that control the checkpoints.
• Identify the features of archive modes and retrieve information about the archive modes and online redo log groups and members.
• Plan the number and size of online redo log files, maintain redo log members and groups, and troubleshoot LGWR errors.
• Identify the logical database structure and the types of tablespaces, create, resize, and change the properties of a tablespace by using Oracle Enterprise Manager.
• Create read-only tablespaces and drop tablespaces, identify the benefits of multiple tablespaces, and specify storage parameters and retrieve data dictionary information.
• Identify the features of undo tablespaces and manage undo tablespaces.
Objectives
Unit 1: Creating a Database: Procedure 1 - 2 hours
• Identify the guidelines for creating an OFA-compliant directory structure for Windows NT.
• Match the ORACLE_HOME subdirectories with their contents.
• Identify the factors to be considered when creating a database.
• Identify the prerequisites 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.
• Create a database by using the Oracle Database Configuration Assistant.
• Identify the registry entries that must be specified for a database to function efficiently.
• Specify a password file for an instance by using the ORAPWD utility.
• Identify the features of Oracle9i parameter files.
• 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 the Oracle SQL*Plus Worksheet.
• Identify the functionality of the CREATE DATABASE command options.
• Create a database with the specified parameter values by using the CREATE DATABASE command.
• Identify the commonly encountered situations in which the CREATE DATABASE command fails.
• Identify the database components that are created upon successful execution of the CREATE DATABASE command.
• Identify the characteristics associated with the Oracle-Managed Files feature in Oracle9i.
• Identify the benefits of using the OMF feature of Oracle9i.
• Select the features of the Oracle-Managed Files initialization parameters.
• Set the OMF initialization parameters by using the INIT.ORA file.
• Match the Oracle file types with their OMF-compliant filenames.
• Identify the clauses that can be omitted during database creation by specifying the DB_CREATE_FILE_DEST initialization parameter.
Unit 2: Data Dictionary and Standard Packages 1 - 2 hours
• Identify the types of information stored in the data dictionary.
• Identify the features of the data dictionary components.
• Create data dictionary views for a specific database by executing the appropriate script.
• Identify the contents of data dictionary view categories.
• Retrieve specific information by querying data dictionary views.
• Identify the features of dynamic performance tables.
• Create PL/SQL functionality for a specified database by using the Oracle SQL*Plus
Worksheet.
• Match the administrative scripts categories with their functions.
• Identify the properties of stored procedures.
• Identify the properties of packages.
• Identify the benefits of using stored program units.
• Match the Oracle-supplied packages with their functions.
• Retrieve information about the status of objects in a specified database by querying the
DBA_OBJECTS data dictionary view.
• Retrieve information about a stored program unit specification by using the DESCRIBE command.
• Identify the common situations when a dependent object may have an INVALID status.
Unit 3: Maintaining Redo Logs and Control Files 2 hours
• Identify the functions of a control file.
• Identify the types of information stored in a control file.
• Match the dynamic performance views with the information they contain about the control files.
• Multiplex a control file by using the OEM Console.
• Identify the uses of redo log groups.
• Identify the features of redo log members in a group.
• Identify the features of the parameters that limit the number of online redo log files.
• Identify the situations in which a log switch occurs.
• Force a log switch by using the OEM Console.
• Identify the situations in which a checkpoint occurs.
• Force a checkpoint by using the OEM Console.
• Select the features of the initialization parameters that control database checkpoints.
• Select the features of the ARCHIVELOG and NOARCHIVELOG archive modes.
• Match the command and dynamic performance views with the information they access about the log and archive status of a database.
• Match the dynamic performance views with the information they provide about online redo log groups and members.
• 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 and separating them from data files.
• Identify the factors that influence the sizing of the online redo log files.
• Add a redo log group by using the OEM Console.
• Add an online redo log member to a redo log group by using the OEM Console.
• Sequence the steps you use to relocate an online redo file.
• Drop an online redo log group by using the OEM Console.
• Drop an online redo log member by using the OEM Console.
• Reinitialize an online redo log file by using the Oracle SQL*Plus Worksheet.
• Identify the new features of LogMiner for redo log files generated by Oracle9i.
• Match the LogMiner views with their contents.
• Sequence the steps in a typical LogMiner session.
• Match the situations in which specific online redo log members are not available with the resulting LGWR behavior.
• Match the possible LGWR error situations with their solutions.
Unit 4: Managing Tablespaces and Data Files 2 hours
• 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 data file.
• Identify the features of SYSTEM and non-SYSTEM tablespaces.
• Identify the features of locally-managed tablespaces.
• Identify the features of multiple nonstandard block size tablespaces.
• Identify the features of temporary tablespaces.
• Identify the restrictions on default temporary tablespaces.
• Identify the features of undo tablespaces in Oracle9i.
• Identify the factors to be considered while planning for a tablespace.
• Create a specified tablespace by using the OEM Console.
• Match the parameters for segment storage allocation with what these parameters determine.
• Create a temporary tablespace by using the OEM Console.
• Set a temporary tablespace as the default temporary tablespace by using the OEM Console.
• Create a tablespace with a nonstandard block size by using the BLOCKSIZE clause.
• Add a data file to a tablespace by using the OEM Console.
• Enable automatic extension of a data file in a tablespace by using the OEM Console.
• Resize a data file by using the Oracle SQL*Plus Worksheet.
• Drop a tablespace by using the OEM Console.
• Identify the effects of dropping a tablespace.
• Change the values of the default storage parameters by using the OEM Console.
• Match the tablespace offline modes with their features.
• Take a tablespace offline by using the OEM Console.
• Move a data file from a non-SYSTEM tablespace by using the OEM Console.
• Move a data file belonging to the SYSTEM tablespace by using the Oracle SQL*Plus Worksheet.
• Make a read-only tablespace by using the OEM Console.
• Sequence the steps to create a read-only tablespace on read-only media.
• Create an undo tablespace by using the OEM Console window.
• Drop an undo tablespace by using the OEM Console.
• Alter an undo tablespace by using the OEM Console.
• Identify the benefits of using multiple tablespaces.
• Match the dynamic performance and data dictionary views with the information they contain
Oracle Certification 9i Database Administration: Manage Storage Structures
The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in
Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free
space, undo space, temporary segments, and indexes.
Learn To
• Identify the types of segments in the storage hierarchy.
• Identify the benefits, working, and packages of automatic management of segment free space.
• Identify the ways in which extents are controlled by segments.
• Identify the block space utilization parameters.
• Retrieve storage structure information.
• Identify the purposes and the types of rollback segments.
• Explain the processes that rollback segments follow for transactions.
• Plan, create, and acquire rollback segments.
• Modify and remove rollback segments.
• Retrieve rollback segment information from the data dictionary.
• Describe the solutions to rollback segment problems.
• Explain the concepts of automatic management of undo space.
• Identify the purpose and the features of the various types of temporary segments.
• Retrieve temporary segment information from the data dictionary.
• Maintain indexes.
Objectives
Unit 1: Storage Structures 1 - 2 hours
• Identify the correct order of the components in the storage hierarchy.
• Match the segment types with their features.
• Identify the factors that determine the order of precedence for controlling extent allocation.
• Coalesce free space in a given tablespace by using the Oracle SQL*Plus Worksheet.
• Match the data block contents with their features.
• Match the block space utilization parameters with their uses.
• Select the features of a bitmapped block.
• Identify the benefits of auto-management of free space.
• Match the columns that have been modified to support auto-management of segment free space with the existing views that contain them.
• Retrieve the information to determine the number of extents and blocks allocated to a segment by using the Oracle SQL*Plus Worksheet.
• Retrieve the physical location information for a given segment by using the Oracle SQL*Plus Worksheet.
• Retrieve the free space information for a given tablespace by using the Oracle SQL*Plus Worksheet.
• Match the procedures of the DBMS_SPACE package with their uses.
• Match the DBMS_REPAIR package procedures with their descriptions.
Unit 2: Undo Space Management 1 - 2 hours
• Identify the purposes of undo segments.
• Select the features of automatic undo management.
• Sequence the steps that the Oracle server uses to ensure read consistency when a transaction occurs.
• Match the undo segments types with their features.
• Select the features of undo retention control.
• Identify the rules for automatic undo mode configuration.
• Identify the features of switching undo tablespaces.
• Switch undo tablespaces by using the OEM Console.
• Identify the factors to be considered while planning rollback segments.
• Identify the guidelines for creating a rollback segment.
• Create a rollback segment by using the OEM Console.
• Bring a rollback segment online by using the OEM Console.
• Identify the steps that an Oracle instance uses to acquire rollback segments when a database opens.
• Sequence the steps in which transactions use rollback segments.
• Identify the conditions under which rollback segments shrink.
• Change the rollback segment storage parameters by using the OEM Console.
• Deallocate unused space from a rollback segment by using the OEM Console.
• Take a rollback segment offline by using the OEM Console.
• Remove a rollback segment by using the OEM Console.
• Identify the solutions to the problem of insufficient space for transactions.
• Identify the preventive measures for the read consistency error.
• Identify the solutions to the blocking session problem.
• Sequence the steps to resolve an error in taking a tablespace offline.
• Obtain undo statistics by using the Oracle SQL*Plus Worksheet.
• Display the general information about rollback segments by using the OEM Console.
• Retrieve the statistics about rollback segments by using the Oracle SQL*Plus Worksheet.
• Retrieve information about rollback segments that currently have active transactions by using the Oracle SQL*Plus Worksheet.
Unit 3: Managing Temporary Segments 2 hours
• Identify the features of the various types of temporary segments.
• Identify the guidelines for using temporary segments.
• Retrieve the temporary segment statistics by using the Oracle SQL*Plus Worksheet.
• Retrieve information about temporary segment activity by using the Oracle SQL*Plus Worksheet.
Unit 4: Managing Indexes 2 hours
• Modify the index storage parameters by using the OEM Console window.
• Allocate index space by using the Oracle SQL*Plus Worksheet.
• Deallocate the unused space from an index by using the Oracle SQL*Plus Worksheet.
• Retrieve index information by using the Oracle SQL*Plus Worksheet.
• Monitor index space usage by using the Oracle SQL*Plus Worksheet.
• Identify unused indexes by using the Oracle SQL*Plus Worksheet.
Oracle Certification 9i Database Administration: Manage Data Storage
This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables,
maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
Learn To
• Identify the row storage method used by the various tables and the components of the row structure in an Oracle database.
• Identify the features of the Oracle datatypes and ROWID.
• Identify the guidelines for creating tables and the situations resulting in row chaining, and create tables.
• Identify the characteristics of table parameters and high-water mark, change the parameter
value, manually allocate extents, validate table structure and detect row migration.
• Identify the effects of truncating a table, drop and truncate a table, and deallocate free apace.
• Retrieve the table, extent and row location information from data dictionary.
• Identify the features of index-organized tables and alter tables.
• Identify the various types of database triggers and the methods to disable and enable the triggers.
• Identify the guidelines for implementing constraints and create the two types of constraints.
• Disable, enable and drop constraints and triggers in the validate and the novalidate mode, and identify the steps for using the EXCEPTIONS table.
• Retrieve constraint, constraint columns, PK-FK relationship information and trigger information by using Oracle SQL*Plus Worksheet.
• Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables.
• Identify the uses of the export and import utilities, the export modes, and the export paths.
• Reorganize data using export and import, identify the features and process of transportable
tablespaces and the restrictions while using them.
Objectives
Unit 1: Managing Tables 1 hour
• Identify the information stored in a table row.
• Identify the features of the built-in scalar datatypes.
• Match the new Oracle9i datatypes with their features.
• Label the components of a ROWID with their respective component names.
• Identify the characteristics that distinguish VARRAYs from nested tables.
• Identify the features of Unicode data.
• Match the structures used to store data with their features.
• Create a table by using Oracle Enterprise 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 Enterprise Manager.
• Identify the features of the cost-based optimizer.
• Create a temporary table by using the CREATE command.
• Identify the storage parameters that affect tables.
• Identify the block utilization parameters that affect table blocks.
• Modify the storage and block parameters of a table by using Oracle Enterprise Manager.
• Allocate extents manually 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 Enterprise Manager.
• Identify the features of dropping unused columns from a table.
• Retrieve table information by using Oracle SQL Worksheet.
• Retrieve the extent information from the DBA_EXTENTS view by using Oracle SQL*Plus Worksheet.
• Obtain the physical location of the rows in a table by using Oracle SQL*Plus Worksheet.
• Identify the features of index organized tables.
• Identify the features of IOTs not available in regular tables.
• Create an index-organized table by using the CREATE TABLE statement.
• Maintain IOTs using the ALTER TABLE...MOVE command.
• Analyze index-organized tables by using the ANALYZE statement.
• Match the application types of index-organized tables with their features.
Unit 2: Maintaining Data Integrity 1 hour
• Identify the features of triggers and integrity constraints.
• 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.
• Drop triggers by using Oracle Enterprise Manager Console.
• Create a constraint when creating a table using Oracle SQL*Plus Worksheet.
• Create a constraint after a table has been created 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 Worksheet.
• Enable constraints in the validate mode by using Oracle SQL Worksheet.
• Sequence the steps needed for detecting constraint violations by using the EXCEPTIONS table.
• Drop constraints by using Oracle SQL*Plus Worksheet.
• 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: Loading Data 1 - 2 hours
• 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.
• Identify typical SQL*Loader concepts.
• 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 features of logical records.
• Identify the guidelines you follow to minimize errors and maximize the performance of SQL*Loader.
• Load data into a table by using Oracle Enterprise Manager.
• Identify the methods of troubleshooting the problems that can occur during a SQL*Loader data load.
Unit 4: Managing Indexes 1 - 2 hours
• Match the types of indexes with their features.
• Identify the characteristics of a 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.
• Identify the characteristics of a function-based index.
• Identify the guidelines for creating indexes.
• Create a normal B-tree index by using Oracle Enterprise Manager.
• Create a reverse key index by using Oracle SQL*Plus Worksheet.
• Create a bitmap index by using Oracle Enterprise Manager.
• Create a function-based index by using Oracle SQL*Plus Worksheet.
• Drop a given index by using Oracle Enterprise Manager.
• Identify the situations in which indexes need to be rebuilt.
• Identify the characteristics of index rebuilds.
• Rebuild indexes online using the ONLINE keyword.
• Identify the features of coalescing indexes.
• Identify features of indexes on index-organized tables.
• Identify features of secondary indexes on index-organized tables.
Unit 5: Reorganizing Data 2 hours
• 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 command with their purposes.
• Match the command line parameters for the IMPORT command with their purposes.
• Identify the guidelines for using the Export and Import utilities.
• Export objects by using Oracle Enterprise Manager.
• Import objects by using Oracle Enterprise Manager.
• Identify the characteristics of the import process.
• Identify the NLS considerations for exporting and importing objects.
• Identify the export and import strategies.
• Identify the features of a transportable tablespace.
• Sequence the steps needed to transport a tablespace to another database.
• Identify the restrictions for transporting a tablespace.
Oracle Certification 9i Database Administration: Manage Security
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods
associated with implementing security and resource consumption in an Oracle9i database.
Learn To
• Define and maintain the five components of the security domain of a user in a given environment.
• Define and maintain a named set of resource and password limits.
• Demonstrate the use of resource limits and how to set them.
• Manage system and object privileges.
• Control the administration of privileges in a database.
• Demonstrate the use of concepts and skills to keep track of the various events occurring in an Oracle9i database.
Objectives
Unit 1: Managing Users 1 - 2 hours
• 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 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 1 - 2 hours
• Identify the uses of profiles.
• Create a user profile.
• Assign a profile to an existing user by using Oracle Security Manager.
• Alter a user profile to modify resource limits using Oracle Security Manager.
• Drop a user profile 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 the password and locking information from the data dictionary using Oracle SQL*Plus Worksheet.
Unit 3: User Resource Consumption 1 hour
• 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.
• Identify Resource plan directives with their uses.
Unit 4: Managing Privileges 1 hour
• 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 Oracle9i.
• Revoke system privileges by using Oracle Security Manager.
• Identify the implication of revoking a system privilege that is granted using 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.
• Identify features of Oracle Enterprise Security.
• Identify the features of the single sign-on functionality.
Unit 5: Managing Roles 1 hour
• Identify the characteristics of roles.
• 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 the information on active roles and privileges by using Oracle SQL*Plus Worksheet.
Unit 6: Auditing 1 hour
• 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 command to audit statements by using an Oracle SQL*Plus Worksheet.
• Specify the command to audit a privilege by using an 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 by using Oracle SQL Worksheet.
• Match the audit option views with the information they display.
• Display the audit results by using Oracle SQL*Plus Worksheet.
• Identify the auditing guidelines.
• Move the AUD$ table to a non-SYSTEM tablespace by using Oracle SQL*Plus Worksheet.
|
