题目内容

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

What elements of globalization can be explicitly defined using the NLS_LANG environment variable？（）

A. NLS_LANGUAGE
B. NLS_SORT
C. NLS_CALENDAR
D. NLS_CHARACTERSET
E. NLS_TERRITORY

Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate？（）

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