[单选]

The EMPLOYEE tables has these columns:
LAST_NAME VARCHAR2(35)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(5,2)
You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.
Which SQL statement displays the desired results? （）

A customer has a file server with RAID-5 using 8KB random I/Os， with 67% reads and 33% writes.  How should the disk controller cache be configured for optimal performance？（） Use write-back cache。 Use write-back cache with battery backup。 Use write-through cache with disk caching enabled。 Use write-through cache with disk caching disabled。 园林树木修剪的时期 What is a key ability of IBM Systems Director Enterprise Edition as compared to Standard Edition?（） Manage multiple operating systems on a server。 Manage energy consumption and network traffic to increase efficiency。 Manage LPARs, operating systems and servers to reduce administration。 Manage workloads across multiple servers to optimize resource utilizatio。 阿利规律 The database on a p5-570 Micro-Partition has grown and backups are not meeting the Service Level Agreement. There are several partitions using the Virtual I/O Server to access the storage array. The database backup has high CPU utilization while the others have low CPU utilization. What adjustment can the technical specialist make to ensure that the Service Level Agreement is achieved？（） Add memory to the database partition to improve response time.。 Add additional Host Bus Adapters to the server to improve IO throughput.。 Modify CPU allocations to favor the database partition.。 Increase CPU allocations to the Virtual I/O Server.。

The EMPLOYEE tables has these columns:
LAST_NAME VARCHAR2(35)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(5,2)
You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.
Which SQL statement displays the desired results? （）