更多"You want to use the automatic manag"的相关试题:
[单项选择]You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
A. Enable the flash recovery area and specify it as the archived redo log destination.
B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C. Enable the flash recovery area but do not specify it as the archived redo log destination.
D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
[单项选择]You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?()
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
[单项选择]If you want to use your Business Telecard International, you have to
A. use a card phone
B. phone on Sunday
C. make a direct dialing call
D. pay extra
[单项选择]You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?()
A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
[单项选择]If you want to use Windows 2000, but your computer only has 64 MB, what will you have to do
A. Enlarge its RAM to at least 256 MB.
B. Put in good software in your computer.
C. Enlarge its RAM to at least 128 MB.
D. Have Windows NT to match it.
[单项选择] To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()
A. The PGA_AGGREGATE_TARGET parameter is set to zero.
B. The STATISTICS_LEVEL parameter is setto basic.
C. Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
D. The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
[多项选择]You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
[多项选择] You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)
A. The backup piece size will be limited to 300 MB
B. The RMAN uses multiplexing to perform backup
C. The operation is accomplished using the default channel available
D. The RMAN parallelizes the backup although the parallelism is not set for a channel
[多项选择]You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).
A. The backup as copy can only be taken to disk
B. The backup as copy can only be taken to tape
C. Backup can be performed only when the instance is shutdown
D. Backup will constitute all used and unused blocks in the database
[单项选择]The farmers also want to use the water to irrigate the {{U}}barren{{/U}} land.
A. empty
B. hairless
C. smooth
D. bare
[单项选择]You can do what you like, but I do not want you to be_________.
A. on the way
B. along the way
C. by the way
D. in the way
[单项选择]Which statement about Automatic Memory Management with Oracle 11g is true?()
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
[单项选择]Which substitution variable would you use if you want to reuse the variable without prompting the user each time?()
A. &
B. ACCEPT
C. PROMPT
D. &&