单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
单选题
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
A
The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
B
The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
C
The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
D
The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
参考解析
解析：
暂无解析
相关考题：
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）A The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D If you restart the database，the database will not be opened.
单选题Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.Aa， c， f， gBb， c， f， hCa， b， c， f， gDa， b， c， f， g， hEb， c， f， e， g
单选题View the following SQL statements： Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT； Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT； Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5； You want to back out transaction T2. Which option would you use？（）A It is possible，but transaction T3 also backs out.B It is possible with the NOCASCADE_FORCE option.C It is possible with the NONCONFLICT_ONLY option.D It is not possible because it has conflicts with transaction T3.
多选题Examine the section of the Health Check report given below： DBMS_HM.GET_RUN_REPORT（’HM_RUN_1061’） Run Name ： HM_RUN_1061 Run Id ： 1061 Check Name ： Data Block Integrity Check Mode ： REACTIVE Status ： COMPLETED Start Time ： 2007-05-12 22：11：02.032292 -07：00 End Time ： 2007-05-12 22：11：20.835135 -07：00 Error Encountered ： 0 Source Incident Id ： 7418 Number of Incidents Created ：0 Which two statements are true regarding the Health Check report？（）AHealth Check was performed manually.BHealth Check was performed to check the disk image block corruptions.CHealth Check was performed to check interblock and intersegment corruption.DHealth Check was performed to verify the integrity of database files and report failures.EHealth Check was performed by the Health Monitor automatically in response to a critical error.
多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
多选题Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN ？（）ALimiting the input/output （I/O） bandwidth consumptionBSpecifying the size of backup sets and backup piecesCSpecifying vendor-specific information for a media managerDSpecifying the parallelism for backup and restore operations
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor
单选题What type of backup is stored in a proprietary RMAN format？（）A Backup setB Image copyC Backup sectionD Backup group
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）AALTER DATABASE DROP LOGFILE GROUP 1;BALTER DATABASE CLEAR LOGFILE GROUP 1;CALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;DALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG