Large Pool
Redo Log Buffer
Database Buffer Cache
Program Global Area (PGA)
第1题:
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
第2题:
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()
第3题:
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
第4题:
Identify the memory component from which memory may be allocated for: () 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations
第5题:
Identify the memory component from which memory may be allocated for:() 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager (RMAN) backup and restore operations
第6题:
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager (RMAN). The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第7题:
to limit the User Global Area (UGA) memory allocated to a session from the SGA
to limit the amount of memory to be used for the dispatcher queue of a session in SGA
to limit the amount of memory to be used for the request pool in System Global Area (SGA)
to control the amount of memory allocated in SGA for the local variables for each shared server process
第8题:
Large Pool
Redo Log Buffer
Database Buffer Cache
Program Global Area (PGA)
第9题:
Large Pool
Redo Log Buffer
Database Buffer Cache
Program Global Area (PGA)
第10题:
streams pool
shared pool
log buffer
keep buffer cache
recycle buffer cache
第11题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第12题:
Large Pool
Redo Log Buffer
Database Buffer Cache
Program Global Area (PGA)
第13题:
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
第14题:
You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()
第15题:
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
第16题:
You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第17题:
Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()
第18题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第19题:
SMON would automatically restore the lost file.
You would need to restore the whole database from the last backup.
You would need to restore the file from the last full database backup.
You would need to use flashback technology to restore the lost redo log member.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
You would need to restore the missing log file by copying one of the remaining files from the same group.
第20题:
Writes buffers to disk
Writes current redo log number to datafile headers
Writes redo log information to disk
Reads information into memory for users
第21题:
The tape I/O performed is asynchronous
The tape buffer is allocated from the System Global Area (SGA)
The tape buffer is allocated from the Program Global Area (PGA)
Oracle I/O uses an interrupt mechanism to determine when each I/O completes
第22题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第23题:
recycle buffer cache
large pool
streams pool
keep buffer cache
redo log buffer
第24题:
Allocates memory for RMAN backup and restore operations
Allocates memory for shared and private SQL areas
Contains a cursor area for storing runtime information about cursors
Contains stack space
Contains a hash area performing hash joins of tables