YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager（RMAN）toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers？（）
A. backupofofflinetablespaces
B. backupofreadonlytablespaces
C. backupofsystemcriticaltablespaces
D. backupofonline，locallymanagedtablespaces
E. backupofread/writedictionarymanagedtablespaces
查看答案
Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneofyourtablespaces，youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting？（）
A. Itwouldresultinanerrorbecausethewarningthresholdcannotbemorethanthecriticalthreshold.
B. Thewarningthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthecriticalthreshold.
C. Thecriticalthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthewarningthreshold.
D. Boththresholdvaluesareusedandalertsaregeneratedwhenspaceusageexceedstherespectivethresholdvalues.
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.
微信支付 
支付宝支付