多项选择题
Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true?（）
A. MANAGER must be a role.
B. It allows the MANAGER to pass the specified privileges on to other users.
C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
相关考题
-
单项选择题
Which operator can be used with a multiple-row subquery?（）
A. =
B. LIKE
C. BETWEEN
D. NOT IN
E. IS
F. <> -
单项选择题
Examine the structure of the EMPLOYEES table: You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）
A. CREATE INDEX NAME_IDX (first_name, last_name);
B. CREATE INDEX NAME_IDX (first_name AND last_name);
C. CREATE INDEX NAME_IDX ON (first_name, last_name);
D. CREATE INDEX NAME_IDX ON employees (first_name AND last_name);
E. CREATE INDEX NAME_IDX ON employees(first_name, last_name);
F. CREATE INDEX NAME_IDX FOR employees(first_name, last_name); -
单项选择题
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.
