OCA OCP - Oracle10G New Features For Administrators Exam by PDF

Read or Download OCA OCP - Oracle10G New Features For Administrators Exam Guide PDF

Similar databases books

New PDF release: The New Relational Database Dictionary: Terms, Concepts, and

It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the correct meanings of phrases, misunderstandings that could have a significant influence at the good fortune of your database tasks. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating workforce, subscribe to dependency.

Extra info for OCA OCP - Oracle10G New Features For Administrators Exam Guide

Sample text

You will corrupt the database if you try to start it under the old Oracle Home. C. You can start it under the old Oracle Home, as long as your compatibility is set to the old database version level. D. 0. LAB QUESTIONS Lab 1 Using the OEM Database Control, find the locations of the following: ■ Tablespaces ■ Flash recovery area Lab 2 Using the OEM Database Control, how do you find out the initialization parameters for the instance? vp Thursday, September 02, 2004 12:50:50 PM Color profile: Generic CMYK printer profile Composite Default screen 58 Chapter 1: CertPrs8 / OCP Oracle Database 10g Exam Guide / Alapati / 225862-4 / Chapter 1 Installation, Server Configuration, and Database Upgrades Lab 3 Manually create a SYSAUX tablespace with a size of 1GB.

Both SHARED_POOL and DB_NAME belong to the basic set of initialization parameters, which should be sufficient in most cases. The parameters in the advanced list are necessary only under some special conditions. ý You can easily see that B and D refer to initialization parameters that belong to the advanced group, not the basic group of parameters. 8. þ B. The creation of the flash recovery area is mandatory only if you configure automatic backups using the OEM. ý A is clearly wrong, since the flash recovery area is not mandatory under all circumstances.

17 database to the Oracle Database 10g version. 0 prior to upgrade. ora or spfile] –> "job_queue_interval" –> "max_enabled_roles” ************************************************************************* Components: [The following database components will be upgraded or installed] –> Oracle Catalog Views [upgrade] –> Oracle Packages and Types [upgrade] ... 1 environment] –> New "SYSAUX" tablespace .... 1 server is started and BEFORE you invoke the upgrade script. vp Thursday, September 02, 2004 12:50:48 PM Color profile: Generic CMYK printer profile Composite Default screen 40 Chapter 1: CertPrs8 / OCP Oracle Database 10g Exam Guide / Alapati / 225862-4 / Chapter 1 Installation, Server Configuration, and Database Upgrades Back Up Your Database At this point, shut down and back up your current database, by using either the RMAN or by using user-managed backup techniques.

Download PDF sample

Rated 4.28 of 5 – based on 13 votes