单项选择题
Youaremaintainingadatabaseofcreditcardtransactions.YouwantthedatatobereturnedautomaticallyinthechronologicalorderofthecreditcardnumberswithoutusingtheORDERBYclauseinthequery.Whichtypeofclusterwillyouusetoobtainthedesiredresult？（）
A.Hashcluster
B.Indexcluster
C.Sortedhashcluster
D.RealApplicationcluster
- A.YouwantthedatatobereturnedautomaticallyinthechronologicalorderofthecreditcardnumberswithoutusingtheORDERBYclauseinthequery.Whichtypeofclusterwillyouusetoobtainthedesiredresult？（）
A.Hashcluster
B.Indexcluster
C.Sortedhashcluster
D.RealApplicationcluster
相关考题
-
单项选择题
YouworkasadatabaseadministratorforSupportcenter.cn.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective，whichcomponentwouldyouconfigureoneachdatabaseserver？（）A.DatabaseControlB.ManagementServerC.ManagementRepositoryD.ApplicationServerControlE.OracleManagementAgent
A.cn.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective，whichcomponentwouldyouconfigureoneachdatabaseserver？（）
A.DatabaseControl
B.ManagementServer
C.ManagementRepository
D.ApplicationServerControl
E.OracleManagementAgent -
单项选择题
YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminetheoptimalsizeoftheonlineredologfiles.Whichtoolenablesyoutodeterminetheoptimalsizeoftheonlineredologfiles？（）A.OracleEnterpriseManagerB.TheV$LOGviewC.TheV$LOGFILEviewD.TheV$FLASHBACK_DATABASE_LOGSview
A.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminetheoptimalsizeoftheonlineredologfiles.Whichtoolenablesyoutodeterminetheoptimalsizeoftheonlineredologfiles？（）
A.OracleEnterpriseManager
B.TheV$LOGview
C.TheV$LOGFILEview
D.TheV$FLASHBACK_DATABASE_LOGSview -
单项选择题
Inwhichscenariowillyoucreateasortedhashcluster？（）
A.iftheapplicationusesqueriesjoiningtablesonlyoccasionally
B.ifthefulltablescanisexecutedoftenononlyonetableoftheclusteredtables
C.ifthedataforalltherowsofaclusterkeyvalueexceedsoneortwoOracleblocks
D.whenyouwantthedatatobereturnedautomaticallyinthechronologicalorder
