SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A、The User Global Area （UGA） is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automat

题目

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

  • A、The User Global Area （UGA） is not configured.
  • B、The sessions were started using the login name SYS.
  • C、The sessions are running in the Automatic Shared Memory Management mode.
  • D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.
相似考题

1.fwrite函数的一般调用形式是A．fwrite(buffer,count,size,fp);B．fwrite(fp,size,count,buffer);C．fwrite(fp,count,size,buffer);D．fwrite(buffer,size,count,fp);

2.Yourecentlycreatedadatabaseandconfiguredthe&enspYourecentlycreatedadatabaseandconfiguredtheSPFILEwiththefollowingparametersettingstoensurethatOracleautomaticallyadjuststhememoryfortheProgramGlobalArea（PGA）：SORT_AREA_SIZE=150MHASH_AREA_SIZE=150MBITMAP_MERGE_AREA_SIZE=150MCREATE_BITMAP_AREA_SIZE=150MWORKAREA_SIZE_POLICY=AUTOYouhavenotincludedthePGA_AGGREGATE_TARGETinitializationparameterintheSPFILEandtheSystemGlobalArea（SGA）iscurrentlysizedat4G.WhatisthetotalPGAmemoryallocatedacrossalldatabaseserverprocesses？（）

3.YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQL>SELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.ThevaluesoftheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.E.NominimumlimitsareimposedontheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameters.F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.

4.“我们这有许多1号到12号不同大小的包装箱。”译成英文是()。A、We have a lot of packaging tape from size 1 to size 12.B、We have a lot of mailing tubes from size 1 to size 12.C、We have a lot of padded envelopes from size 1 to size 12.D、We have a lot of packing boxes from size 1 to size 12

参考答案和解析
正确答案:D
更多“SORT_AREA SIZE and&#”相关问题

  • 第1题：

    VBA中用实际参数a和b调用有参过程size(c，d)的正确形式是( )。

    A．size c，d

    B．size a，b

    C．Call size(c，d)

    D．Call size a，b


    正确答案：B

  • 第2题：

    What is the maximum size that can be specified when creating an XML column in a DB2 table?()

    A.No size is specified

    B.The buffer pool size

    C.The page size for the table space

    D.The extent size for the table space


    参考答案：A

  • 第3题：

    下面的选项中，定义字号大小正确的是（）

    • A、p{font-size：12px；}
    • B、p{font-size：12px}
    • C、p{font-size："12px"；}
    • D、p{font-size：1em；}

    正确答案:A,D

  • 第4题：

    fwrite函数的一般调用形式是（）。

    • A、fwrite（buffer，count，size，fp）
    • B、fwrite（fp，size，count，buffer）
    • C、fwrite（fp，count，size，buffer）
    • D、fwrite（buffer，size，count，fp）

    正确答案:D

  • 第5题：

    A specialist is monitoring performance on a server. The data is on another partition within the same array as the OS. The following information is available：       （1）The average record written to disk is 16KB       （2）The I/O block size is 2KB   （3）The stripe size on the RAID array is 16KB  Which of the following will improve performance without rebuilding the operating system？（）

    • A、Change the I/O block size to match the RAID Stripe size.
    • B、Change the RAID stripe size to match the I/O block size.
    • C、Change the record size of the database to match the RAID stripe size.
    • D、Change the record size of the database to match the I/O transfer rate.

    正确答案:A

  • 第6题：

    What is the maximum size that can be specified when creating an XML column in a DB2 table?（）

    • A、No size is specified
    • B、The buffer pool size
    • C、The page size for the table space
    • D、The extent size for the table space

    正确答案:A

  • 第7题：

    单选题
    Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）
    A

     The parameter DB_CACHE_SIZE must be a multiple of 8.

    B

     The value of the parameter SGA_MAX_SIZE must be increased.

    C

     The tablespace must be created with a uniform extent size of 8 KB

    D

     The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）
    A

    Because 4194304 is the granule size

    B

    Because 4194304 is the standard block size

    C

    Because 4194304 is the largest nonstandard block size defined in the database

    D

    Because 4194304 is the total size of data already available in the database buffer cache


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement：   SQL> SELECT name， value， isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’；   The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE，  LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value less than 1G

    B

    The SGA_TARGET initialization parameter cannot be set to a value greater than 1G

    C

    The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA

    D

    The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.

    E

    No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and  JAVA_POOL_SIZE initialization parameters.

    F

    The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.


    正确答案： F,B
    解析： 暂无解析

  • 第10题：

    多选题
    在linux系统中，在当前目录下查找以d开头的，并且大小在0～200个字节之间的文件，以下命令正确的是（）。
    A

    find -name 'd*' -size -0c –size +200c

    B

    find -name 'd*' -size +0c -200c

    C

    find -size +0c –size -200c -name 'd*'

    D

    find -name 'd*' -size +0c –size -200c

    E

    find -name 'd*' -size [0c-200c]


    正确答案： B,A
    解析： 暂无解析

  • 第11题：

    单选题
    A TCP/IP application receives files from a remote machine.  The application reads 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size. Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）
    A

     Increase the size of thewall

    B

     Increase the size of sb_max

    C

     Increase the size of tcp_recvspace

    D

     Increase the size of tcp_sendspace


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）
    A

    The User Global Area （UGA） is not configured.

    B

    The sessions were started using the login name SYS.

    C

    The sessions are running in the Automatic Shared Memory Management mode.

    D

    The sessions are running in the automatic Program Global Area （PGA） memory management mode.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    下列程序的运行结果为______。 #define MS DOS #ifdef MS DOS #define INTEGER SIZE 32 #else #define INTEGER SIZE 16 #endif main () { printf ("integer_size=%d\n", INTEGER_SIZE); }

    A．integersize=32

    B．integer_size=16

    C．integersize=32,integer_size=16

    D．错误


    正确答案：A

  • 第14题：

    Which of the following statements best describes the relationship between a logical volume and a journaled file system (JFS)?()

    A.Increasing the size of a logical volume also increases the size of the file system

    B.Reducing the size of a logical volume requires reducing the size of the file system first

    C.Increasing the size of a file system requires increasing the size of the logical volume first

    D.Increasing the size of a file system also increases the size of the logical volume when necessary


    参考答案：D

  • 第15题：

    A TCP/IP application receives files from a remote machine.  The application reads 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size. Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）

    • A、 Increase the size of thewall
    • B、 Increase the size of sb_max
    • C、 Increase the size of tcp_recvspace
    • D、 Increase the size of tcp_sendspace

    正确答案:C

  • 第16题：

    The number of Congressmen from each state varies depending on （）

    • A、the size of the area
    • B、the size of the population
    • C、the tradition
    • D、the wealth

    正确答案:B

  • 第17题：

    Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

    • A、 The parameter DB_CACHE_SIZE must be a multiple of 8.
    • B、 The value of the parameter SGA_MAX_SIZE must be increased.
    • C、 The tablespace must be created with a uniform extent size of 8 KB
    • D、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

    正确答案:D

  • 第18题：

    单选题
    The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）
    A

     DB_4K_CACHE_SIZE only

    B

     DB_8K_CACHE_SIZE only

    C

     DB_BLOCK_SIZE and DB_4K_CACHE_SIZE

    D

     DB_BLOCK_SIZE and DB_8K_CACHE_SIZE

    E

     SGA_TARGET and DB_4K_CACHE_SIZE

    F

     DB_CACHE_SIZE only


    正确答案： F
    解析： 暂无解析

  • 第19题：

    多选题
    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）
    A

    Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.

    B

    Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.

    C

    Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.

    D

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.

    E

    Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.

    F

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.


    正确答案： A,B
    解析： 暂无解析

  • 第20题：

    单选题
    You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered.  To verify the change in size， you executed this command： SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE  ------------------- ----------- ------------------  db_cache_size big integer 4194304  （4M）  Why is the value set to 4194304 and not to 2516582（）
    A

    because 4194304 is the granule size

    B

    because 4194304 is the standard block size

    C

    because 4194304 is the largest nonstandard block size defined in the database

    D

    because 4194304 is the total size of data already available in the database buffer cache


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）
    A

    BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

    B

    BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

    C

    BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

    D

    BACKUP TABLESPACE TEMP SECTION SIZE 10M;

    E

    BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

    F

    BACKUP SPFILE SECTION SIZE 1M;

    G

    BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;


    正确答案： E,G
    解析： 暂无解析

  • 第22题：

    单选题
    A TCP/IP application is transferring files from a personal machine to a remote machine.  The application writes 32 kilobytes of data at a time to the socket， but has not issued a system call to set the window size.  Which of the following procedures should be performed on the personal machine to increase the throughput of the application？（）
    A

     Increase the size of thewall

    B

     Increase the size of sb_max

    C

     Increase the size of tcp_recvspace

    D

     Increase the size of tcp_sendspace


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following statements best describes the relationship between a logical volume and a journaled file system (JFS)?（）
    A

    Increasing the size of a logical volume also increases the size of the file system

    B

    Reducing the size of a logical volume requires reducing the size of the file system first

    C

    Increasing the size of a file system requires increasing the size of the logical volume first

    D

    Increasing the size of a file system also increases the size of the logical volume when necessary


    正确答案： B
    解析： 暂无解析

相关内容