1 MB
6 MB
10 MB
15 MB
11 MB
第1题:
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()
第2题:
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()
第3题:
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?()
第4题:
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?()
第5题:
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?()
第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; What configuration should be effected to accomplish faster and optimized backups by using the above command?()
第7题:
The extents in the undo tablespace retain data until the next full database backup.
The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
第8题:
120M
320M
480M
600M
第9题:
The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
The SBT channel must be configured, with the parallelism setting for the SBT device set to 3
The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB
第10题:
The command generates an error.
The command backs up the tablespace and creates a backup set of size 200 MB
The command backs up the tablespace and creates two backup sets of size 100 MB each.
The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
第11题:
The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
第12题:
the size of an undo block
the size of the redo log files
undo blocks generated per second
the size of the database buffer cache
the value of the UNDO_RETENTION parameter
第13题:
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?()
第14题:
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()
第15题:
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?()
第16题:
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.()
第17题:
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()
第18题:
increase the undo retention
create more undo segments
create another undo tablespace
increase the size of the undo tablespace
第19题:
Increase the undo return
Create more undo segments
Create another undotablespace
Increase the size of the undo tablespace
第20题:
When the data file of the undo tablespace is autoextensible
When there are more than one undo tablespaces available in the database
When the undo tablespace is of a fixed size and retention guarantee is not enabled
When the undo tablespace is autoextensible and retention guarantee is not enabled
第21题:
The extents in undo tablespace retain data until the next full database backup.
The extents containing committed data in the undo tablespace are never overwritten.
The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
第22题:
when the data file of the undo tablespace is autoextensible
when there are more than one undo tablespaces available in the database
when the undo tablespace is of a fixed size and retention guarantee is not enabled
when the undo tablespace is autoextensible and retention guarantee is not enabled
第23题:
The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1