当前位置:1z0-043题库

问题:

[单选]

Your SPFILE contains the following parameter settings:  
SGA_TARGET = 8G  
DB_CACHE_SIZE = 4G  
SHARED_POOL_SIZE = 2G  
LARGE_POOL_SIZE = 512M  
JAVA_POOL_SIZE = 512M  
LOG_BUFFER = 100M  
SGA_MAX_SIZE = 10G  
You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G, but instead of specifying a value of 10G for the SGA_TARGET initialization parameter, you erroneously execute the following statement:  
SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH;  
What is the result of this statement?()  

A .  The database crashes.
B .  The large pool releases 512M of memory.
C .  The large pool retains 1G of allocated memory.
D .  The large pool increases to 1,512M of memory.

Which command should an administrator use to put a system in maintenance mode without rebooting?()   init 0。 telinit m。 shutdown -FM。 sh /etc/rc.maint。 开孔作业中,每开()次孔后,须分解并润滑每个零件。 20。 25。 28。 30。 In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?() The source PL/SQL code will be stored in native machine code.。 The source PL/SQL code will be stored in interpreted byte code.。 The compiled PL/SQL code will be stored in native machine code.。 The compiled PL/SQL code will be stored in interpreted byte code.。 When selling against competition, which of the following focus on the iDataPlex value proposition?() Large selection of proven applications 。 Standard rack mounting 。 Flexible configurations ready for integration and testing at the customers data center 。 Easy maintenance through individual hot-swappable node。 大肠杆菌有什么特征?

Your SPFILE contains the following parameter settings:  
SGA_TARGET = 8G  
DB_CACHE_SIZE = 4G  
SHARED_POOL_SIZE = 2G  
LARGE_POOL_SIZE = 512M  
JAVA_POOL_SIZE = 512M  
LOG_BUFFER = 100M  
SGA_MAX_SIZE = 10G  
You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G, but instead of specifying a value of 10G for the SGA_TARGET initialization parameter, you erroneously execute the following statement:  
SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH;  
What is the result of this statement?()  

参考答案:

  参考解析

本题暂无解析

在线 客服