题目内容

Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate？（）

A. Indexcluster
B. Hashcluster
C. SortedHashcluster
D. RealApplicationCluster

查看答案

搜索结果不匹配？点我反馈

更多问题

ForwhichofthefollowingcanyouuseSegmentShrink？（）

A. Heaptables
B. Tableswithfunction-basedindexes
C. Indexes
D. Partitionsandsubpartitions
E. Noneoftheabove

查看答案

YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminethelogfilesizethatshouldequaltheminimumsizeofalltheonlineredologfiles.Whichcolumnwillenableyoutoperformthedesiredtask？（）

A. theWRITES_LOGFILE_SIZEcolumnoftheV$INSTANCE_RECOVERYview
B. thecolumnoftheV$INSTANCE_RECOVERYview
C. theOPTIMAL_LOGFILE_SIZEcolumnoftheV$INSTANCE_RECOVERYview
D. theLOG_FILE_SIZE_REDO_BLKScolumnoftheV$INSTANCE_RECOVERYview

查看答案

Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）

A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY

查看答案

WhenmanuallyconfiguringtheSGA，whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect？（）"FirstTest，FirstPass"-www.lead2pass.com97Oracle1Z0-053Exam

A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

查看答案

Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate？（）

A. Indexcluster B. Hashcluster C. SortedHashcluster D. RealApplicationCluster

ForwhichofthefollowingcanyouuseSegmentShrink？（）

Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）

WhenmanuallyconfiguringtheSGA，whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect？（）"FirstTest，FirstPass"-www.lead2pass.com97Oracle1Z0-053Exam

A. Indexcluster
B. Hashcluster
C. SortedHashcluster
D. RealApplicationCluster