Oracle9i Database Fundamentals I Curriculum CBT Training CDs

Rating:
Summary: Oracle9i Database Fundamentals I Curriculum
Review: Course Overview
The Oracle9i Database Fundamentals I Curriculum covers the database administration strategies and procedures provided in Oracle9i. This curriculum introduces the participants to the concepts and procedures associated with Oracle architectural components, the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this curriculum teaches users the procedures for managing segment free space, undo space, temporary segments, and indexes. Lastly participants will learn the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data, and the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.

# This curriculum consists of five courses: Course 64311 Oracle9i Database Administration: Manage an Instance
# Course 64312 Oracle9i Database Administration: Create a Database
# Course 64313 Oracle9i Database Administration: Manage Storage Structures
# Course 64314 Oracle9i Database Administration: Manage Data Storage
# Course 64315 Oracle9i Database Administration: Manage Security

Certification: This curriculum will help candidates prepare for the Oracle9i OCP DBA Certification and is mapped to Exam 1Z1-031.

Learn To
See individual course descriptions for specific course objectives and scope.


Audience
The intended audience for this curriculum include Database administrators, System administrators, Network administrators, and Technical support professionals.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course

Language Options
US English

Total Learning Time
30 to 40 hours

Oracle 9i Database Administration: Manage an Instance Training CD
Course Overview
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.


Audience
The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Brazilian Portuguese, US English, German, French, Spanish

Total Learning Time
6 to 8 hours

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 9i Database Administration: Create a Database Training CD
Course Overview
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.


Audience
The intended audience for this course include Database Administrators, System Administrators, Network Administrators, Technical Support Professionals, and Consultants. Additionally, learners should have taken the first part of the series 64311. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
German, Spanish, Brazilian Portuguese, US English, French

Total Learning Time
6 to 8 hours

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 9i Database Administration: Manage Storage Structures
Course Overview
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.
# Monitor indexes.


Audience
The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first two parts of this series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
US English, Spanish, German, Brazilian Portuguese, French

Total Learning Time
6 to 8 hours

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 9i Database Administration: Manage Data Storage
Course Overview
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.


Audience
The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first three parts of this series 64311-64313. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
US English, German, Brazilian Portuguese, French, Spanish

Total Learning Time
6 to 8 hours

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.