单项选择题
A.GRANT select, insert, update ON student_grades TO manager
B.GRANT select, insert, update ON student_grades TO ROLE manager
C.GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D.GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E.GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
F.GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
多项选择题 Examine the data in the EMPLOYEES table: Which three subqueries work?（）
多项选择题 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）
单项选择题 Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 Kochhar 5000 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Sales 20 Marketing 30 Accounts 40 Administration You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）