The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively
第1题:
Which statement is true regarding Dynamic Service Registration?()
第2题:
You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()
第3题:
What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()
第4题:
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true()
第5题:
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)
第6题:
You set the following parameters in the parameter file and restarted the database:MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted()
第7题:
An SPFILE is a binary file.
An SPFILE cannot reside on a client.
An SPFILE cannot contain static parameters.
An SPFILE can store changes persistently across instance restarts.
An SPFILE can be read by the database server, but it is not written to by the server.
An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database
第8题:
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
The database instance starts, but Automatic Memory Management is disabled
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第9题:
The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb, respectively
第10题:
The PGA_AGGREGATE_TARGET parameter is set to zero.
The STATISTICS_LEVEL parameter is setto basic.
Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
第11题:
Multiple change tracking files can be created for a database.
The change tracking file must be created after the first level 0 backup.
RMAN does not support backup and recovery of the change tracking file.
The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
第12题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第13题:
Which three statements regarding the server parameter file (SPFILE) are true()
第14题:
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?()
第15题:
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
第16题:
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?()
第17题:
Which statement about Automatic Memory Management with Oracle 11g is true?()
第18题:
Which two statements are true regarding the starting of the database instance using the following command?() SQL>STARTUP UPGRADE
第19题:
The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第20题:
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
第21题:
It can contain parameters with distinct values for each distance.
It can contain only parameters with identical values for each instance.
It must contain an IFILE parameter for each instance’s individual parameter file.
It must be located in the default location for the primary instance’s parameter file.
第22题:
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
第23题:
It enables all system triggers.
It allows only SYSDBA connections.
It ensures that all job queues remain active during the upgrade process.
It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
第24题:
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.
Oracle can reallocate memory between the SGA and PGA automatically as needed.
To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size