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...
Clasificación: | Libro Electrónico |
---|---|
Otros Autores: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
San Francisco, Calif. ; London :
SYBEX,
©2005.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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