[单选]
Examine the structure if the EMPLOYEES table:
Column name Data Type Remarks
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID VARCHAR2(20) NOT NULL
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table
You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）

A . CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B . CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);
C . CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;
D . CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employee

外护层有绝缘要求的电缆在测其电阻时，应选用的摇表是（）。 500V。 100V。 2500V。 Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（） V$VALID_NLS_VALUES。 NLS_VALID_VALUES。 NLS_VALUE_OPTIONS。 V$NLS_VALUE_OPTIONS。 V$NLS_VALID_VALUES。 On which product media can the IVM install code be located？（） Base AIX Install media.。 Base VIOS Install media.。 AIX Expansion Pack media.。 VIOS Expansion Pack media.。脂肪的分解的开始产物？ What is a design consideration when using existing PCIe I/O drawers in a maximum bandwidth/throughput configuration on a new Power 750 system?（） The new system requires 1 installed processor card for the GX++ bus adapter。 The new system requires a minimum of 2 installed processor cards for the GX++ bus adapter。 The new system requires a minimum of 3 installed processor cards and the HPC InfiniBand cluster adapter。 The new system requires 1 installed processor card for the GX++ bus adapter and the HPC InfiniBand cluster adapter。

Examine the structure if the EMPLOYEES table:
Column name Data Type Remarks
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID VARCHAR2(20) NOT NULL
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table
You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: