You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）A、 A maximum of 3 GB can be allocated to shared poolB、 The value for SGA_TARGET can be increased up to a maximum of 15 GBC、 A total of 14 GB memory will be allocated to the automatically tuned memory components.D、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZEE、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parametersF、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）
- A、 A maximum of 3 GB can be allocated to shared pool
- B、 The value for SGA_TARGET can be increased up to a maximum of 15 GB
- C、 A total of 14 GB memory will be allocated to the automatically tuned memory components.
- D、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
- E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
- F、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
相关考题：
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?() A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.) A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
A senior DBA asked you to execute the following command to improve performance:SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?（）A. The keep pool is not configured.B. Automatic Workarea Management is not configured.C. Automatic Shared Memory Management is not enabled.D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database.C. Create a Flashback Data Archive in the tablespace where the tables are stored.D. Create a Flashback Data Archive in any suitable tablespace.E. Enable Flashback Data Archiving for the tables that require tracking
You are using AutoQoS Enterprise and realize that the results are not what you expected. Whichof the following are possible reasons for AutoQoS not functioning correctly？（Choose all thatapply.）（）A、The interface you configured for AutoQoS is set to half-duplexB、AutoQoS was configured on only one end of the linkC、The interface you configured for AutoQoS has no IP addressD、The interface’s bandwidth is not correctly configuredE、CEF is not enabled on the interfaceF、You enabled AutoQoS on the interface but forgot to enable globally first
Which two statements are true about the relationship between static NAT and proxy ARP? （）(Choose two.)A、It is necessary to forward ARP requests to remote hosts.B、It is necessary when translated traffic belongs to the same subnet as the ingress interface.C、It is not automatic and you must configure it.D、It is enabled by default and you do not need to configure it.
our company has 1，000 client computers that run Windows 7 Enterprise. You need to ensure that users cannot bypass or disable Internet Explorer logging. What should you do？（）A、 Set the Turn off InPrivate Filtering state to Enabled， and set the Disable the General Page state to Enabled.B、 Set the Turn off InPrivate Browsing state to Enabled， and set the Disable the General Page state to Enabled.C、 Set the Disable the Advanced Page state to Enabled， and set the Turn off InPrivate Browsing state to Enabled.D、 Set the Disable the General Page state to Enabled， and set the Disable the Advanced Page state to Enabled.
You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）A、 The database must be in the ARCHIVELOG mode.B、 The automatic memory tuning must be enabled.C、 The change tracking feature must be enabled.D、 The automatic memory tuning must be disabled.
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、Undo retention guarantee must be enabled.C、Database must be running in archivelog mode.D、Automatic undo management must be enabled.E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）A、The keep pool is not configured.B、Automatic Workarea Management is not configured.C、Automatic Shared Memory Management is not enabled.D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
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.
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
You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（） A、Memory AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
Which two are the prerequisites to enable Flashback Data Archive？（）A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
You are a security administrator for your company. The network consists of a single Active Directory domain. All servers run Windows 2003 Server. All client computers run Windows XP Professional. All computers are configured to use Automatic Updates to install updates without user intervention. Updates are scheduled to occur during o peak hours. During a security audit，you notice some client computers are not receiving updates on a regular basis. You verify that Automatic Updates is running on All client computers， and you verify that users cannot modify the Automatic Updates settings. You need to ensure that computers on your network receive all updates. What should you do？（）A、 Enable the No auto-restart for scheduled Automatic Updates installations setting.B、 Disable the Specify intranet Microsoft update service location setting.C、 Enable the Remove access to use all Windows Update features setting.D、 Enable the Reschedule Automatic Updates scheduled installations setting.
单选题You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）A The database must be in the ARCHIVELOG mode.B The automatic memory tuning must be enabled.C The change tracking feature must be enabled.D The automatic memory tuning must be disabled.
单选题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.
多选题Which two are the prerequisites to enable Flashback Data Archive？（）ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
单选题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 two statements are true about the relationship between static NAT and proxy ARP? （）(Choose two.)AIt is necessary to forward ARP requests to remote hosts.BIt is necessary when translated traffic belongs to the same subnet as the ingress interface.CIt is not automatic and you must configure it.DIt is enabled by default and you do not need to configure it.
单选题You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the databaseCCreate Flashback Data Archive in the tablespace where the tables are stored.DCreate Flashback Data Archive and enable Flashback Data Archive for specific tables
单选题You install a new CD-ROM on your computer. After installing the appropriate drivers and restarting the computer you notice that it is not working correctly. You check resources and find out that it is not using “Automatic resource settings”. How do you get your CDROM to work? （）ACheck ‘Use Automatic Settings’BUpdate the drivesCUse the windows troubleshooterDManually set the interrupt，I/O port， and memory address to that of the hardware manufacturers specifications.
单选题our company has 1，000 client computers that run Windows 7 Enterprise. You need to ensure that users cannot bypass or disable Internet Explorer logging. What should you do？（）A Set the Turn off InPrivate Filtering state to Enabled， and set the Disable the General Page state to Enabled.B Set the Turn off InPrivate Browsing state to Enabled， and set the Disable the General Page state to Enabled.C Set the Disable the Advanced Page state to Enabled， and set the Turn off InPrivate Browsing state to Enabled.D Set the Disable the General Page state to Enabled， and set the Disable the Advanced Page state to Enabled.
单选题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
单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository （AWR）E Automatic Database Diagnostic Monitor （ADDM）
单选题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