Refresh and try again. Open Preview See a Problem? Details if other :. Thanks for telling us about the problem. Return to Book Page. Preview — Oca by Chip Dawes. Bob Bryla. Joseph C. 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 preparation software, including a test engine and electronic flashcardsYou'll also find authoritative coverage of key exam topics, including: Installing Oracle Database 10g SoftwareCreating and Controlling Oracle DatabasesAdministering UsersManaging Schema Objects and DataImplementing Oracle Security FeaturesMonitoring PerformancePerforming Database Backup and Recovery Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace Get A Copy.
Paperback , pages. More Details Original Title. Other Editions 1. Friend Reviews. To see what your friends thought of this book, please sign up. To ask other readers questions about Oca , please sign up. Lists with This Book. This book is not yet featured on Listopia. Community Reviews.
Showing The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog. The initialization parameter should never be set to 0 if you are using RMAN. Which commands are required to perform a compressed RMAN backup? What two values are required to identify a database incarnation within the recovery catalog?
DBID B. What is the most efficient order in which to create a new default temporary tablespace named TEMP2 and have that tablespace available as the default tablespace for users? What is the correct command sequence for recovering a missing tempfile named temp? You are faced with a media failure for a tablespace that is currently read-only.
The only backup of the read-only tablespace was made one week ago when the tablespace was read-write. What do you have to do to recover this tablespace? You only need to restore the datafile for this tablespace because the tablespace is read-only. You only need to restore and recover the datafile for this tablespace because the tablespace you have restored is read-write.
You only need to restore and recover the datafile for this tablespace because the tablespace has a different SCN in the header. You only need to recover the datafile for this tablespace because the tablespace is read-only. User-managed recovery requires which major difference from using RMAN?
User-managed recovery requires the DBA to directly manage the recovery. Why does control file recovery require special steps when using RMAN without the recovery catalog? Special steps are required when recovering control files because they are not part of the physical database. Special steps are required when recovering control files because they contain RMAN metadata information.
Special steps are required when recovering a database when the RMAN repository is not available for that database. Special steps are required when recovering control files because they cannot be easily rebuilt. Logical corruption has been introduced into the database.
You need to recover the database to the point-in-time prior to the introduction of the corruption. The logical corruption was intro- duced at P. You have a backup from two days ago. It is discovered that corruption was introduced today at P. You perform an incomplete recovery of the database to P. One day later you have a media failure, and you need to recover but you only have the same backup that was used to perform an incomplete recovery prior to the corruption.
What will hap- pen to the recovery attempt for the media failure? The media recovery will only be successful if you recover the database back to the original time of P. Where are the flashback database logs stored? Flashback database logs are stored in the flash recovery area. Which of the following statements are correct regarding warnings at flash recovery thresholds? At 90 percent, there is a full warning and obsolete files are removed.
At 85 percent, there is a full warning. At 95 percent, there is a full warning and obsolete files are removed. At 95 percent, there is a full warning. Assessment Test xxxv. What files are considered transient in the flash recovery area? Flashback logs B. Multiplexed redo logs C. Control files D. Datafiles E. RMAN working files. Which initialization parameter will not create files in the flash recovery area?
How would you assure that the triggers you need enabled are enabled and the triggers you need disabled are disabled after a Flashback Table recovery? Make sure that all triggers are enabled before a table is Flashback Table recovered. Manually enable and disable all triggers after the Flashback Table recovery. Make sure that all triggers are disabled before a table is Flashback Table recovered. How can you identify multiple objects dropped with the same name in the Recycle Bin?
None of the above. A user accidentally deleted a customer identified by from the customers table on September 6, at P. All database objects by default B. What is the correct syntax for performing a block media recovery for corrupt blocks in datafile 4 and 5 with blocks 5 and 6, respectively? Any incremental backup should not be used to support BMR.gyacoopobarloa.ml/map39.php
Oracle Business Intelligence Certification
Only a differential incremental backup should not be used to support BMR. Full backups should not be used to support BMR. Only a cumulative incremental backup should not be used to support BMR. Assessment Test xxxvii.
You create a new table, populate it, and build several indexes on the table. When you issue a query against the table, the optimizer does not choose to use the indexes. Why might this be? The indexed columns are not used in the where clause of the query. There are no statistics available for the table.
There is a small number of rows in the table. The query contains a hint instructing the optimizer not to use the indexes. All of the above. What is the result of this action? Choose the best answer. The action resolves the issue. The action has no effect. The action only partially resolves the issue. The action has a detrimental effect regarding the issue. You have created a new table.
How long do you have to wait to be sure that Oracle has auto- matically gathered optimizer statistics for the table and loaded them into the AWR? Not more than 30 minutes. Up to seven days. Until the next scheduled automated statistics collection job is run. Optimizer statistics are not stored in the AWR. You must gather the statistics manually when a new table is created. Oracle will collect them automatically after that. You are concerned about the operating system performance as well as SQL execution plan statistics. ALL E. None of these settings will achieve the desired result. An ASM disk group can manage database files from how many different databases?
Limited only by disk space. ASM disk groups manage tablespaces, not database files. High redundancy disk groups must have how many failure groups? Exactly 3 D. Tablespace level B.
Extent level C. Segment level D. Datafile level. Identify two valid types of Oracle instances. RMAN B. ASM D. DBMS E. A new workstation has been added at your location in Spain. This machine will be used to run an application that connects to your database in the United States. A technician installs the Oracle client and the application. The user on the new machine notices that performance seems to be sluggish compared to the existing workstations. The technician swears that the applica- tion is configured identically on all machines, and has ruled out network issues. What is the most likely cause?
Defective hardware B. Client character set C. Routing tables. You are setting up a new database instance that needs to support several languages. Conserving storage is a high priority. Point-in-time recovery is absolutely required. How would you go about choosing a character set to use? Choose a Unicode character set. Choose the smallest Unicode character set. Investigate multi-byte character sets to find one that supports the languages that you need. Use a single-byte Unicode character set. Investigate single-byte character sets to find one that supports the languages you need.
Assessment Test xxxix. How many characters will you be able to store in the NAME column? It depends on the size of a byte on the server platform. It depends on the character set. Somewhere between 7 and Which language setting will govern client-side NLS operations? It depends on the operation.
Six of the groups will get 15 percent and the remaining group will receive 10 percent. Which of the following would achieve all of these objectives with the least amount of effort? Create a simple plan. Create a complex plan with one sub-plan. Create a complex plan with more than one sub-plan. Create a simple plan with one sub-plan.
Create a simple plan with more than one sub-plan. You are creating a complex plan. You need to limit the degree of parallelism for an existing consumer group. Which DRM element do you need to create? Sub-plan B. Group allocation C. Resource D. Resource plan directive E. Parallel directive.
Other Titles by Chip Dawes
You have finished building all of your DRM objects in the pending area. What do you know about the status of the pending area? Select the best answer. The pending area was successfully validated. The pending area has been scheduled for validation. You are unsure if the other DBA submitted the correct pending area. The pending area was successfully validated and is now active.
You want to create the elements for a resource plan that allocates twice as much CPU to one group than to another. Which of the following do you use?
- Download Oca Oracle 10G Administration I Study Guide 1Z0 042 2004.
- Product description?
- Shop Oca Oracle 10G Administration I Study Guide 1Z.
- Browse more videos!
- The Ultimate DBA Guide to Getting Current with Oracle Database | Oracle Certification Blog.
- CR - The Stakeholder Paradox.
You want to create a scheduler job that is very similar to an existing job. Neither of these jobs requires any arguments. What is the best way to create the new job? Reuse the same job. There is no way to copy a job. Assessment Test xli. Job and window logs will be updated every 60 minutes.
Job logs will be automatically purged after 60 days. Window logs will be automatically purged after 60 days. Job and window logs will be limited to the most recent 60 days.
Oca: Oracle 10g Workshop I Study Guide [With CDROM]
Job and window logs will be automatically purged after 60 days. You have created a new job by copying an existing job. The job must be modified in some way to differentiate it from the original job. The job can only be executed within a certain window. The job is disabled. When a job is copied, the objects referenced by the job must be validated. Consider the index HR. Which of the following commands accomplishes the same task as this command? Which type of queue is supported by sorted hash clusters? LIFO C. FIFO D. If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?
Which of the following statements is not true about segment shrink operations? The compaction phase of segment shrink is done online. During the compaction phase, the entire segment is locked but only for a very short period of time. When the second phase of segment shrink occurs, the high watermark HWM is adjusted. What is the purpose of the overflow area for an index-organized table IOT? The overflow area helps to reduce row chaining in the IOT.
The overflow area allows you to store some or all of the non-primary key data in an IOT row in another tablespace, improving performance. The overflow area is used when there is a duplicate value for the primary key in the IOT. The overflow area stores the index information for indexed columns that are not part of the primary key. You are concerned about ORA messages that have been appearing in the alert log, and you want to know if any new ones appear.
Which Oracle feature might be of use? AWR B. Advisory framework C. Server-generated alerts D. Alert monitor E. You wish to restrict remote access to your database by using Valid Node Checking. Which file do you need to configure? Several users call to report that their sessions appear to be hung. They mention that the problem started within the last few minutes.
You attempt to connect, but your session hangs as well. What would be the best place to look for the cause of the problem? Alert log C. EM Database Control D. Trace files E. A user sends you a SQL script that they say is running very slowly. The explain plan reveals no problems. How might you go about determining the problem? Execute an extended explain plan.
How To Become Oracle Certified DBA
Run the script with SQL tracing enabled. Check for locks on objects referenced in the script. Run the script with background tracing enabled. Answers to Assessment Test 1. The control file autobackup is the name of the process that automates the backup of the control file with every backup. See Chapter 1 for more information. Automated channel fail over requires that multiple channels be allocated. If one channel fails, the backup or recovery operation will use the other channel to complete the operation.
If this value is set to 0, there is a potential to lose backup records. See Chapter 2 for more information. This will make TEMP2 the default temporary tablespace for all users. See Chapter 3 for more information. Then the tablespace can be created. Answers to Assessment Test xlv. You need to restore and recover the tablespace of the read-only tablespace because the tablespace was read-write when the backup was taken. If the tablespace was backed up read- write, the datafile has changed or has a different SCN in the datafile header.
This will require recovery. User-managed recovery requires the DBA to directly manage the recovery process. The DBA must determine which database files to restore and from what backup, as well as which archive logs to apply. See Chapter 4 for more information. Control files contain the RMAN repository when not using the recovery catalog that con- tains metadata about the backups that are used to perform the recovery. This information is not available when recovering a control file. The closest time to P. In previous Oracle versions, you had to take a backup immediately following an incomplete recovery, because the redo log sequences got reset, making the backup unusable.
The flashback database logs must be stored in the flash recovery area. See Chapter 5 for more information. At 90 percent full, a warning is sent to the alert log, and obsolete files are removed. At 95 percent full, warnings are set to the alert log. A, D, E. These files will be overwritten during certain events. Multiplexed redo logs and control files are considered permanent and will not be overwritten, even when the flash recovery area is backed up to tape. A, B, D. See Chapter 6 for more information. All disabled triggers at the time of the Flashback Table recovery are disabled.
The last option is to manually enable and disable all triggers after the Flashback Table recovery has been performed. The Flashback Query will query the deleted customer from the undo data, and the insert command will add the customer back to the customers table. There will be minimal impact on the database. See Chapter 7 for more information. All incremental backups will not support BMR because they contain only changed blocks. All of the choices listed are valid reasons why the optimizer might choose to not use an available index.
See Chapter 8 for more information. While it will not produce an error, it is treated as no operation by Oracle. Automatic DML monitoring is used instead. The AWR does not store optimizer statistics. It stores dynamic performance statistics. Opti- mizer statistics are stored in the data dictionary. An ASM disk group can manage database files for essentially an unlimited number of different databases.
Creating ASM disk groups is discussed in Chapter 9. Answers to Assessment Test xlvii. High redundancy disk groups require disks in at least three failure groups, but they can contain more if a higher level of redundancy or performance is desired. Controlling disk group redundancy is detailed in Chapter 9. Disk group mirroring for ASM is done at the extent level. To learn about Automatic Storage Management mirroring, see Chapter 9.
The most likely cause is that the Oracle client environment is using a character set that does not match the server and is not a strict subset of the server character set. In this situation, Oracle will perform automatic data conversion, which can impact performance. See Chapter 10 for more information. If a single-byte character set can be found that fulfills all of your language requirements, you will save storage space over using a multi-byte character set. A simple plan can allocate CPU resources for up to eight consumer groups at the same level.
Therefore, a simple plan will meet all of these requirements. See Chapter 11 for more information. A resource plan directive needs to be created, which will define the plan, the consumer group, and resource allocation. There can only be one pending area, so there is no question of whether it was the right one.
The resource allocation method is defined at the plan level, not at the plan directive level. The resource allocation method of RATIO indicates that the amounts allocated in subsequent plan directives will represent a weighted amount, rather than a percentage. See Chapter 12 for more information.
By default, copied jobs are created in a disabled state. Chapter 13 discusses segment shrink functionality. Sorted hash clusters are similar to standard hash clusters, except that they store data sorted by non-primary key columns and make access by applications that use the rows in a first in, first out FIFO manner very efficiently; no sorting is required. Chapter 13 describes how sorted hash clusters are created and used.
Oracle recommends that you keep each member of a redo log group on a different disk. You must have a minimum of two redo log groups, and it is recommended that you have two mem- bers in each group.
- Account Options.
- Grand History of the Realms (Forgotten Realms).
- World War I infantry?
- Account Options.
- NMR spectroscopy in liquids and solids.
- Understanding Our Selves: The Dangerous Art of Biography (European Connections).
See Chapter 13 for more information. During the compaction phase, locks are held only on individual rows, causing some minor serialization with concurrent DML operations. For more information about segment shrink, see Chapter For more information about index-organized tables, see Chapter Server-generated alerts would be the best answer. Oracle has a predefined alert that detects ORA messages in the alert log and will raise an alert when they are found.
See Chapter 14 for more information. The sqlnet. The alert log would be the best place to look for information. EM Database Control does allow alerts to be viewed; however, the metrics are unlikely to have been updated because the problem occurred within the last few minutes. This file can be used to troubleshoot the performance problem. RMAN was first introduced in Oracle 8, and Oracle has steadily made enhancements and improvements with each new release of Oracle to meet the heavy demands required for database backup and recovery.
RMAN has grown to meet the demands of exponentially larger database sizes and more strin- gent availability requirements. Database servers have grown in size with technology gains of CPU, bus architectures, and more efficient disk subsystems. Disk costs have steadily decreased to more affordable and acceptable levels and have now become an economic alternative to tape storage.
RMAN has been redesigned in Oracle 10g to support these contemporary database environ- ments. RMAN now places more focus on backing up and recovering the changes to the database instead of the complete database. This allows RMAN to support backups of larger databases and recover in faster timeframes. This chapter discusses configuring and setting up RMAN.
We will walk through this process in detail through examples and demonstrations. This chapter walks through the parameters for RMAN that are demonstrated in the config- uration settings. The remainder of this chapter focuses on more complex topics such as autobackups using the control file.
This chapter takes you through a review of the common RMAN features. The review will demonstrate these features with examples. Where applicable, you will walk through the new 10g features and capabilities of RMAN. In addition, RMAN can handle larger database back- ups and recoveries in quicker timeframes. This means less availability impact during the backup and recovery process.
These features allow you to back up and recover a database in almost any situation. Many of these new features address problems or difficulties that you will encounter in your daily tasks. Other features such as flash recovery, block change tracking, and actual backup compression are innovations within RMAN that allow a DBA to support evolving database requirements. These components enable you to automate and standardize the backup and recovery process.
This process spawns off-server sessions that connect to the target database, which is the database that will be backed up. The EM tool is a web- based application and must be run through a browser. Recovery catalog The recovery catalog is recovery information that is stored inside an Oracle database.
This is similar to the RMAN repository stored in the control file, but information stored in the recovery catalog is more extensive. It is a special data dictionary of backup infor- mation that is stored in a set of tables, much like the data dictionary stores information about databases. The recovery catalog provides a method for storing information about backups, restores, and recoveries.
This information can provide status on the success or failure of back- ups, operating system backups, datafile copies, tablespace copies, control file copies, archive log copies, full database backups, and the physical structures of a database. These commands can be organized logically into scripts, which can then be stored in the recovery catalog database. The scripts can be reused for other backups, thus keeping consistency among different target database backups. Tape media connectivity Tape media connectivity provides a method for interfacing with various third-party tape hardware vendors to store and track backups in automated tape libraries ATLs.
Oracle supports many tape hardware devices. ATLs are tape units that use robotics arms and bar-coded tapes to automate the usage of multiple tapes for backup purposes. If you are going to use RMAN, you can use disk or tape. If you are using tape, a third-party media management library is needed to interface with your tape hardware. User-managed backups are essentially customized scripts that interact with the operating system capabilities such as copy and compress commands.
These types of backups have been the mainstay of Oracle backups prior to and during the initial release of RMAN. The EXPORT utility executed with the exp executable is essentially a logical backup utility that performs backups only on the logical components of the database. A logical backup con- sists of backing up the database at the tablespace level or backing up other logical database components such as a table. A physical backup consists of backing up the database files such as the datafiles, control files, and redo logs. RMAN performs many recovery options that are not supported by other available backup and recovery methods.
Table 1. Starting the RMAN utility is a very straightforward process. To start RMAN, you need to be at the command line at the operating system level. In the case of a Windows environment, you would be at the DOS prompt. Server parameter file backups Supported Supported Not supported. Password file backups Not supported Supported Not supported.
Closed database backups Supported Supported Not supported. Open database backups Supported Not supported Not supported. Incremental backups Supported Not supported Not supported. Oracle calls the collection of metadata about the target databases the RMAN repos- itory.
Add to Wishlist. OCP: Oracle Database 11g…. OCP Oracle Certified….