单选题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?()AThe database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEBThe database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGACThe database instance starts, but Automatic Memory Management is disabledDThe database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

单选题
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?()
A

The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE

B

The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

C

The database instance starts, but Automatic Memory Management is disabled

D

The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter


参考解析

解析: 暂无解析

相关考题:

Regarding the extended ping command; which of the statements below are true?(Select all valid answer choices)A.The extended ping command is supported from user EXEC mode.B.The extended ping command is available from privileged EXEC mode.C.With the extended ping command you can specify the TCP and UDP port to be pinged.D.With the extended ping command you can specify the timeout value.E.With the extended ping command you can specify the datagram size.

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?() A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?() A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement

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 statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.) A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D. MEMORY_TARGET is static and cannot be modified without shutting down the instance

View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?() A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB

Which statements about the MEMORY_TARGET initialization parameter are true?() A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance

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

To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?()A、 RESUMABLE_SPACE_TIMEB、 RESUMABLE_SPACEC、 RESUMABLE_TIMED、 RESUMABLE_TIMEOUTE、 TIME_RESUMABLE

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()  A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()  A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?()  A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

You deploy a server that runs Microsoft Exchange Server 2003 Service Pack  2. You also deploy mobile devices that run Microsoft Windows Mobile 5.0 with the Microsoft Messaging and Security Feature Pack.   You need to ensure that the Windows Mobilebased devices are as secure as possible from brute force password attacks.   What should you do?()A、Set the Microsoft ActiveSync synchronization schedule on the mobile devices to five-minute intervals.B、Enable the Wipe devices after failed attempts option and specify a valid value for the option.C、Configure the Default Domain Group Policy object to enable Password complexity.D、Configure the Default Domain Group Policy object to specify a valid value for the Account Lockout Threshold.

单选题Which statement about Automatic Memory Management with Oracle 11g is true?()AYou cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.BOracle can reallocate memory between the SGA and PGA automatically as needed.CTo use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.DYou can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

单选题To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?()A RESUMABLE_SPACE_TIMEB RESUMABLE_SPACEC RESUMABLE_TIMED RESUMABLE_TIMEOUTE TIME_RESUMABLE

单选题You are developing a Windows Communication Foundation (WCF) service that must be discoverable.You need to ensure that the ServiceHost instance supports multiple discovery versions. What should you do?()A- Specify a unique DiscoveryVersion parameter for each endpoint constructor. - Use the same value for the Address property of each endpoint.B- Use the endpoint constructor without the DiscoveryVersion parameter. - Use a unique value for the Address property of each endpoint.C- Specify a unique DiscoveryVersion parameter for each endpoint constructor. - Use a unique value for the Address property of each endpoint.D- Use the endpoint constructor without the DiscoveryVersion parameter. - Use the same value for the Address property of each endpoint.

单选题In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()A Setting a nonzero value for SGA_TARGETB Configuring Automatic Shared Memory ManagementC Configuring Automatic Memory ManagementD Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE None of the above

单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()ASet MEMORY_TARGET to zeroBSet the STATISTICS_LEVEL parameter to BASICCSet the WORKAREA_SIZE_POLICY parameter to MANUALDSet the PGA_AGGREGATE_TARGET parameter to nonzero value

多选题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.

单选题View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()AThe database instance is running with manual PGA management.BThe database instance is running with manual shared memory management.CThe database instance has the MEMORY_TARGET value set to a nonzero value.DAll sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed

多选题Which statements about the MEMORY_TARGET initialization parameter are true?()AMEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroBMEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setCMEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.DMEMORY_TARGET is static and cannot be modified without shutting down the instance

单选题In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason?()AThe STATISTICS_LEVEL initialization parameter is set to BASICBThe PGA_AGGREGATE_TARGET initialization parameter is set to zero.CThe SGA_MAX_SIZE initialization parameter is set to less than 20 GBDThe DB_CACHE_SIZE initialization parameter is set to less than 5 GBEThe SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

多选题You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?()Aissuing the ALTER SYSTEM ENABLE RESUMABLE; statementBissuing the ALTER SESSION ENABLE RESUMABLE; statementCmodifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueDissuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement

单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value

单选题By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above

单选题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 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?()AThe database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEBThe database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGACThe database instance starts, but Automatic Memory Management is disabledDThe database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above