DescriptionHere's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). 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 the enhancements included in Oracle 10g
- Practical examples and insights drawn from the authors' real-world experiences
- Leading-edge exam preparation software, including a test engine and electronic flashcards
You'll also find authoritative coverage of key exam topics, including:
- Installing and Configuring the Server
- Loading and Unloading Data
- Tuning Applications
- Supporting Analytical Applications
- Backing Up and Recovering Data
- Automating Data Storage Management
- Applying Security Policies
- Supporting Upgrade Paths to Oracle 10g
Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Chapter 1 Installing and Upgrading to Oracle.
Chapter 2 Moving Data and Managing the Scheduler.
Chapter 3 Automating Management.
Chapter 4 General Storage Management.
Chapter 5 Automated Storage Management.
Chapter 6 Performance and Application Tuning.
Chapter 7 Backup, Recovery, and High Availability.
Chapter 8 Security and SQL Enhancements.
Appendix A SQL*Plus Enhancements.
Appendix B New and Obsolete Initialization Parameters.
Appendix C PL/SQL Enhancements and New Packages.
Last sentence on the page --
"Finally, an ASM instance is always in a NOMOUNT state, since it does not have a control file."
"Finally, an ASM instance can only be in a NOMOUNT or MOUNT state; it can never be in an OPEN state."
replace the last paragraph with the following:
Performing a SHUTDOWN NORMAL on an ASM instance performs the same SHUTDOWN NORMAL command on any database instances using the ASM instance; before the ASM instance finishes its shutdown, it waits for all dependent RDBMS instances to shut down. In contrast, any other SHUTDOWN (such as IMMEDIATE, ABORT, TRANSACTIONAL) on an ASM instance forces a SHUTDOWN ABORT on the dependend RDBMS instances because there is no longer an ASM instance available to manage the database's storage.
Second line from the bottom -
2 '+data2(datafile)/uspare' size 100m;
Answer for question 18 should be replaced with: