网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）
A
DB_CACHE_SIZE
B
SHARED_POOL_SIZE
C
LARGE_POOL_SIZE
D
JAVA_POOL_SIZE
E
SGA_MAX_SIZE
F
SORT_AREA_SIZE
参考答案
参考解析
解析：
暂无解析
更多 “多选题Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE” 相关考题
考题
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?（）A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）A、the location used for control filesB、the location used for redo log filesC、the location set by using $ORACLE_BASED、the location set by using $ORACLE_HOMEE、the location set by using CORE_DUMP_DESTF、the location set by using BACKGROUND_DUMP_DEST
考题
Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
考题
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A、Online B、Pending online C、Offline D、Stale
考题
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？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
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.
考题
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A、Shared pool B、Control file C、SGA D、PGA
考题
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script
考题
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set A、 then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，B、 then it is set to $ORACLE_HOMEC、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
考题
You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）A、 The location used for control files.B、 The location used for redo log files.C、 The location set by using $ORACLE_BASED、 The location set by using $ORACLE_HOMEE、 The location set by using CORE_DUMP_DESTF、 The location set by using BACKGROUND_DUMP_DEST
考题
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
考题
You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）A、SQL scriptB、PL/SQL scriptC、Operating System （OS） scriptD、Enterprise Manager （EM） scriptE、Recovery Manager （RMAN） script
考题
When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（） "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamA、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE
考题
You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）A、 space allocated in the tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter
考题
You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.
考题
When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found. Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）A、NLS_LANGB、ORACLE_SIDC、ORACLE_HOMED、ORACLE_BASEE、LD_LIBRARY_PATH
考题
多选题Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（）AGenerate reports on data failure such as data file failures.BYou can track the Service Request （SR） and implement repairs.CYou can package and upload diagnostic data to Oracle Support.DYou can manually run health checks to gather diagnostic data for a problem.
考题
多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement： SQL SELECT name， value， isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’； The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply？（）AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
考题
单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）A
space allocated in the tablespaceB
space required for the bitmap index on a column of the tableC
space remaining in the tablespace after creating the tableD
estimated value of the PCTFREE storage parameter
考题
单选题You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）A
The location used for control files.B
The location used for redo log files.C
The location set by using $ORACLE_BASED
The location set by using $ORACLE_HOMEE
The location set by using CORE_DUMP_DESTF
The location set by using BACKGROUND_DUMP_DEST
考题
多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE
考题
多选题You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）AModifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.BModifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.CIncreasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.DDecreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.EIncreasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.FDecreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.
考题
单选题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 of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（） The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t setA
then the default is set to $ORACLE_BASE The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，B
then it is set to $ORACLE_HOMEC
DIAGNOSTIC_DEST is always equal to $ORACLE_HOMED
DIAGNOSTIC_DEST is always equal to $ORACLE_BASE
考题
多选题When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found. Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）ANLS_LANGBORACLE_SIDCORACLE_HOMEDORACLE_BASEELD_LIBRARY_PATH
考题
多选题You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE
考题
单选题You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A
It is a SQL script.B
It is a PL/SQL file.C
It is an operating system （OS） file.D
It is a Recovery Manager （RMAN） script
热门标签
最新试卷