《NETg Oracle数据库教程》(NETg Oracle Database 10g Administration Workshop)[Bin]
电驴资源
电驴资源简介
中文名: NETg Oracle数据库教程英文名: NETg Oracle Database 10g Administration Workshop资源格式: 光盘镜像地区: 美国对白语言: 英语简介:
转自TLF
语言:英语
网址:http://netg.com/catalog/detail.asp?c=US67210
类别:教程
教程讲授了如何为多语言应该程序和分布式 数据库访问,配置 Oracle数据库,学生将想到恢复数据库的各种实践方法,使用 RMAN, SQL, 和 Flashback 技术
代码Unit 1 Oracle Database 10g Workshop
Identify features of a Relational Database Management System RDBMS .
Match the different types of integrity constraints with their features.
Identify tasks of an Oracle DBA.
Identify features of Optimal Flexible Architecture OFA .
Identify prerequisites for installing the Oracle Database 10g software.
Identify the steps to install Oracle Database 10g using Oracle Universal Installer OUI .
Identify the steps to create a database using the Database Configuration Assistant DBCA .
Match the files that constitute an Oracle database with their descriptions.
Identify features of a tablespace structure in Oracle Database 10g.
Identify features of memory structures associated with an Oracle instance.
Match background processes in Oracle with their functions.
Identify uses of Database Control.
Identify features of tools that enable you to interact with an Oracle database using SQL.
Identify features of SQL*Plus and iSQL* Plus.
Identify the uses of SQL statements.
Identify features of a PL/SQL block.
Identify features of APIs.
Identify features of Database Control. x
Identify features of Database Control.
Identify database management tasks that can be performed by using the Database home page.
Identify features of tablespaces.
Sequence the steps to create a tablespace. x
Sequence the steps to create a tablespace.
Identify features of storage allocation in locally managed tablespaces.
Identify properties of tablespaces that can be altered using the Enterprise Manager EM .
Identify the actions that can be performed on a tablespace by using the Tablespaces page of the Enterprise Manager EM .
Unit 1 Managing Users
Identify features of database user accounts and profiles in Oracle Database 10g.
Identify options you can configure when creating a user.
Identify options used to grant privileges to a user.
Identify features of quotas assigned to users.
Identify the features of roles assigned to users.
Unit 2 Data - Managing
Identify features of schemas.
Identify rules for naming database objects.
Match data types in Oracle Database 10g with their features.
Identify options for creating and modifying a table.
Identify data integrity constraints used to impose restrictions on data stored in columns.
Identify actions that you can perform on a table using Enterprise Manager.
Identify features of views.
Identify features of sequences.
Identify features of SQL statements used in data manipulation.
Identify tasks for exporting data using the Data Pump utility.
Identify features of data import using the Data Pump utility.
Identify features of SQL*loader.
Identify features of SQL* Loader control files.
Identify features of SQL*Loader data files.
Distinguish between the direct and conventional path loads.
Identify features of PL/SQL.
Identify features of PL/SQL objects.
Unit 1 Working with Databases
Identify security practices and principles that are implemented in Oracle Database 10g.
Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
Identify guidelines for restricting dictionary and directory access.
Identify guidelines for restricting administrative privileges and remote authentication for users.
Match the parameters used for implementing password security with their features.
Identify options to create a password profile and assign it to a user by using the Enterprise Manager EM .
Differentiate between the auditing types provided by Oracle Database 10g.
Match the dictionary views for standard database auditing with their descriptions.
Identify features of FGA policy.
Identify guidelines for creating a new Fine-grained Auditing FGA policy.
Match Fine-Grained Auditing FGA dictionary views with their contents.
Identify features of Oracle Net services and listeners.
Identify options to create, configure, and register an Oracle listener.
Identify features of the Listener control utility.
Match the name resolution methods used by Oracle Net with their descriptions.
Identify features of advanced connection options.
Identify features of Oracle Net Manager.
Identify activities involved in establishing a user session that uses a dedicated server process.
Sequence the steps to process a request using shared servers.
Match the different initialization parameters used to configure Oracle Shared Server with their usage.
Match the data dictionary views related to shared servers with their descriptions.
Match the different performance monitoring types with their features.
Identify features of data dictionary metrics.
Identify features of optimizer statistics.
Identify features of dynamic performance views.
Identify options for viewing metrics and performance information by using Enterprise Manager EM .
Identify features of server generated alerts and thresholds.
Identify the steps to create and apply a baseline.
Match the tuning and diagnostic advisors with their descriptions.
Identify features of the Automatic Workload Repository AWR .
Identify features of Automatic Database Diagnostics Monitor ADDM .
Unit 1 Undo and Lock Management
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to use Undo efficiently.
Identify features of undo retention.
Identify the options that you can configure to size the undo tablespace.
Identify features of locks.
Identify features of lock conflicts.
Unit 2 Backup and Recovery
Match database failures with their possible causes.
Identify features of instance recovery.
Identify key concepts of tuning instance recovery.
Identify the steps that are required for configuring a database to ARCHIVELOG mode.
Identify tasks you should perform to configure a database for maximum recoverability.
Identify features of backups.
Identify features of Recovery Manager RMAN .
Identify options used to configure backup settings.
Identify options that you can specify when scheduling backups.
Identify features of control file trace backups.
Identify options for managing existing backups.
Identify features of database startup statuses for recovery.
Identify the steps to recover from the loss of a single control file.
Identify the steps to recover from loss of redo files.
Identify steps involved in recovering from the loss of a data file.
Identify enhancements in Oracle Database 10g for recovering dropped objects without performing recovery on the database.
转自TLF
语言:英语
网址:http://netg.com/catalog/detail.asp?c=US67210
类别:教程
教程讲授了如何为多语言应该程序和分布式 数据库访问,配置 Oracle数据库,学生将想到恢复数据库的各种实践方法,使用 RMAN, SQL, 和 Flashback 技术
代码Unit 1 Oracle Database 10g Workshop
Identify features of a Relational Database Management System RDBMS .
Match the different types of integrity constraints with their features.
Identify tasks of an Oracle DBA.
Identify features of Optimal Flexible Architecture OFA .
Identify prerequisites for installing the Oracle Database 10g software.
Identify the steps to install Oracle Database 10g using Oracle Universal Installer OUI .
Identify the steps to create a database using the Database Configuration Assistant DBCA .
Match the files that constitute an Oracle database with their descriptions.
Identify features of a tablespace structure in Oracle Database 10g.
Identify features of memory structures associated with an Oracle instance.
Match background processes in Oracle with their functions.
Identify uses of Database Control.
Identify features of tools that enable you to interact with an Oracle database using SQL.
Identify features of SQL*Plus and iSQL* Plus.
Identify the uses of SQL statements.
Identify features of a PL/SQL block.
Identify features of APIs.
Identify features of Database Control. x
Identify features of Database Control.
Identify database management tasks that can be performed by using the Database home page.
Identify features of tablespaces.
Sequence the steps to create a tablespace. x
Sequence the steps to create a tablespace.
Identify features of storage allocation in locally managed tablespaces.
Identify properties of tablespaces that can be altered using the Enterprise Manager EM .
Identify the actions that can be performed on a tablespace by using the Tablespaces page of the Enterprise Manager EM .
Unit 1 Managing Users
Identify features of database user accounts and profiles in Oracle Database 10g.
Identify options you can configure when creating a user.
Identify options used to grant privileges to a user.
Identify features of quotas assigned to users.
Identify the features of roles assigned to users.
Unit 2 Data - Managing
Identify features of schemas.
Identify rules for naming database objects.
Match data types in Oracle Database 10g with their features.
Identify options for creating and modifying a table.
Identify data integrity constraints used to impose restrictions on data stored in columns.
Identify actions that you can perform on a table using Enterprise Manager.
Identify features of views.
Identify features of sequences.
Identify features of SQL statements used in data manipulation.
Identify tasks for exporting data using the Data Pump utility.
Identify features of data import using the Data Pump utility.
Identify features of SQL*loader.
Identify features of SQL* Loader control files.
Identify features of SQL*Loader data files.
Distinguish between the direct and conventional path loads.
Identify features of PL/SQL.
Identify features of PL/SQL objects.
Unit 1 Working with Databases
Identify security practices and principles that are implemented in Oracle Database 10g.
Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
Identify guidelines for restricting dictionary and directory access.
Identify guidelines for restricting administrative privileges and remote authentication for users.
Match the parameters used for implementing password security with their features.
Identify options to create a password profile and assign it to a user by using the Enterprise Manager EM .
Differentiate between the auditing types provided by Oracle Database 10g.
Match the dictionary views for standard database auditing with their descriptions.
Identify features of FGA policy.
Identify guidelines for creating a new Fine-grained Auditing FGA policy.
Match Fine-Grained Auditing FGA dictionary views with their contents.
Identify features of Oracle Net services and listeners.
Identify options to create, configure, and register an Oracle listener.
Identify features of the Listener control utility.
Match the name resolution methods used by Oracle Net with their descriptions.
Identify features of advanced connection options.
Identify features of Oracle Net Manager.
Identify activities involved in establishing a user session that uses a dedicated server process.
Sequence the steps to process a request using shared servers.
Match the different initialization parameters used to configure Oracle Shared Server with their usage.
Match the data dictionary views related to shared servers with their descriptions.
Match the different performance monitoring types with their features.
Identify features of data dictionary metrics.
Identify features of optimizer statistics.
Identify features of dynamic performance views.
Identify options for viewing metrics and performance information by using Enterprise Manager EM .
Identify features of server generated alerts and thresholds.
Identify the steps to create and apply a baseline.
Match the tuning and diagnostic advisors with their descriptions.
Identify features of the Automatic Workload Repository AWR .
Identify features of Automatic Database Diagnostics Monitor ADDM .
Unit 1 Undo and Lock Management
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to use Undo efficiently.
Identify features of undo retention.
Identify the options that you can configure to size the undo tablespace.
Identify features of locks.
Identify features of lock conflicts.
Unit 2 Backup and Recovery
Match database failures with their possible causes.
Identify features of instance recovery.
Identify key concepts of tuning instance recovery.
Identify the steps that are required for configuring a database to ARCHIVELOG mode.
Identify tasks you should perform to configure a database for maximum recoverability.
Identify features of backups.
Identify features of Recovery Manager RMAN .
Identify options used to configure backup settings.
Identify options that you can specify when scheduling backups.
Identify features of control file trace backups.
Identify options for managing existing backups.
Identify features of database startup statuses for recovery.
Identify the steps to recover from the loss of a single control file.
Identify the steps to recover from loss of redo files.
Identify steps involved in recovering from the loss of a data file.
Identify enhancements in Oracle Database 10g for recovering dropped objects without performing recovery on the database.
