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.
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.
相关考题：
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);
“我们这有许多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
Yourecentlycreatedadatabaseandconfiguredthe&ensp YourecentlycreatedadatabaseandconfiguredtheSPFILEwiththefollowingparametersettingstoensurethatOracleautomaticallyadjuststhememoryfortheProgramGlobalArea（PGA）：SORT_AREA_SIZE=150MHASH_AREA_SIZE=150MBITMAP_MERGE_AREA_SIZE=150MCREATE_BITMAP_AREA_SIZE=150MWORKAREA_SIZE_POLICY=AUTOYouhavenotincludedthePGA_AGGREGATE_TARGETinitializationparameterintheSPFILEandtheSystemGlobalArea（SGA）iscurrentlysizedat4G.WhatisthetotalPGAmemoryallocatedacrossalldatabaseserverprocesses？（）
YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQLSELECTname，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.
下列程序的运行结果为______。 #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=32B．integer_size=16C．integersize=32,integer_size=16D．错误
What is the maximum size that can be specified when creating an XML column in a DB2 table?() A.No size is specifiedB.The buffer pool sizeC.The page size for the table spaceD.The extent size for the table space
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 systemB.Reducing the size of a logical volume requires reducing the size of the file system firstC.Increasing the size of a file system requires increasing the size of the logical volume firstD.Increasing the size of a file system also increases the size of the logical volume when necessary
下面的选项中，定义字号大小正确的是（）A、p{font-size：12px；}B、p{font-size：12px}C、p{font-size："12px"；}D、p{font-size：1em；}
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 thewallB、 Increase the size of sb_maxC、 Increase the size of tcp_recvspaceD、 Increase the size of tcp_sendspace
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）
The number of Congressmen from each state varies depending on （）A、the size of the areaB、the size of the populationC、the traditionD、the wealth
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.
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 KBD、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A、No size is specifiedB、The buffer pool sizeC、The page size for the table spaceD、The extent size for the table space
单选题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 onlyB DB_8K_CACHE_SIZE onlyC DB_BLOCK_SIZE and DB_4K_CACHE_SIZED DB_BLOCK_SIZE and DB_8K_CACHE_SIZEE SGA_TARGET and DB_4K_CACHE_SIZEF DB_CACHE_SIZE only
单选题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 KBD The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
多选题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？ （）AModifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.BModifying 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.CIncreasing 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.DDecreasing 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.EIncreasing 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.FDecreasing 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.
单选题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（）ABecause 4194304 is the granule sizeBBecause 4194304 is the standard block sizeCBecause 4194304 is the largest nonstandard block size defined in the databaseDBecause 4194304 is the total size of data already available in the database buffer cache
单选题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（）Abecause 4194304 is the granule sizeBbecause 4194304 is the standard block sizeCbecause 4194304 is the largest nonstandard block size defined in the databaseDbecause 4194304 is the total size of data already available in the database buffer cache
多选题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？（）AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.FThe 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.
多选题The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;DBACKUP TABLESPACE TEMP SECTION SIZE 10M;EBACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;FBACKUP SPFILE SECTION SIZE 1M;GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
多选题在linux系统中，在当前目录下查找以d开头的，并且大小在0～200个字节之间的文件，以下命令正确的是（）。Afind -name 'd*' -size -0c –size +200cBfind -name 'd*' -size +0c -200cCfind -size +0c –size -200c -name 'd*'Dfind -name 'd*' -size +0c –size -200cEfind -name 'd*' -size [0c-200c]
单选题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 thewallB Increase the size of sb_maxC Increase the size of tcp_recvspaceD Increase the size of tcp_sendspace
单选题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 thewallB Increase the size of sb_maxC Increase the size of tcp_recvspaceD Increase the size of tcp_sendspace
单选题Which of the following statements best describes the relationship between a logical volume and a journaled file system (JFS)?（）AIncreasing the size of a logical volume also increases the size of the file systemBReducing the size of a logical volume requires reducing the size of the file system firstCIncreasing the size of a file system requires increasing the size of the logical volume firstDIncreasing the size of a file system also increases the size of the logical volume when necessary
单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）AThe User Global Area （UGA） is not configured.BThe sessions were started using the login name SYS.CThe sessions are running in the Automatic Shared Memory Management mode.DThe sessions are running in the automatic Program Global Area （PGA） memory management mode.