ITPub博客

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

129.You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.) A. The au_size disk group attribute de...

125.Which statement describes the significance of the CHANGE FAILURE command in RMAN?(Choose all that apply.)A. It is used to change failure priority only for HIGH or LOW priorities.B. It is used to execute the advised repair script.C. It is used to change failure priority only for the CRITICAL p...

104.You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Cho...

71.The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?A. C...

70.You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:ALTER TABLE employees SHRINK SPACE CASCADE;Which statement is correct in this scenario?A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.B. The in...

67.On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)Answer: BE参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_100...

66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?(Choose two.)A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALLAn...

65. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files? A. TEST_TBS is a small file tablespace.B. TEST...

63.Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determin...

58.Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?A. AWR baselines are always created as repeating baselines.B. AWR baselines can be created on the basis of two time values.C. AWR baselines are always created with infinite expiratio...