多项选择题
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?()
单项选择题 YousettherecoverywindowtosevendaysandthebackupoptimizationtoONusingtheCONFIGUREcommandofRecoveryManager(RMAN).ThemostrecentbackupoftheTOOLStablespacetodiskwastakenonJanuary3.TheTOOLStablespaceisread-only.OnFebruary21,whenyouexecuteacommandtobackupallthetablespacestodisk,youfindthatRMANbacksupthe TOOLS tablespacealso,eventhoughthecontentsofthetablespacehavenotchangedafterthebackuponJanuary3.BecausetherearenochangesmadetotheTOOLStablespace,youdecidethatthetablespaceshouldnotbebackedupbyRMAN.WhatcanyoudotoskipbackinguptheTOOLStablespacewithoutchangingthecurrentbackupoptimizationsetting?()
单项选择题 YouaredesigninganapplicationforCertkiller.comandyouhavebeenaskedtodesignadatabasetabletofacilitatemonthlybillgeneration.Thebillwouldincludedetailsofcustomercalls,listedinchronologicalorder.Whichmethodwouldyoufollowtoachievethisobjectivewithoutincreasingtheoverheadofsortingtherows?()