当前位置:1z0-043题库

问题:

[单选]

The SPFILE for the PROD database specifies the following initialization parameter values:  
SGA_TARGET = 2G  
DB_8K_CACHE_SIZE = 128M  
You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay, you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M:  
SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH;  
What is the result of this statement?()  

A .  The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.
B .  The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.
C .  The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.
D .  The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.

属于可确指的无形资产的是()。 商誉。 非专利技术。 商标。 专营权。 施工单位对各个工序实施的“三级检查制度”是指() A.作业队初检、班组复检、项目部终检 。 B.班组初检、项目部复检、作业队终检 。 C.班组初检、作业队复检、项目部终检 。 D.项目部初检、班组复检、作业队终检。 Some xSeries servers support 4-way memory interleaving and some support 2-way interleaving.  In both types of interleaving, the data is accessed 256 bits at a time.  How is this 256-bit data access achieved with 2-way interleaving?() The DIMMs used for 2-way interleaving are double the width of DIMM used in 4-way interleaving.。 The DIMMs used for 2-way interleaving are 64-bit wide and data bits are accessed both on the rising edge and falling edge of the clock cycle.。 The DIMMs used for 2-way interleaving are 32-bit wide and data bits are accessed both on the rising edge and falling edge of the clock cycle.。 The DIMMs used for 2-way interleaving are double the width and data bits are accessed both on the rising edge and falling edge of the clock cycle.。 An administrator is looking for the "Open Restricted Shell Terminal" option on the HMC GUI. Under which panel is this option available?()  HMC Management, but only from a local connection。 Service Management, but only from a local connection.。 Systems Management, but only from a local connection.。 Systems Management, but only from a remote connection.。 The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code? () SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;。 SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';。 SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;。 SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;。 SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL。

The SPFILE for the PROD database specifies the following initialization parameter values:  
SGA_TARGET = 2G  
DB_8K_CACHE_SIZE = 128M  
You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay, you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M:  
SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH;  
What is the result of this statement?()  

参考答案:

  参考解析

本题暂无解析

在线 客服