单项选择题
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
相关考题
-
单项选择题
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 -
多项选择题
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (CREDIT, CASH)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
A.SER_NO
B.ORDER_ID
C.STATUS
D.PROD_ID
E.ORD_TOTAL
F.composite index on ORDER_ID and ORDER_DATE -
单项选择题
Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）
A.No change is required to achieve the desired results.
B.SELECT ename, sal, 12*(sal+100) FROM emp;
C.SELECT ename, sal, (12*sal)+100 FROM emp;
D.SELECT ename, sal+100,*12 FROM emp;
