A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? （） A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? （）..

第1题

[单选题] Exhibit: 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.

点击查看答案

第2题

[单选题] 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.

点击查看答案

第3题

[多选题] In which four clauses can a subquery be used?（）

A、in the INTO clause of an INSERT statement B、in the FROM clause of a SELECT statement C、in the GROUP BY clause of a SELECT statement D、in the WHERE clause of a SELECT statement E、in the SET clause of an UPDATE statement F、in the VALUES clause of an INSERT statement

点击查看答案

第4题

[多选题] In which four clauses can a subquery be used? （）

A、in the INTO clause of an INSERT statement B、in the FROM clause of a SELECT statement C、in the GROUP BY clause of a SELECT statement D、in the WHERE clause of a SELECT statement E、in the SET clause of an UPDATE statement F、in the VALUES clause of an INSERT statement

点击查看答案

第5题

[多选题] Where can subqueries be used?（）

A、field names in the SELECT statement B、the FROM clause in the SELECT statement C、the HAVING clause in the SELECT statement D、the GROUP BY clause in the SELECT statement E、the WHERE clause in only the SELECT statement F、the WHERE clause in SELECT as well as all DML statements

点击查看答案

第6题

[单选题] The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A、Alice only B、Alice and Reena C、Alice, Reena, and Timber D、Sue, Alice, Reena, and Timber

点击查看答案

第7题

[单选题] The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A、Alice only B、Alice and Reena C、Alice, Reena, and Timber D、Sue, Alice, Reena, and Timber

点击查看答案

第8题

[多选题] Which two statements about views are true?（）

A、A view can be created as read only. B、A view can be created as a join on two or more tables. C、A view cannot have an ORDER BY clause in the SELECT statement. D、A view cannot be created with a GROUP BY clause in the SELECT statement. E、A view must have aliases defined for the column names in the SELECT statement.

点击查看答案

第9题

[多选题] Which two statements about views are true? （）

A、A view can be created as read only. B、A view can be created as a join on two or more tables. C、A view cannot have an ORDER BY clause in the SELECT statement. D、A view cannot be created with a GROUP BY clause in the SELECT statement. E、A view must have aliases defined for the column names in the SELECT statement.

点击查看答案

第10题

[多选题] Which two statements about views are true? （）

A、A view can be created as read only. B、A view can be created as a join on two or more tables. C、A view cannot have an ORDER BY clause in the SELECT statement. D、A view cannot be created with a GROUP BY clause in the SELECT statement. E、A view must have aliases defined for the column names in the SELECT statement.

点击查看答案

请使用微信扫码支付