QUESTION NO:668
Examine the output ofthe query that you executed to list the objects in the recycle bin:
You verified that notable named SALES_TAB exists in the schema. Then you executed the followingcommand to purge the objects inthe recycle bin:
SQL> PURGE TABLE sales_tab;
What would be theoutcome of this command?
A. All three tables in the recycle bin are purged
B. Only the table with the oldestDROPSCN is purged
C. The command returns an error because multiple entrieswith the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
QUESTION NO:669
View the Exhibit andexamine the resourceconsumption details for the current plan in use by the database instance.
Which two statements aretrue based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belongingto DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES canlog in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicatesthe total time that sessions in the consumer group waited for the CPU due toresource management
D. The CPU_WAIT_TIME column indicates the total time thatsessions in the consumer group
waited for the CPU dueto resource management, I/O waits, and latch or enqueue contention
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dbrm009.htm
V$RSRC_CONSUMER_GROUP
Use theV$RSRC_CONSUMER_GROUP view to monitor CPU usage and CPU waits. It provides
the cumulative amount ofCPU time consumed, cumulative amount of time waiting for CPU, and
cumulative number of CPUwaits by all sessions in each consumer group. It also provides a
number of other measureshelpful for tuning.
SQL> SELECT name,active_sessions, queue_length,
consumed_cpu_time,cpu_waits, cpu_wait_time
FROMv$rsrc_consumer_group;
QUESTION NO:670
Because of a logicalcorruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But beforeyou start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized thatthere are a large number of objects that would be dropped when you startthe recovery by using this method.
You want to preservethese objects. Which option must you use to perform TSPITR and preserve the object?
A. Perform Export before TSPITR andImport after TSPITR
B. Move objects to another schema that has the sametablespace assigned
C. Perform Incomplete Recovery before TSPITR with the LogSequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the SystemChange Number (SCN)
Explanation:
QUESTION NO:671
You are using a recoverycatalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and areperforming regular backups. Because of a new requirement you have added a fewnew tablespaces to your production database and you want them to be included inbackups. 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 catalogdatabase
C. Syncronizing the recovery catalogwith the target database control file
D. Performing a fresh backup of thetarget database to include the new data files in the catalogdatabase
Explanation:
QUESTION NO:672
You executed thefollowing command in the Recovery Manager (RMAN):
RMAN> REPORT NEED BACKUP days 3;
What is the output ofthis command?
A. A list of files that require a backup within 3 days
B. A list of files requiring more than3 days of archivelogs to apply
C. A list of files that RMAN recommends be backed up onlyonce in every three days, based on low volatility
D. A list of files for which a backup as already beenperformed in the last three days and which is required to be backed up againbased on the high number of transactions performed on them
QUESTION NO:673
Which two statements aretrue about the duplexingof the backups taken byRMAN? (Choose two.)
A. It's only supported for the backups performed on the tape
B. It is not supported for backupoperations that produce image copies
C. Duplex backups need a parallelism for the device to beequal to number of copies
D. Duplex backups can be performed toeither disk or tape, but cannot be performed on tape and disk simultaneously
Explanation:
QUESTION NO:674
You are using RecoveryManager (RMAN) for backup and recovery operations with a recovery catalog. Youhave been taken database backups every evening. On November 15, 2007, at11:30AM, you were informed that the USER_DATA tablespace was accidentallydropped.
On investigation, you found that the tablespaceexisted until 11:00 AM, and important transactions were done after that.So you decided to performincomplete recovery until 11:00 AM. All the archive logs needed to performrecovery are intact完整无缺的. In NOMOUNT state you restored the control
file that hasinformation about the USER_DATA tablespace from the latest backup. Then you mountedthe database. Identify the next set of commands that are required to accomplishthe task?
你正在使用RMAN进行备份和恢复操作(用recoverycatalog)。你每天晚上进行数据库备份。2007.11.15,11:30上午,你消息灵通的(user_data表空间异常dropped)。
A. Option A
B. Option B
C. Option C
D. Option B
QUESTION NO:675
You create two resourceplans, one for data warehouse loading jobs at night and the other for applicationjobs at day time. You want the resource plans to activate automatically so thatthe resource allocation is optimum 最适宜的as desired渴望的 by the activity.
How would you achievethis?
A. Implement job classes
B. Implement Scheduler windows
C. Implement the mapping rule for the consumer groups
D. Set the SWITCH_TIME resource plan directive for both theresource plans
Explanation:
QUESTION NO:676
You want to schedule ajob to rebuild all indexes on the SALES table after the completion of a bulk loadoperation. The bulk load operation must also be a scheduled job that executesas soon as the first file that contains data arrives on the system.
How would you createthese jobs?
A. Create both jobs by using events raised by the scheduler
B. Create both jobs by using events raised by theapplication
C. Create a job to rebuild indexes by using events arised bythe application and then create another job to perform bulk load by usingevents raised by the scheduler
D. Create a job to rebuild indexes byusing events arised by the Scheduller and then create another job to performbulk load by using events raised by the application
Explanation:
QUESTION NO:677
View the Exhibits:Exhibit 1 and Exhibit 2
Both processes use anexisting job template PROG_1. The time taken by the jobs are recorded in theTEST_LOG table. It was observed that the job creation process in exhibit 1takes less time than in exhibit 2.
What is the reason forthis?
Exhibit:
A. It creates less metadata for jobs
B. It creates jobs temporarily in memory only
C. It writes the jobs metadata to disk in compressed format
D. It updates tables in SYSTEM tablespace instead ofcreating new tables
Explanation:
QUESTION NO:678
Which two statements aretrue regarding an Automatic Storage Management (ASM) instance? (Choose two.)关于ASM实例描述正确的两句是:
A. As ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing ofdisks within a disk group
C. Automatic Memory Management isenabled in an ASM instance even when the MEMORY_TARGET parameter is not setexplicitly即使memory_target参数没有明确的设置,自动内存管理也是启用的(在ASM实例)
D. An RDBMS instance gets connected toan ASM instance using ASMB as a foreground process when the database instanceis started RDBMS实例连接到一个ASM实例使用ASMB作为前台进程(当数据库实例启动时)
QUESTION NO:679
The DB_BLOCK_CHECKINGinitialization parameter is set to OFF.
Which block checkingwould be performed?
Db_block