单选题View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.A1 MB B6 MB C10 MB D15 MB E11 MB

题目内容(请给出正确答案)

单选题

View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.

1 MB

6 MB

10 MB

15 MB

11 MB

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup， you issued the following RMAN command： RMAN>BACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）AThe SBT channel must be configured， with the default parallelism setting for the SBT device set to 1BThe COMPATIBLE initialization parameter for the database instance must be set to at least 10.0CThe SBT channel must be configured， with the parallelism setting for the SBT device set to 3DThe SBT channel must be configured， with the MAXPIECESIZE set to 300 MB

点击查看答案
第2题

单选题Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database？（）A The extents in undo tablespace retain data until the next full database backup.B The extents containing committed data in the undo tablespace are never overwritten.C The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.D The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.

点击查看答案
第3题

单选题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？（）AThe command generates an error.BThe command backs up the tablespace and creates a backup set of size 200 MBCThe command backs up the tablespace and creates two backup sets of size 100 MB each.DThe command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

点击查看答案
第4题

单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A when the data file of the undo tablespace is autoextensibleB when there are more than one undo tablespaces available in the databaseC when the undo tablespace is of a fixed size and retention guarantee is not enabledD when the undo tablespace is autoextensible and retention guarantee is not enabled

点击查看答案
第5题

单选题Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A The minimum memory size for the database buffer cache is set to 100 mb.B The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

点击查看答案
第6题

单选题You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）A The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

点击查看答案
第7题

多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe value of the UNDO_RETENTION parameter

点击查看答案

单选题View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.A 1 MB B 6 MB C 10 MB D 15 MB E 11 MB

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容