题目内容

YouworkasadatabaseadministratorforSupportcenter.cn.Inyourproductiondatabase,thesizeofDatabaseBufferCacheneedstobeincreasedimmediatelyforthecurrentaswellasfutureinstancesofthedatabase.TheOracleinstancehasbeenconfiguredtoaccommodateanychangesinthesizeofthememorystructures.Atthisisproductiondatabase,youwanttoaccomplishthistaskwithnoimpactontheuser’sconnections.Whichactivitymustyouhavecompletedbeforeaccomplishingthistask?()

A. Youmusthavestartedthedatabaseinstanceinrestrictedmode.
B. YoumusthavestartedthedatabaseinstanceinNORMALmode.
C. Youmusthavestartedthedatabaseinstancewithserverparameterfile.
D. Youmusthavestartedthedatabaseinstancebutmustnothavemounted.
E. Youmusthavestartedthedatabaseinstancebutmustnothaveopened.

查看答案
更多问题

孙中山重新解释了三民主义,在民权主义方面提出五权分立,此五权除立法权、司法权外,还包括()。

A. 行政权
B. 考试权
C. 监察权
D. 复决权

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?()

A. Table_open_cache
B. Table_open_cache_instancs
C. Table_definition_cache
D. Tmp_table_size
E. Max_heap_table_size
F. Max_tmp_tables

TheSPFILEforyourdatabasecontainsthefollowingparametersettings:SGA_TARGET=1000MDB_CACHE_SIZE=512MSHARED_POOL_SIZE=128MLOG_BUFFER=10MDB_8K_CACHE_SIZE=50MWhatisthetotalmemorythatcanbedistributedacrosstheauto-tunedmemorycomponents?()

A. 940M
B. 990M
C. 690M
D. 1000M

力法中,主系数是由()图乘得出的

A. M1和M1
B. 以上都不是
C. MP和MP
D. M1和MP

答案查题题库