多项选择题
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
相关考题
-
多项选择题
Inwhichscenarioswouldyourebuildanindex？（）
A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace -
单项选择题
YousettherecoverywindowtosevendaysandthebackupoptimizationtoONusingtheCONFIGUREcommandofRecoveryManager（RMAN）.ThemostrecentbackupoftheTOOLStablespacetodiskwastakenonJanuary3.TheTOOLStablespaceisread-only.OnFebruary21，whenyouexecuteacommandtobackupallthetablespacestodisk，youfindthatRMANbacksupthe TOOLS tablespacealso，eventhoughthecontentsofthetablespacehavenotchangedafterthebackuponJanuary3.BecausetherearenochangesmadetotheTOOLStablespace，youdecidethatthetablespaceshouldnotbebackedupbyRMAN.WhatcanyoudotoskipbackinguptheTOOLStablespacewithoutchangingthecurrentbackupoptimizationsetting？（）
A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days -
单项选择题
YouaredesigninganapplicationforCertkiller.comandyouhavebeenaskedtodesignadatabasetabletofacilitatemonthlybillgeneration.Thebillwouldincludedetailsofcustomercalls，listedinchronologicalorder.Whichmethodwouldyoufollowtoachievethisobjectivewithoutincreasingtheoverheadofsortingtherows？（）
A. create a hash cluster to store the data
B. create an index cluster to store the data
C. create a partitioned table to store the data
D. create a sorted hash cluster to store the data
E. create a heap table with rowid to store the data
