[单选]
Examine the structure of the EMP_DEPT_VU view:
Column Name Type Remarks
EMPLOYEE_ID NUMBER From the EMPLOYEES table
EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table
SALARY NUMBER From the EMPLOYEES table
DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

A . SELECT * FROM emp_dept_vu;
B . SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
C . SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
D . SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
E . None of the statements produce an error; all are valid.

If a disk module on an XIV Storage System fails, what likely happens?（） the system slows significantly but still runs 。 the customer data is lost temporarily but can be recovered 。 the system goes into Read Only mode until redundancy is restored 。 the system redistributes itself and keeps running seamless to the end user&e。栽植土表层处理按下列方式进行： For which of the following products is the native Easy Tier feature available？（） DS5000 ,SVC and Storwize V7000。 DS8000,SVC and Storwize V7000。 DS8000,DS5000 and Storwize V7000。 TS3500,ProtecTIER and Tivoli Storage Manager。 Using the following information: Performance data from an existing system that a new system will replace; Performance estimates that anticipate future workloads; Micro-partitioning and logical partitioning implementations. Which of the following allows a technical sales representative to create a system design which can be imported into an HMC?（） IBMeConfig。 IBM Performance Monitor。 IBM Workload Estimator (WLE)。 IBM System Planning Tool (SPT)。情绪和情感过程是伴随着人的（）而产生的，它们是主体与客体之间关系的反应。认识过程。意志过程。个性心理特征。心理状态。

Examine the structure of the EMP_DEPT_VU view:
Column Name Type Remarks
EMPLOYEE_ID NUMBER From the EMPLOYEES table
EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table
SALARY NUMBER From the EMPLOYEES table
DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: