网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?()
A.120MB.320MC.480MD.600M
考题
View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()
A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB
考题
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.
考题
In which situation is 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
考题
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance
考题
Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A、increase the undo retentionB、create more undo segmentsC、create another undo tablespaceD、increase the size of the undo tablespace
考题
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
考题
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
考题
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.
考题
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）A、120MB、320MC、480MD、600M
考题
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.
考题
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
考题
You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to 900 or more.B、Create an initial undo segment in the undo tablespace.C、Enable the retention guarantee for the undo tablespace.D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.
考题
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）A、The extents in the undo tablespace retain data until the next full database backup.B、The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.C、The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
考题
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： RMANBACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）A、 The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1B、 The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C、 The SBT channel must be configured， with the parallelism setting for the SBT device set to 3D、 The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
考题
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A
increase the undo retentionB
create more undo segmentsC
create another undo tablespaceD
increase the size of the undo tablespace
考题
单选题Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）A
The extents in the undo tablespace retain data until the next full database backup.B
The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.C
The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.D
The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
考题
单选题You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A
Increase the undo returnB
Create more undo segmentsC
Create another undotablespaceD
Increase the size of the undo tablespace
考题
单选题Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）A
120MB
320MC
480MD
600M
考题
单选题In which situation is 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
考题
单选题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： RMANBACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）A
The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1B
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C
The SBT channel must be configured， with the parallelism setting for the SBT device set to 3D
The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
单选题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
考题
单选题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
考题
多选题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
热门标签
最新试卷
