更多"撤销U5对Emp表的查询权限,并收回U5授予其它用户的该权限,SQL语"的相关试题:
[单项选择]SQL语言规定对数据库中的表能够执行授予权限和收回权限命令的用户()。
A. 只能是表的使用者
B. 只能是表的建立者
C. 只能是DBA
D. 是DBA和表的建立者
[判断题]如果用户A将系统权限createtable授予了用户B,用户B又将系统权限createtable授予了用户C。那么,当删除用户B后后,用户C无法保留着系统权限createtable。
[单项选择]把查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。
A. GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC
B. GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC
C. GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION
D. GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
[单项选择]将查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。
A. GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC
B. GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC
C. GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION
D. GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
[单项选择]将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户。实现该功能的SQL语句是______。
A. GRANT SELECT TO SC U1 WITH PUBLIC
B. GRANT SELECT ON SC TO U1 WITH PUBLIC
C. GRANT SELECT TO SC ON U1 WITH GRANT OPTION
D. GRANT SELECT ON SC TO U1 WITH GRANT OPTION
[判断题]对于角色来说,既可授予系统权限,也可授予对象权限,还可把另一个角色的权限授予给它。
[多项选择] Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?()
A. remove the ORDER BY clause
B. remove the table alias prefix from the WHERE clause
C. remove the table alias from the SELECT clause
D. prefix the column in the USING clause with the table alias
E. prefix the column in the ORDER BY clause with the table alias
F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"
[单项选择] Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement?()
A. The statement produces an error at line 1.
B. The statement produces an error at line 3.
C. The statement produces an error at line 6.
D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.