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."
WhichofthefollowinginitializationparametershavebeendeprecatedinOracle11gbecauseoftheintroductionoftheAutomaticWorkloadRepository？（）
A. BACKGROUND_DUMP_DEST
B. FOREGROUND_DUMP_DEST
CORE_DUMP_DEST
D. USER_DUMP_DEST
E. DIAGNOSTIC_DEST
F. Alloftheabove
微信支付 
支付宝支付