网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）
A
recycle buffer cache
B
large pool
C
streams pool
D
keep buffer cache
E
redo log buffer
参考答案
参考解析
解析：
暂无解析
更多 “单选题You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A recycle buffer cacheB large poolC streams poolD keep buffer cacheE redo log buffer” 相关考题
考题
单选题Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1; 3 ALTER DATABASE MOUNT; 4 RESTORE DATABASE; 5 RECOVER DATABASE; 6 ALTER DATABASE OPEN RESETLOGS; 7 }; With reference to this scenario， which statement is true？（）A
RMAN recovers up to log sequence 230， but not including 230.B
RMAN returns an error because the log sequence number mentioned in the command should be 229.C
RMAN returns an error because the log sequence number mentioned in the command may never be missing.D
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
单选题The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A
The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B
DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C
The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D
The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E
The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent
考题
多选题You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）Abackup piecesBcontrol file autobackupsCcopies of all the parameter filesDtrace file generated using BACKUP CONTROLFILE TO TRACE
考题
单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_CREATE_FILE_DEST
考题
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）A
Oracle Enterprise ManagerB
The V$LOG viewC
The V$LOGFILE viewD
The V$FLASHBACK_DATABASE_LOGS view
考题
单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）A
DBMS_SERVER_ALERTB
DBMS_ADVISORC
DBMS_RESOURCE_MANAGERD
DBMS_REPAIR
考题
单选题The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE MAXSETSIZE 10MB； What will be the impact of the above setting？（）A
While performing the backup of the datafile，data1.dbf，one backup set is created.B
While performing the backup of the datafile，data1.dbf，two backup sets are created.C
While performing the backup of the datafile，data1.dbf，three backup sets are created.D
While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
考题
单选题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）A
V$SYSSTATB
V$SESSSTATC
V$RSRC_PLAND
V$RSRC_CONSUMER_GROUP
考题
单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace： RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M； Which statement is true about executing this command？（）A
The command generates an error.B
The command backs up the tablespace and creates a backup set of size 200 MBC
The command backs up the tablespace and creates two backup sets of size 100 MB each.D
The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
考题
单选题Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A
modify the HASH_AREA_SIZE initialization parameterB
modify the PGA_AGGREGATE_TARGET initialization parameterC
modify the WORK_AREASIZE_POLICY initialization parameterD
increase the value of the SGA_TARGET initialization parameterE
increase the value of the SGA_MAX_SIZE initialization parameterF
increase the value of the SORT_AREA_SIZE initialization parameter
热门标签
最新试卷