下列选项中，能够将emp表的SELECT权限赋予用户SCOOT的语句是（)。

A.select count(all) from emp;

B.select count(emp_id) from emp;

C.select count(*) from emp;

D.select count(1) from emp;

A.A.GRANT CHANGE ON SCOTT、EMP TO SA

B.B.GRANT UPDATE ON SCOTT、EMP (SAL) TO SA

C.C.GRANT UPDATE(SAL) ON SCOTT、EMP TO SA

D.D.GRANT MODIFY ON SCOTT、EMP TO SA

A.A.select columns from emp

B.B.desc emp

C.C.show columns from emp

D.D.show emp

A.授权最小化，只需要SELECT权限

B.不要为了方便随便授权ALLPRIVIEGES

C.谨慎授权可能改变表内容的操作(updateinset等)权限

D.管理好权限周期，超过时间以及使用REVOKE回收权利

A.A.select alle_sal from emp

B.B.select distinct e_sal from emp

C.C.select e_sal from emp

D.D.select e_sal where emp

A.select*fromuser_tab_privs;

B.select*fromuser_tables;

C.select*fromuser_role_privs;

D.select*fromuser_sequences;

A.A.alter user hr account unlock

B.B.alter table alter unlock hr

C.C.alter table alter hr unlock

D.D.ater use hr unlock

A.A.UPDATE emp SET sal = 3000 WHERE ename = ‘SMITH’;

B.B.ALLTER TABLE emp ADD UNIQUE (ename);

C.C.COMMIT;

D.D.EXIT;