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 automatic PGA memory management in your database. Which setting is required to achieve this?()

  • A、Set MEMORY_TARGET to zero
  • B、Set the STATISTICS_LEVEL parameter to BASIC
  • C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
  • D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

相关考题:

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 use the automatic management of backup and recovery operations features for your database.Which configuration must you set?() A. Enable the flash recovery area and specify it as the archived redo log destination.B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C.Enable the flash recovery area but do not specify it as the archived redo log destination.D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

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 working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

You want the size of the tablespace to increase when it is full. Which option would you use?()A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace

You have a domain controller that runs Windows Server 2008 and is configured as a DNS server. You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console()A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.

You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet.  You have enabled Internet connection sharing. You do not want to initiate this connection automatically when a request for Internet reaches your computer. What should you do? ()A、You should uncheck “Enable on demand dialingB、Enable on-demand dialingC、Enable sharing a modem on one computer on the networkD、Configure a DHCP ServerE、Disable Internet Connection Sharing

You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS  server.     You need to record all inbound DNS queries to the server.     What should you configure in the DNS Manager console()A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.

You want to enhance the security within the LAN and prevent VLAN hopping.  What two steps can be taken to help prevent this?()A、Enable BPD guardB、Disable CDP on ports where it is not necessaryC、Place unused ports in a common unrouted VLAND、Prevent automatic trunk configurationE、Implement port security

For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()  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 of the following would you use to enable automatic media recovery for a database?()A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.

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 have a domain controller that runs Windows Server 2008 and is configured as a DNS server You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console()A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursrve queries.D、Configure event logging to log errors and warnings.

You need to design a strategy to increase security for the client computers in the finance department. Which two actions should you perform?()A、Enable automatic certificate enrollmentB、Enforce smart card logonsC、Enable Encrypting File System (EFS) for offline filesD、Enable a screen saver password

You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS server.  You need to record all inbound DNS queries to the server.  What should you configure in the DNS Manager console()A、Enable debug logging.B、Enable automatic testing for simple queries.  The safer , easier way to help you pass any IT exams.  9 / 90C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.

You have a single Active Directory directory service domain. You plan to use a server named Server1  to deliver Microsoft updates to all your companys workstations. The workstations are located in an  organizational unit (OU) named Workstations. Server1 is located in an OU named Servers. You need to  ensure that all workstations receive Microsoft updates from Server1 and that the updates are installed at  3:00 AM each day.  What should you do?()A、 Create a GPO and enable the Configure Automatic Updates and Enable recommended updates via automatic Updates options. Link the GPO to the Workstations OU.B、 Create a GPO and enable the Configure Automatic Updates and Automatic Updates detection frequency options. Link the GPO to the Workstations OU.C、 Create a GPO and enable the Configure Automatic Updates and Specify intranet Microsoft update service location options. Link the GPO to the domain.D、 Create a GPO enable the Configure Automatic Updates and Specify intranet Microsoft update service location options. Link the GPO to the Servers OU.

单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination. D Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

单选题Which of the following would you use to enable automatic media recovery for a database?()ASET AUTORECOVERY ONBSET RECOVERY ONCSET AUTO ONDYou cannot enable automatic media recovery.

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

单选题Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()A modify the HASH_AREA_SIZE initialization parameterB modify the PGA_AGGREGATE_TARGET initialization parameterC modify the WORK_AREASIZE_POLICY initialization parameterD increase the value of the SGA_TARGET initialization parameterE increase the value of the SGA_MAX_SIZE initialization parameterF increase the value of the SORT_AREA_SIZE initialization parameter

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

单选题Your database is running in the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()Amodify the HASH_AREA_SIZE initialization parameterBmodify the PGA_AGGREGATE_TARGET initialization parameterCmodify the WORK_AREASIZE_POLICY initialization parameterDincrease the value of the SGA_TARGET initialization parameterEincrease the value of the SGA_MAX_SIZE initialization parameterFincrease the value of the SORT_AREA_SIZE initialization parameter

单选题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 have a single Active Directory directory service domain. You plan to use a server named Server1  to deliver Microsoft updates to all your companys workstations. The workstations are located in an  organizational unit (OU) named Workstations. Server1 is located in an OU named Servers. You need to  ensure that all workstations receive Microsoft updates from Server1 and that the updates are installed at  3:00 AM each day.  What should you do?()A Create a GPO and enable the Configure Automatic Updates and Enable recommended updates via automatic Updates options. Link the GPO to the Workstations OU.B Create a GPO and enable the Configure Automatic Updates and Automatic Updates detection frequency options. Link the GPO to the Workstations OU.C Create a GPO and enable the Configure Automatic Updates and Specify intranet Microsoft update service location options. Link the GPO to the domain.D Create a GPO enable the Configure Automatic Updates and Specify intranet Microsoft update service location options. Link the GPO to the Servers OU.

单选题When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?()A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above