可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the structure of the EMPLOYEE


Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?()

  • ASELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
  • BSELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
  • CSELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
  • DSELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id )
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NA...

2、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert ...

3、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhich UPDATE stat...

4、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOY...

5、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?()ABCD

6、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER NOT NULLEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) DEFAULT 'SA_REP'SAL NUMBERCOMM...