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_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 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.

Examine this statement:SELECT student_id, gpaFROM student_gradesWHERE gpa value;You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?()A.An error is returned.B.You are prompted to enter a new value.C.A report is produced that matches the first report produced.D.You are asked whether you want a new value or if you want to run the report based on the previous value.

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

If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?()  A、 The command fails unless you specify the FORCE option.B、 The command fails unless you specify the REUSE option.C、 The command must be reissued with a more specific discovery string.D、 The other disks, already part of the disk group,are ignored.

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

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

ou work as a network administrator at ABC.com.The ABC.com network consists of a single domain named ABC.com.The ABC.com network has a Windows Server 2012 R2 server named ABC_SR07 that runs the Hyper-V server role.You are to create a virtual machine named ABC_VT01 on ABC_SR07.You need to ensure that any snapshot of ABC_VT01 uses as little disk space as possible. How would you configure ABC_VT01 to meet this objective?()A、You should make use of a dynamically expanding virtual hard disk (VHD).B、You should make use of a fixed virtual hard disk (VHD).C、You should specify a small Maximum RAM value.D、You should specify a small Minimum RAM value.E、You should make use of a virtual NUMA topology.F、You should enable disk compression.

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You add a property named ServiceContext to a control. You need the value of ServiceContext to flow to the child controls exactly like the value of the DataContext property of the FrameworkElement class. What should you do? ()A、Inherit the control class from the DependencyObject class.B、Register a dependency property.In the options settings of the property metadata, specify the Inherits option.C、Declare a new property. In the get and set methods of the new property, create an instance of the TraversalRequest class.D、Declare a new property. In the get method of the new property call VisualTreeHelper.GetParent. In the set method of the new property, call VisualTreeHelper.GetChild.

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.

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

单选题If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?()A The command fails unless you specify the FORCE option.B The command fails unless you specify the REUSE option.C The command must be reissued with a more specific discovery string.D The other disks, already part of the disk group,are ignored.

单选题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. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.  Which configuration couldhave enabled the block selection of 16 KB()A Choosing the extent allocation type to uniformB Choosing the Segment Space Management option to manualC Setting autoextension on for the data file mentioned for the tablespaceD Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

单选题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

单选题You install a standalone root certification authority (CA) on a server named Server1. You need to ensure that every computer in the forest has a copy of the root CA certificate installed in the  local computers Trusted Root Certification Authorities store.   Which command should you run on Server1()Acertreq.exe and specify the -accept parameterBcertreq.exe and specify the -retrieve parameterCcertutil.exe and specify the -dspublish parameterDcertutil.exe and specify the -importcert parameter

单选题You have a computer that runs Windows 7. You run Runas and specify the /savecred parameter to start anapplication. You need to delete the stored password. What should you do?()ARun Del and specify the /p parameter.BRun Runas and specify the /noprofile parameter.CFrom Credential Manager, modify the Windows credentials.DFrom Authorization Manager, modify the Authorization Manager options.