161、
161.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.) A. Reregistering the target database in recovery catalog B. Transporting the new tablespaces to the recovery catalog database C. Syncronizing the recovery catalog with the target database control file D. Performing a fresh backup of the target database to include the new data files in the catalog database
162、
162.View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities: SQL> SELECT substr(component, 0, 10) COMP, current_size CS,user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0; What do you infer from this?
A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed. B. The database instance is running with manual shared memory management. C. The database instance is running with manual PGA management. D. The database instance has the MEMORY_TARGET value set to a nonzero value.
163、View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented? A. setting the PRE_PAGE_SGA parameter to TRUE B. locking the SGA in memory C. increasing the value of SGA_MAX_SIZE D. automatic memory management
164、View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?
A. The incident has been newly created and is in the process of collecting diagnostic information. B. The incident is now in the Done state and the ADR can select the incident to be purged. C. The DBA is working on the incident and prefers that the incident be kept in the ADR. D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.
165、View the Exhibit exhibit1.
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US." View the Exhibit exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity? A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table. B. Set the STATISTICS_LEVEL parameter to TYPICAL. C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns. D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
