搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

A、 LOG_BUFFER

B、 DB_CACHE_SIZE

C、 JAVA_POOL_SIZE

D、 LARGE_POOL_SIZE

E、 SHARED_POOL_SIZE

F、 STREAMS_POOL_SIZE

查看正确答案
更多“The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）”相关的问题
第1题
[单选题] 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 Management  B、 Automatic SGA Memory Management  C、 Automatic Shared Memory Management  D、 Automatic Memory Management  E、 Manual SGA Memory Management  F、 None of the above  

点击查看答案
第2题
[] Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

A、A. Automatic PGA Memory Management  B、B. Automatic SGA Memory Management  C、C. Automatic Shared Memory Management  D、D. Automatic Memory Management  E、E. Manual SGA Memory Management  F、F. None of the above  

点击查看答案
第3题
[单选题] For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

A、 Automatic PGA Memory Management  B、 Automatic SGA Memory Management  C、 Automatic Shared Memory Management  D、 Automatic Memory Management  E、 Manual SGA Memory Management  F、 None of the above  

点击查看答案
第4题
[单选题] 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.  

点击查看答案
第5题
[单选题] The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）

A、by using the SQL access advisor  B、by using the Automatic Workload Repository report  C、by running the Automatic Database Diagnostic Monitor （ADDM）  D、by using the Automatic Workload Repository Compare Period report  E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view  

点击查看答案
第6题
[单选题] The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

A、by using the SQL access advisor  B、by using the Automatic Workload Repository report  C、by running the Automatic Database Diagnostic Monitor （ADDM）  D、by using the Automatic Workload Repository Compare Period report  E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view  

点击查看答案
第7题
[] You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（） You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g toQ

A、A. Advisor Central  B、B. Global Attributes  C、C. Resource Monitors  D、D. Memory Parameters  E、E. Database Usage Statistics  F、F. All Initialization Parameters  H、G. Automatic Workload Repository  

点击查看答案
第8题
[单选题] 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 Advisor  B、Segment Advisor  C、SQL Access Advisor  D、Automatic Workload Repository （AWR）  E、Automatic Database Diagnostic Monitor （ADDM）  

点击查看答案
第9题
[单选题] Which DHCP allocation method allows automatic reuse of an address that is no longer needed by the lient to which it was assigned？（）

A、Automatic  B、Dynamic  C、Reuse  D、Manual  

点击查看答案
第10题
[单选题] Which DHCP allocation method allows automatic reuse of an address that is no longer needed by the client to which it was assigned？（）

A、Automatic  B、Dynamic  C、Reuse  D、Manual  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服