未分类题

YouneedtoreviewthecurrentstoragesystemanddecideonthebestconfigurationforthetempdbdatabaseonSQL1toimprovetempdbperformance.Yoursolutionmustensurethatcompanyrequirementsandpoliciesarefulfilled.Whichtwoactionsshouldyouperform？（）
A.CreateaRAID-1set，andmovetempdbtothisdriveset.
B.CreateaRAID-0set，andmovetempdbtothisdriveset.
C.Setthestartingsizeoftempdbto3GB
D.CreateaRAID-0set，andmovetempdbandtheuserdatabasewiththelargestindextothisdriveset.
E.Disableautomaticfilegrowthontempdb.

A.Yoursolutionmustensurethatcompanyrequirementsandpoliciesarefulfilled.Whichtwoactionsshouldyouperform？（）
A.CreateaRAID-1set，andmovetempdbtothisdriveset.
B.CreateaRAID-0set，andmovetempdbtothisdriveset.
C.Setthestartingsizeoftempdbto3GB
D.CreateaRAID-0set，andmovetempdbandtheuserdatabasewiththelargestindextothisdriveset.
E.Disableautomaticfilegrowthontempdb.

【参考答案】

A, C

<上一题目录下一题>

热门试题

单项选择题

TheHRusercreatesaviewwiththiscommand：SQL>CREATEVIEWemp_vASSELECT*FROMscott.emp；NowHRwantstogranttheSELECTprivilegeontheEMP_VviewtotheJIMuser.Whichstatementistrueinthisscenario？（）

A.HRcangranttheprivilegetoJIMbutwithoutGRANTOPTION.
B.HRcangranttheprivilegetoJIMbecauseHRistheowneroftheview.
C.SCOTThastogranttheSELECTprivilegeontheEMPtabletoJIMbeforethisoperation.
D.HRneedstheSELECTprivilegeontheEMPtablewithGRANTOPTIONfromSCOTTforthisoperation.

单项选择题

Examinethecommandsexecutedinthefollowingsequence：1：SQL>CREATEROLEmgrrole；2：SQL>GRANTcreateuser，selectanytable，connect，resourceTOmgrrole；3：SQL>GRANTselect，updateONsh.salesTOmgrrole；4：SQL>CREATEROLEceoIDENTIFIEDBYboss；5：SQL>GRANTmgrrole，dropanytable，createanydirectoryTOceo；6：SQL>GRANTceoTOmgrrole；Whichstatementistrueabouttheabovecommands（）A.Thecommandsexecutesuccessfully.B.Command6producesanerrorbecauseofcircularrolegrant.C.Command5producesanerrorbecausearolecannotbegrantedtoanotherrole.D.Command3producesanerrorbecausetheMGRROLErolealreadycontainssystemprivileges.E.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.F.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.

A.salesTOmgrrole；4：SQL>CREATEROLEceoIDENTIFIEDBYboss；5：SQL>GRANTmgrrole，dropanytable，createanydirectoryTOceo；6：SQL>GRANTceoTOmgrrole；Whichstatementistrueabouttheabovecommands（）
A.Thecommandsexecutesuccessfully.
B.Command6producesanerrorbecauseofcircularrolegrant.
C.Command5producesanerrorbecausearolecannotbegrantedtoanotherrole.
D.Command3producesanerrorbecausetheMGRROLErolealreadycontainssystemprivileges.
E.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.
F.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.