A.noprofiles
B.thedefaultprofile
C.sameastheprofileofSYSuser
D.sameastheprofileofSYSTEMuser
第1题
,respectively.Fromthetablespacespaceusagemetrics,youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue,butnoalertshavebeengenerated.Whatcouldbethereasonforthis?()
A.TheEVENTparameterwasnotset.
B.TheSQL_TRACEparameterissettoFALSE
C.TheEnterpriseManagerGridControlisnotused.
D.TheSTATISTICS_LEVELparameterissettoBASIC
E.TheTIMED_STATISTICSparameterissettoFALSE
第2题
A.Thecommandrestoresonlythemissingcontrolfile.
B.Thecommandrestoresallthecontrolfiles.
C.Thecommandfailsbecausethedatabaseisrunning.
D.Thisisthecorrectwaytoaddressthisproblem.
E.Thisisnotthecorrectwaytoaddressthisproblem.
第3题
gevolumeoftransactionsfromnon-DBAusersinthelastonehour.TheundotablespaceUNDOTBS1isfullwithtransactionsandnotransactionwascommittedmorethanonehourago.Thedatabasehastwomoreundotablespaces.WhathappenstothenewDMLoperationsinthisscenario()
A.TheDMLcommandswillfail.
B.TheundodatageneratedbytheDMLisstoredinoneofthetwootherundotablespaces.
C.TheundodatageneratedbytheDMLwilloverwritetheextentsthatcontaincommittedundodata.
D.TheundodatageneratedbytheDMLisstoredintheSYSTEMundosegmentoftheSYSTEMtablespace
第4题
uirements.1.Theobjectscreatedbytheusermustbestoredinatablespace,TBS1,iftheTABLESPACEoptionisnotdefinedduringtheobjectcreation.2.Theusershouldbeabletouse10MBofspaceinthetablespaceTBS1.3.Theusermustchangethepasswordimmediatelyafterlogginginforthefirsttime.WhichthreeoptionsoftheCREATEUSERcommandwouldyouusetoachievethisobjective?()
A.profile
B.accountlock
C.accountunlock
D.passwordexpire
E.quota10MBonTBS1
F.passwordneverexpire
G.defaulttablespaceTBS1
H.quotaunlimitedonTBS1
I.temporarytablespaceTEMP
J.temporarytablespaceSYSTEM
第5题
A. CASCADE
B. UNIQUE
C. NONUNIQUE
D. CHECK
E. PRIMARY KEY
F. CONSTANT
G. NOT NULL
第6题
the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?()
A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C. The database instance starts, but Automatic Memory Management is disabled
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
第7题
A.Itisthetimeperiodafterwhichtheundodatabecomesobsolete.
B.Itisthetimeperiodafterwhichthecommittedundodatawouldbetransferredtoatemporarytablespace.
C.Itistheminimumtimeperioduptowhichthecommittedundodatawouldberetainediffreeundospaceisavailable.
D.ItisthetimeperiodafterwhichtheundodataistransferredtotheFlashRecoveryAreatoprovidereadconsistency.
第8题
edajobtoshrinktheTRANStableresidingontheTTtablespace.Thejobwouldrunat5:00p.m.everyFriday.Whenyouexaminethespaceusageofthetableafterthecompletionofthejob,youfindthatthetablehasnotbeenshrunk.Whatcouldhavebeenthereasonforthis?()
A.ThetablespacethatcontainstheTRANStableisonline.
B.ThetablespacethatcontainstheTRANStableispermanent.
C.ThetablespacethatcontainstheTRANStableislocallymanaged.
D.ThesegmentspacemanagementofthetablespacethatcontainstheTRANStableismanualinnature.
第9题
A. DROP emp_dept_uv;
B. DELETE emp_dept_uv;
C. REMOVE emp_dept_uv;
D. DROP VIEW emp_dept_uv;
E. DELETE VIEW emp_dept_uv;
F. REMOVE VIEW emp_dept_uv;
第10题
A. It can be set at the system, session, or table level.
B. It is used only across statements in the same session.
C. It can store the results from normal as well as flashback queries.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!