REVOKE SELECT FROM user2 ON TABLE org.tab1
REVOKE SELECT ON TABLE org.tab1 FROM user2
REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
第1题:
A. REVOKE UPDATE(XH) ON TABLE FROM U4
B. REVOKE UPDATE(XH) ON TABLE FROM PUBLIC
C. REVOKE UPDATE(XH) ON STUD FROM U4
D. REVOKE UPDATE(XH) ON STUD FROM PUBLIC
第2题:
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.
第3题:
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
第4题:
A.REVOKE ACCESS ON DATABASE FROM USER bob
B.REVOKE CONNECT ON DATABASE FROM USER tom
C.REVOKE tom FROM ACCESS ON DATABASE BY USER bob
D.REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第5题:
A.TAKE BACK CREATE ANY TABLE FROM test
B.REVOKE CREATE ANY TABLE FROM test
C.REVOKE CREATE ANY TABLE test
D.TAKE BACK CREATE ANY TABLE test
第6题:
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?()
第7题:
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()
第8题:
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()
第9题:
假设需要回收为用户test授予的CREATE ANY TABLE系统权限,可以使用如下()语句。
第10题:
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()
第11题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第12题:
The command fails because SCOTT still has privileges.
The command succeeds and privileges are revoked from JIM.
The command fails because HR cannot revoke the privileges from JIM.
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
第13题:
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 only
B. Alice and Reena
C. Alice, Reena, and Timber
D. Sue, Alice, Reena, and Timber
第14题:
实现“收回用户U4对学生表(STUD)中学号(XH)的修改权”这一功能的正确SQL语句是______。
A.REVOKE UPDATE(XH) ON TABLE FROM U4
B.REVOKE UPDATE(XH) ON TABLE STUD FROM PUBLIC
C.REVOKE UPDATE (XH) ON TABLE STUD FROM U4
D.REVOKE ALL PRIVILEGES ON TABLE STUD FROM U4
第15题:
A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC
第16题:
A.REVOKE ALL PRIVILEGES FROM USER tom
B.REVOKE ALL ON EMPLOYEE FROM USER tom
C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
第17题:
下列SQL语句中,能够实现“收回用户ZHAO对学生表(STUD)中学号(XH) 的修改权”这一功能的是()
第18题:
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?()
第19题:
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()
第20题:
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?()
第21题:
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?()
第22题:
REVOKE ACCESS ON DATABASE FROM USER bob
REVOKE CONNECT ON DATABASE FROM USER tom
REVOKE tom FROM ACCESS ON DATABASE BY USER bob
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第23题:
REVOKE SELECT FROM user2 ON TABLE org.tab1
REVOKE SELECT ON TABLE org.tab1 FROM user2
REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
第24题:
REVOKE ALL PRIVILEGES FROM USER tom
REVOKE ALL ON EMPLOYEE FROM USER tom
REVOKE EXECUTE ON EMPLOYEE FROM USER tom
REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom