单项选择题
Click the Exhibit button and examine the data in the EMPLOYEES table.
Examine the subquery:
SELECT last_name
FROM employees
WHERE salary IN (SELECT MAX(salary)
FROM employees
GROUP BY department_id);
Which statement is true?（）
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
相关考题
-
多项选择题
Which two are character manipulation functions? （）
A.TRIM
B.REPLACE
C.TRUNC
D.TO_DATE
E.MOD
F.CASE -
多项选择题
Which two are attributes of iSQL*Plus? （）
A.iSQL*Plus commands cannot be abbreviated.
B.iSQL*Plus commands are accessed from a browser.
C.iSQL*Plus commands are used to manipulate data in tables.
D.iSQL*Plus commands manipulate table definitions in the database.
E.iSQL*Plus is the Oracle proprietary interface for executing SQL statements. -
单项选择题
In which case would you use a FULL OUTER JOIN?（）
A.Both tables have NULL values.
B.You want all unmatched data from one table.
C.You want all matched data from both tables.
D.You want all unmatched data from both tables.
E.One of the tables has more data than the other.
F.You want all matched and unmatched data from only one table.
