Click the Exhibit button and examine the data from the

单项选择题

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.
Evaluate the SQL statement:
SELECT *
FROM orders
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_name = 'Smith');
What is the result when the query is executed?（）

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

相关考题

单项选择题 The EMP table contains these columns: EMPLOYEE_ID NUMBER(4) EMPNAME VARCHAR2 (25) SALARY NUMBER(9,2) HIRE_DATE DATE You query the database with this SQL statement: SELECT empname,hire_date HIREDATE, salary FROM EMP ORDER BY hire_date; How will the results be sorted?（）

单项选择题 Which is an iSQL*Plus command?（）

单项选择题 Which iSQL*Plus feature can be used to replace values in the WHERE clause?（）

备案号：湘ICP备14005140号-7

经营许可证号：湘B2-20140064

1Z0-007