单项选择题
Inwhichscenariowillyoucreateasortedhashcluster？（）
- A.iftheapplicationusesqueriesjoiningtablesonlyoccasionally
B.ifthefulltablescanisexecutedoftenononlyonetableoftheclusteredtables
C.ifthedataforalltherowsofaclusterkeyvalueexceedsoneortwoOracleblocks
D.whenyouwantthedatatobereturnedautomaticallyinthechronologicalorder
点击查看答案&解析
相关考题
-
单项选择题
Yourdatabaseisnotconfiguredforsessionfailover.Yourtnsnames.orafilecontainsthefollowingdetails：test.us.oracle.com=（DESCRIPTION=（ADDRESS_LIST=（LOAD_BALANCE=off）（FAILOVER=ON）（ADDRESS=（PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））（ADDRESS=（PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））（CONNECT_DATA=（SERVICE_NAME=test.us.oracle.com）））Whichfeatureisenabledinthiscase？（）A.LoadbalancingB.InstancefailoverC.DatabasefailoverD.Connect-timefailoverE.TransparentApplicationFailover（TAF）
A.Yourtnsnames.orafilecontainsthefollowingdetails：test.us.oracle.com=（DESCRIPTION=（ADDRESS_LIST=（LOAD_BALANCE=off）（FAILOVER=ON）（ADDRESS=（PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））（ADDRESS=（PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））（CONNECT_DATA=（SERVICE_NAME=test.us.oracle.com）））Whichfeatureisenabledinthiscase？（）
A.Loadbalancing
B.Instancefailover
C.Databasefailover
D.Connect-timefailover
E.TransparentApplicationFailover（TAF） -
单项选择题
YouwanttomovealltheobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask？（）
A.FULL
B.SCHEMAS
C.REMAP_SCHEMA
D.REMAP_DATAFILES
E.REMAP_TABLESPACE -
单项选择题
YoumovedtheindexEMP_NO_INDXfromonetablespacetoanotherandthenissuedthefollowingcommandtorebuildtheindexEMP_NO_INDX：SQL>ALTERINDEXEMP_NO_INDXREBUILDONLINE；WhichtableallowstheuserstoaccesstheEMP_NO_INDXindexwhileperformingtherebuildoperation？（）A.Index-organizedtableB.MappingTableC.ClusteredTableD.JournalTable
A.Index-organizedtable
B.MappingTable
C.ClusteredTable
D.JournalTable
