网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）
A
REVOKE SELECT FROM user2 ON TABLE org.tab1
B
REVOKE SELECT ON TABLE org.tab1 FROM user2
C
REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D
REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）A REVOKE SELECT FROM user2 ON TABLE org.tab1B REVOKE SELECT ON TABLE org.tab1 FROM user2C REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D REVOKE READ ACCESS ON TABLE org.tab1 FROM user2” 相关考题
考题
● 撤销 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;
考题
实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是( )。A．REVOKE UPDATE (XH) ON TABLE FROM USER4;B．REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;C．REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;
考题
下列SQI语句中，能够实现“收回用户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
考题
20 ） 下列 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 TO WANG
考题
下列SQL语句中,能够实现“收回用户U4对学生表(STUD)中学号(XH)的修改权”这一功能的是()。
A. REVOKE UPDATE(XH) ON TABLE FROM U4B. REVOKE UPDATE(XH) ON TABLE FROM PUBLICC. REVOKE UPDATE(XH) ON STUD FROM U4D. REVOKE UPDATE(XH) ON STUD FROM PUBLIC
考题
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
考题
Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH 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.
考题
实现“收回用户U4对学生表(STUD)中学号(XH)的修改权”这一功能的正确SQL语句是______。A．REVOKE UPDATE(XH) ON TABLE FROM U4B．REVOKE UPDATE(XH) ON TABLE STUD FROM PUBLICC．REVOKE UPDATE (XH) ON TABLE STUD FROM U4D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM U4
考题
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()
A.REVOKE SELECT FROM user2 ON TABLE org.tab1B.REVOKE SELECT ON TABLE org.tab1 FROM user2C.REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D.REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
考题
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()
A.REVOKE DROP ON t1 FROM PUBLICB.REVOKE UPDATE ON t1 FROM PUBLICC.REVOKE DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC
考题
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()
A.REVOKE ACCESS ON DATABASE FROM USER bobB.REVOKE CONNECT ON DATABASE FROM USER tomC.REVOKE tom FROM ACCESS ON DATABASE BY USER bobD.REVOKE tom FROM CONNECT ON DATABASE BY USER bob
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()
A.REVOKE ALL PRIVILEGES FROM USER tomB.REVOKE ALL ON EMPLOYEE FROM USER tomC.REVOKE EXECUTE ON EMPLOYEE FROM USER tomD.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
假设需要回收为用户test授予的CREATE ANY TABLE系统权限,可以使用如下()语句。
A.TAKE BACK CREATE ANY TABLE FROM testB.REVOKE CREATE ANY TABLE FROM testC.REVOKE CREATE ANY TABLE testD.TAKE BACK CREATE ANY TABLE test
考题
下列SQL语句中，能够实现“收回用户ZHAO对学生表（STUD）中学号（XH） 的修改权”这一功能的是（）A、REVOKE UPDATE(XH) ON TABLE FROM ZHAOB、REVOKE UPDATE(XH) ON TABLE FROM PUBLICC、REVOKE UPDATE(XH) ON STUD FROM ZHAOD、REVOKE UPDATE(XH) ON STUD FROM PUBLIC
考题
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）A、SELECT UNIQUE dept FROM staffB、SELECT DISTINCT dept FROM staffC、SELECT (dept) UNIQUE FROM staffD、SELECT (dept) DISTINCT FROM staff
考题
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
考题
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A、REVOKE ACCESS ON DATABASE FROM USER bobB、REVOKE CONNECT ON DATABASE FROM USER tomC、REVOKE tom FROM ACCESS ON DATABASE BY USER bobD、REVOKE tom FROM CONNECT ON DATABASE BY USER bob
考题
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）A、REVOKE SELECT FROM user2 ON TABLE org.tab1B、REVOKE SELECT ON TABLE org.tab1 FROM user2C、REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D、REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A、REVOKE ALL PRIVILEGES FROM USER tomB、REVOKE ALL ON EMPLOYEE FROM USER tomC、REVOKE EXECUTE ON EMPLOYEE FROM USER tomD、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）A、REVOKE DROP ON t1 FROM PUBLICB、REVOKE UPDATE ON t1 FROM PUBLICC、REVOKE DELETE ON t1 FROM PUBLICD、REVOKE CONTROL ON t1 FROM PUBLIC
考题
假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。A、TAKE BACK CREATE ANY TABLE FROM testB、REVOKE CREATE ANY TABLE FROM testC、REVOKE CREATE ANY TABLE testD、TAKE BACK CREATE ANY TABLE test
考题
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A、Alice onlyB、Alice and ReenaC、Alice, Reena, and TimberD、Sue, Alice, Reena, and Timber
考题
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.
考题
单选题Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A
REVOKE ACCESS ON DATABASE FROM USER bobB
REVOKE CONNECT ON DATABASE FROM USER tomC
REVOKE tom FROM ACCESS ON DATABASE BY USER bobD
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
考题
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A
Alice onlyB
Alice and ReenaC
Alice, Reena, and TimberD
Sue, Alice, Reena, and Timber
考题
单选题Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）A
REVOKE SELECT FROM user2 ON TABLE org.tab1B
REVOKE SELECT ON TABLE org.tab1 FROM user2C
REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D
REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
考题
单选题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.
考题
单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A
REVOKE ALL PRIVILEGES FROM USER tomB
REVOKE ALL ON EMPLOYEE FROM USER tomC
REVOKE EXECUTE ON EMPLOYEE FROM USER tomD
REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
热门标签
最新试卷
