OCA [electronic resource] : Oracle 10g administration I study guide / Chip Dawes ... [et al.].
- 1st edition
- San Francisco ; London : SYBEX, c2005.
1 online resource (670 p.)
- Oracle (Computer file) -- Examinations -- Study guides.
Electronic data processing personnel -- Certification.
Database management -- Examinations -- Study guides.
- Electronic books.
- System Details:
- text file
- 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 Sybex the ""Best Study Guide"" selection in CertCities Readers Choice Awards for two consecutive years, this book provides:Clear and concise information on database administration with Oracle 10gPractical examples and insights drawn from the authors' real-world experiencesLeading-edge exam prep
- 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
- "Exam 1Z0-042"--Cover.
- Dawes, Chip.
|Location||Notes||Your Loan Policy|
|Description||Status||Barcode||Your Loan Policy|