TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA，basedontheamountofmemoryavailableonthesystem？（）
A. 20%SGA 80%PGA
B. 25%SGA 75%PGA
C. 50%SGA 50%PGA
D. 75%SGA 25%PGA
E. 80%SGA 20%PGA
查看答案
Whichstatementsarecorrectabouttemporarytables（）
A. Indexesandviewscanbecreatedontemporarytables.
Boththedataandthestructureoftemporarytablescanbeexported.
C. Temporarytablesarealwayscreatedinauser’stemporarytablespace.
D. Thedatainsertedintoatemporarytableinasessionisavailabletoothersessions.
E. Datamanipulationlanguage（DML）locksareneveracquiredonthedataoftemporarytables
Youhavetwolistenerprocesses，namedL1andL2.Boththelistenerprocessesarecurrentlyfunctional.Whileviewingthelistener.orafileonyourdatabaseserver，youfindthefollowingentry：PASSWORDS_L1=（1sanfrjp43）Whatwouldbetheimpactofthissetting？（）
A. ThelistenerprocessnamedL1willdisconnecttheunauthorizedusers.
B. ThelistenerprocessnamedL1willbepreventedfrombeingstartedbyunauthorizedusers.
C. ThelistenerprocessnamedL1willbepreventedfrombeingstoppedbyunauthorizedusers.
D. ThelistenerprocessnamedL1willbepreventedfrombeingreloadedbyunauthorizedusers.
E. ThelistenerprocessnamedL1willbepreventedfromacceptingconnectionsfromunauthorizedusers.
EverySundaytheUnixsystemadministratorhasajobthatexecutesafullbackupoftheentireUnixsystemyourdatabaseison.Isthisbackupusableforbackupandrecoveryofyourdatabase？（）
A. Yes，ifthedatabaseisinARCHIVELOGmode
B. Yes，ifthedatabaseisinNOARCHIVELOGmode
C. No，thebackupisnotusableinanyway
D. OnlyiftheENABLE_ONLINE_BACKUPparameterissettoTRUE
Identifythe situationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetail.（）
A. Runningaqueryonatablereturns"ORA-600：InternalError."
B. Insertingavalueinatablereturns"ORA-01722：invalidnumber."
Creatingatablereturns"ORA-00955：nameisalreadyusedbyanexistingobject."
D. Insertingavalueinatablereturns"ORA-00001：uniqueconstraint（SYS.PK_TECHP）violated."
E. Insertingarowinatablereturns"ORA-00060：deadlockdetectedwhilewaitingforresource."
微信支付 
支付宝支付