题目内容

YouworkasadatabaseadministratorforSupportcenter.cn.InyourOracledatabase10ginstallationyouhavesetORACLE_BASEto/u01/app/oracle.Whichobjectivewillbeachievedbythissetting?()

A. TheOraclekernelwillbeplacedinthislocation.
B. TheOraclesoftwarewillbeplacedinthislocation.
C. Theserverparameterfile(SPFILE)willbeplacedinthislocation.
D. Thedatabasefileswillbeplacedinthislocation,ifnotspecifiedexplicitly.
E. ThelocationwillbeconsideredforthebaseofOracleManagedFiles(OMF).
F. ThelocationwillbeconsideredforthebaseofOptimalFlexibleArchitecture(OFA).

查看答案
更多问题

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

答案查题题库