ITPub博客

279.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.) A. generating the SQL profile.B. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into t...

275.You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value. Which three statements about resumable space allocation are true? (Choose three.)A. Even with resumable space allocation enabled for your database, you can disab...

273.Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default wit...

272.You issue the following RMAN command to set a retention policy on a database:RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;What will be the outcome of issuing this command?A. After two days, a backup will be marked obsoleteB. After two days, a backup will be deleted from the mediaC. If th...

270.Which tasks are run automatically as part of the Automated Maintenance Task by default?(Choose all that apply.)A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics MonitorAnswer: ACD 默认情况下，...

263.Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink? A. The database must be running in ARCHIVELOG mode.B. No special setup is required, and the feature is enable...

261.In which cases is reference partitioning effective in enhancing performance? A. It is effective only in partition pruning.B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C. It is effective in both partition prun...

200.Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)A. Backup-based database duplication.B. Active database duplication.C. Tablespace point-in-time recovery.D. No operation requires the creation of an auxiliary insta...

197.Which of the following commands will fail?A. report schema;B. report need backup;C. report need backup days 3;D. report user;E. report obsolete;Answer: D参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#CHDDBJHCRMAN> report schema;使用目标数据库控制文件替代...

196.What is the purpose of the catalog command?A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN backup-related metadata from the recovery catalogC. To create metadata in the control file and the recovery catalog related to backup set pieces...

192.What is the purpose of the until change option of the restore command?A. It allows you to select the SCN that you want to restore to.B. It allows you to select the log sequence number you want to restore to.C. It allows you to select the timestamp you want to restore to.D. It allows you to m...

186.What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. Make backups fasterB. Store RMAN metadataC. Store RMAN scriptsD. Provide the ability to do centralized backup reporting.E. Make recovery fasterAnswer: BCD恢复目录：? 复制控制文件数据? 存储更长的备份...

175.You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:1、Put the tablespaces in backup mode.2、Back up the datafiles for all tablespaces.3、Take the tablespaces out of backup mode.4、Back up all archived redo logs.Your colleague asks for you to c...

169.Exhibit1：Exhibit2：View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine the output of the query. Which two statements describe the conclusions? (Choose two.) A. RESOURCE_PERCENTAGE should be increased. B. The repeat time for the windo...

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 ...

148.Which dependent object will get invalidated even if it is not affected by the table definition?A. packagesB. triggersC. synonymsD. viewsAnswer: B哪个依赖对象会无效，即使它不会受到表定义的影响？B、触发器

144.In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BY sale_category;Where would the result of this query be stored?A. datab...

142.In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?(Choose all that apply.) A. when one or more file directory paths are accidentally deleted from an ASM disk groupB. when one of the disks in a disk group is acTMcidentaly unpluggedC. when th...

140.Which two statements are true regarding Health Monitor checks in Oracle Database 11g?(Choose two.)A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.B. Health Monitor checks can be used to verify the integrity of database...

139.Which two prerequisites are needed for performing workload capture and replay? (Choose two.)A. Close all sessions performing queries using database links.B. running the database in shared server modeC. The database on which the workload is replayed has to be a restore of the original database...