^{<small id="xhtk1"></small>}

單項(xiàng)選擇題

Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?（）

A.selection, projection, join
B.difference, projection, join
C.selection, intersection, join
D.intersection, projection, join
E.difference, projection, product

你可能感興趣的試題

單項(xiàng)選擇題

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.
Evaluate this SQL statement:
SELECT cust_id, ord_total
FROM orders
WHERE ord_total > ANY(SELECT ord_total
FROM orders
WHERE cust_id IN (SELECT cust_id
FROM customers WHERE city LIKE'New York'));
What is the result when the above query is executed?（）

A.A
B.B
C.C
D.D
E.E

單項(xiàng)選擇題

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*FROMemp_dept_vu；
B.SELECTdepartment_id，SUM（salary）FROMemp_dept_vuGROUPBYdepartment_id；
C.SELECTdepartment_id，job_id，AVG（salary）FROMemp_dept_vuGROUPBYdepartment_id，job_id；
D.SELECTjob_id，SUM（salary）FROMemp_dept_vuWHEREdepartment_idIN（10，20）GROUPBYjob_idHAVINGSUM（salary）>；20000；
E.Noneofthestatementsproduceanerror；allarevalid

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

你可能感興趣的試題

Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?（）