You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（） -题库考试答案搜索网

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

单选题

2022-07-12 01:20

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

查看答案

正确答案

D

试题解析

标签： OCP 11G认证考试

感兴趣题目

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）

Could you give me a helping hand?（）I want to clean my garage

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

Which two initialization parameters would you set to enable Automatic Shared Memory Management?（）

—Lily, what are you going to do after you graduate?—I’m thinking of becoming a computer programmer.—_____—Well, my parents want me to be a doctor, but I don’t want to do that.

Do you want to change this lamp for__________or do you want your money back?

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

相关题目: — Would you mind helping me for a minute, Barbara?

— _________________What do you want me to do?; Why! I have nothing to confess. ____________ you want me to say?; I want to go to the dentist, but you ______ with me.; Excuse me. I don’t want to interrupt you but …; 5.Do you want to fly first or economy class? 回答; – Do you want me to hold the umbrella for you? –__________; If you had to ______ between staying here alone or going with me, what would you do?; I.ll give you my telephone number in case you ( ) want to get in touch with me again.; (单选、25分) Do you want to change this lamp for__________or do you want your money back; Ill give you my telephone number in case you ( ) want to get in touch with me again; If you wanted me to go, why didn’t you say so ________ instead of making vague hints; 3-I am leaving for Harbin tomorrowDo you want to go with me! --______; Do you want to pay cash or sign the bill？这句话意思是（）。; Mr. Baker, a dozen students want to see you. （） they wait here or outside?; Could you give me a helping hand?（）I want to clean my garage; You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）; You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）; Do you want to wait? Five days（）too long for me to wait.; Which initialization parameter must you set to enable automatic archiving？（）; — Would you mind helping me for a minute, Barbara?
— _________________What do you want me to do?

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧