OCA Oracle 10g administration I study guide
Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned S...
| Other Authors: | , |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
San Francisco ; London :
SYBEX
c2005.
|
| Edition: | 1st edition |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627590706719 |
Table of Contents:
- OCA: Oracle 10g Administration I Study Guide; Frontmatter; Acknowledgments; Contents at a Glance; Contents; Introduction; Assessment Test; Answers to Assessment Test; Chapter 1: Oracle Database 10g Components and Architecture; The Oracle Product Family; Oracle 10g; Oracle Application Server 10g; Oracle Developer Suite; Oracle Applications 11i; Oracle Collaboration Suite; Oracle Services; Relational Database Concepts; Rows, Columns, Tables, and Databases; Relationships and Constraints; Other Segment Types; Interacting with Segments; The Oracle Architecture; User Processes; The Oracle Instance
- The Oracle DatabaseInstalling Oracle 10g; Review the Documentation; Review the System Requirements; Plan Your Install; Using the Oracle Universal Installer; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 2: Creating and Controlling a Database; The Oracle Enterprise Management Framework; Starting and Stopping the Oracle Management Agent; Accessing a Database Using the Database Control; Using iSql*Plus; Using the Oracle Database Configuration Assistant; Creating an Oracle Database Using the DBCA; Configuring an Oracle Database Using DBCA
- Deleting an Oracle Database Using DBCAManaging Database Templates Using DBCA; Managing Parameter Initialization Files; Starting Up and Shutting Down an Oracle Database; Oracle 10g Database Startup; Shutting Down an Oracle 10g Database; Shutting Down Oracle Using EM Database Control; Shutting Down Oracle Using SQL*Plus; Monitoring the Database Alert Log; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Database Storage and Schema Objects; Identifying Segments, Extents, and Data Blocks; Managing Tablespaces; Identifying Default Tablespaces
- Creating and Maintaining TablespacesObtaining Tablespace Information; Managing Datafiles; Working with Schema Objects; Specifying Datatypes; Creating Tables; Working With Constraints; Working with Indexes; Working with Views; Working with Sequences; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Oracle Net Services; Network Design Considerations; Network Complexity Issues; Network Security Issues; Interfacing Existing Systems with New Systems; Network Responsibilities for the DBA; Network Configurations; Single-Tier Architecture; Two-Tier Architecture
- N-Tier ArchitectureAn Overview of Oracle Net Features; Connectivity; Manageability; Scalability; Security; Accessibility; Configuring Oracle Net on the Server; Understanding the Oracle Listener; Managing Oracle Listeners; Dynamically Registering Services; Additional Configurations When Using Multiple Listeners; Troubleshooting Server-Side Connection Problems; Oracle Net Logging and Tracing on the Server; Configuring Oracle Net for the Client; Client-Side Names Resolution Options; The Hostnaming Method; The Oracle Easy Connect Naming Method; The Localnaming Method
- Troubleshooting Client-Side Connection Problems
