Notethefunctionalitiesofvariousbackgroundprocesses:1:Performrecoveryatinstancestartup.SMON
A.Checkpoint(CKPT):1,2,5
B.SystemMonitor(SMON):1,6
C.ProcessMonitor(PMON):4,6,7
D.DatabaseWriter(DBWR):1,3,4
A.Checkpoint(CKPT):1,2,5
B.SystemMonitor(SMON):1,6
C.ProcessMonitor(PMON):4,6,7
D.DatabaseWriter(DBWR):1,3,4
第1题
A.AnLOVforREFS.
B.AlistitemforREFs.
C.AradiogroupforREFs.
D.AhierarchicaltreeforREFS
第2题
Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However,insteadofperformingamediarecovery,youdecidedtore-createtheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestore-createtheindexes?()
A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTESTATISTICS
第3题
YouworkasadatabaseadministratorforCertkiller.com.Yoususpectthatinoneofyourapplicationsthecustomertableisbeingaccessedbysomeunauthorizedusers.Whichoptionwouldyouusetomonitorthequeriesbeingexecutedonthecustomertable?()
A.Monitorthealert.logfile
B.Enableserver-sideSQLtracingforusersessions
C.Enablefine-grainedauditingforthecustomertable
D.EnableFine-GrainedAccessControl(FGAC)forthecustomertable
E.WriteadatabasetriggeronthecustomertableontheSELECTevent
第4题
A.Form_Ahasupdatesordeletesthathavenotbeenpostedorcommitted,andForm_AinvokesForm_BwiththeOPEN_FORMbuilt-in.
B.Form_Ahasupdatesordeletesthathavenotbeenpostedorcommitted,andForm_AinvokesForm_BwiththeCALL_FORMbuilt-in.
C.Form_Ahasinsertsthathavenotbeenpostedorcommitted,andForm_AinvokesForm_BwiththeOPEN_FORMbuilt-in.
D.Form_Ahasinsertsthathavenotbeenpostedorcommitted,andForm_AinvokesForm_BwiththeCALL_FORMbuiltin.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!