网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
将表Emp的empname属性列的修改权限授予用户LIU，并允许LIU再将此权限转授其他人，实现的SQL语句是(48)。
A．GRANT update on Emp TO LIU WITH CHECK OPTION
B．GRANT update(empname)on Emp TO LIU WITH CHECK OPTION
C．GRANT update on Emp TO LIU WITH GRANT OPTION
D．GRANT update(empname)on Emp TO LIU WITH GRANT OPTION
参考答案
更多 “ 将表Emp的empname属性列的修改权限授予用户LIU，并允许LIU再将此权限转授其他人，实现的SQL语句是(48)。A．GRANT update on Emp TO LIU WITH CHECK OPTIONB．GRANT update(empname)on Emp TO LIU WITH CHECK OPTIONC．GRANT update on Emp TO LIU WITH GRANT OPTIOND．GRANT update(empname)on Emp TO LIU WITH GRANT OPTION ” 相关考题
考题
（ 35 ） “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是A ） GRANT SELECT ， UPDATE （ grade ） ON TABLE sc TO user1B ） GRANT SELECT sc ， UPDATE sc . grade TO user1C ） GRANT SELECT ， UPDATE ON TABLE sc . grade TO user1D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1
考题
● 撤销 U5 对 Emp 表的查询权限，并收回 U5 授予其它用户的该权限，SQL 语句是 （51） 。（51）A. REVOKE SELECT ON TABLE Emp FROM U5 CASCADE;B. REVOKE SELECT ON TABLE Emp FROM U5 RESTRICT;C. REVOKE QUERY ON TABLE Emp FROM U5 CASCADE;D. GRANT SELECT ON TABLE Emp TO U5 WITH GRANT OPTION;
考题
将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。A．GRANT SELECT TO SC U1 WITH PUBLICB．GRANT SELECT ON SC TO U1 WITH PUBLICC．GRANT SELECT TO SC ON U1 WITH GRANT OPTIOND．GRANT SELECT ON SC TO U1 WITH GRANT OPTION
考题
“把查询SC表和更新SC表的9rade列的权限受予用户userl”的正确SQL语句是（ ）。A) GRANT SELECT, UPDATE (grade) ON TABLE sc TO userlB) GRANT SELECT so,UPDATE sc,grade TO userlC) GRANT SELECT, UPDATE ON TABLE sc.grade TO userlD) GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc (grade)TO userl
考题
“把查询SC表和更新SC表的9rade列的权限授予用户user”的正确SQL语句是（ ）。A)GRANT.SELECT sc, UPDATE sc.grade TO userB)GRANT SELECT, UPDATE (grade) ON TABLE sc TO userC)GRANT SELECT, UPDATE ON TABLE sc.grade TO userD)GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user
考题
已知关系SPJ(S,P,J,QTY),把对关系SPJ的属性QTY的修改权授予用户张三的T－SQL语句是( )
A.GRANT QTY ON SPJ TO 张三B.GRANT UPDATE ON SPJ TO张三C.GRANT UPDATE (QTY) ON SPJ TO张三D.GRANT UPDATE ON SPJ (QTY) TO张三
考题
“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是______。A．GRANT SELECT, UPDATE(grade)ON TABLE sc TO user1B．GRANT SELECT sc, UPDATE sc, grade TO user1C．GRANT SELECT, UPDATE ON TABLE sC.grade TO user1D．GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user1
考题
“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是（ ）。A．GRANT SELECT，UPDATE（grade）ON TABLE sc TO user1B．GRANT SELECT sc，UPDATE sc．grade TO user1C．GRANT SELECT，UPDATE ON TABLE sc．grade TO usedD．GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc(grade) TO user1
考题
下列SQL语句中，能够实现“收回用户WANG对学生表(STUDENT)中学号(XH)的修改权”这一功能的是( )。A．GRANT UPDATE(XH) ON STUDENT TO WANGB．GRANT UPDATE(XH) ON TABLE TO WANGC．REVOKE UPDATE(XH) ON STUDENT FROM WANGD．REVOKE UPDATE(XH) ON TABLE FROM WANG
考题
●将表employee中name列的修改权限赋予用户Liu，并允许其将该权限授予他人，应使用的SQL语句为：GRANT (52) ON TABLE employee TO Liu (53) ;(52)A．UPDATE(name)B．DELETEC．SELECTD．INSERT(53)A．FORALLB．CASCADEC． WITH GRANT OPTIOND．WITH CHECK OPTION
考题
● 将Students表的插入权限赋予用户UserA，并允许其将该权限授予他人，应使用的SQL语句为：GRANT （15）TABLE Students TO UserA （16） ;（15）A．UPDATEB．UPDATE ONC．INSERTD．INSERT ON（16）A．FOR ALLB．PUBLICC．WITH CHECK OPTIOND．WITH GRANT OPTION
考题
要将部门表Dept中name列的修改权限赋予用户Ming,并允许Ming将该权限授予他人。实现该要求的SQL语句如下:GRANT UPDATE(name) ON TABLE Dept TO Ming ( ):
A.FOR ALLB.CASCADEC.WITH GRANT OPTIOND.WITH CHECK OPTION
考题
授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。
A.GRANT CHANGE ON SCOTT.EMP TO SAB.GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC.GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
考题
● 将表Emp的empname属性列的修改权限授予用户LIU， 并允许LIU 再将此权限转授其他人，实现的SQL语句是 （48） 。（48）A. GRANT update on Emp TO LIU WITH CHECK OPTIONB. GRANT update(empname) on Emp TO LIU WITH CHECK OPTIONC. GRANT update on Emp TO LIU WITH GRANT OPTIOND. GRANT update(empname) on Emp TO LIU WITH GRANT OPTION
考题
Hello, may I speak to Liu Mei?（）A、I'm Liu MeiB、Liu Mei is meC、My name is Liu MeiD、This is Liu Mei speaking
考题
下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）A、GRANT INSERT ON emp TO acctsuperB、GRANT CREATE TABLE TO acctsuperC、GRANT SELECT ON emp TO acctsuperD、GRANT UPDATE ANY TABLE TO acctsuperE、GRANT CREATE SESSION TO acctsuper
考题
把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是 （）A、GRANT GRADE ON SC TO ZHAOB、GRANT UPDATE ON SC TO ZHAOC、GRANT UPDATE (GRADE) ON SC TO ZHAOD、GRANT UPDATE ON SC (GRADE) TO ZHAO
考题
授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。A、GRANT CHANGE ON SCOTT.EMP TO SAB、GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC、GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD、GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
考题
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command： SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim； Now， the user HR decides to revoke privileges from JIM using this command： SQL REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）A、The command fails because SCOTT still has privileges.B、The command succeeds and privileges are revoked from JIM.C、The command fails because HR cannot revoke the privileges from JIM.D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
考题
单选题Hello, may I speak to Liu Mei?（）A
I'm Liu MeiB
Liu Mei is meC
My name is Liu MeiD
This is Liu Mei speaking
考题
单选题授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。A
GRANT CHANGE ON SCOTT.EMP TO SAB
GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC
GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD
GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
考题
多选题下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）AGRANT INSERT ON emp TO acctsuperBGRANT CREATE TABLE TO acctsuperCGRANT SELECT ON emp TO acctsuperDGRANT UPDATE ANY TABLE TO acctsuperEGRANT CREATE SESSION TO acctsuper
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
热门标签
最新试卷