单项选择题

YouaremaintainingyourdatabaseinOracle10g.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
单项选择题
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