单选题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?（）AAlice onlyBAlice and ReenaCAlice, Reena, and TimberDSue, Alice, Reena, and Timber
单选题
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
参考解析
解析：
暂无解析
相关考题：
（ 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
“把查询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
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? () A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?() A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user
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 DBA issues this SQL command:What privileges does the user Scott have at this point?() A. No privileges.B. Only the SELECT privilege.C. Only the CONNECT privilege.D. All the privileges of a default user.
Scott issues the SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13)};GRANT SELECTON DEPTT0 SUE;If Sue needs to select from Scott‘s DEPT table, which command should she use?（）A.SELECT*FROMDEPT；B.SELECT*FROMSCOTT.DEPT；C.SELECT*FROMDBASCOTTDEPT；D.SELECT*FROMALL_USERSWHEREUSER_NAME=‘；SCOTT‘；ANDTABLENAME=‘；DEPT‘；；
“把查询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
授予用户Jean可以查询帐户表的权限,使用的SQL语句是( ) A GRANT SELECT ON 帐户 TO JeanB GRANT SELECT TO Jean ON 帐户C GRANT SELECT TO帐户 ON JeanD GRANT SELECT ON Jean TO 帐户
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A、 PUBLIC should be replaced with specific usernames.B、 ALL should be replaced with a list of specific privileges.C、 WITH GRANT OPTION should be added to the statement.D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）A、GRANT select ON dept TO ALL_ USER;B、GRANT select ON dept TO ALL;C、GRANT QUERY ON dept TO ALL_USERSD、GRANT select ON dept TO PUBLIC;
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A、User processB、Server processC、System Monitor (SMON)D、Process Monitor (PMON)E、Checkpoint process (CKPT)
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）A、No privileges.B、Only the SELECT privilege.C、Only the CONNECT privilege.D、All the privileges of a default user.
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
Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）A、SELECT*FROMDEPT；B、SELECT*FROMSCOTT.DEPT；C、SELECT*FROMDBASCOTTDEPT；D、SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；
单选题Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）ASELECT*FROMDEPT；BSELECT*FROMSCOTT.DEPT；CSELECT*FROMDBASCOTTDEPT；DSELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）Ano privilegesBonly the SELECT privilegeConly the CONNECT privilegeDall the privileges of a default user
单选题The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）A PUBLIC should be replaced with specific usernames.B ALL should be replaced with a list of specific privileges.C WITH GRANT OPTION should be added to the statement.D Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）AThe commands execute successfully.BCommand 6 produces an error because of circular role grant.CCommand 5 produces an error because a role cannot be granted to another role.DCommand 3 produces an error because the MGRROLE role already contains system privileges.EThe table created by HR remains and HR still has the CREATE TABLE system privilege.FThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）AAcquire locks on table queried BGenerate redo for statement CFetch data from disk into memory DWrite changes to disk
单选题The HR user creates a view with this command： SQL CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）AHR can grant the privilege to JIM but without GRANT OPTION.BHR can grant the privilege to JIM because HR is the owner of the view.CSCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.DHR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
单选题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（）AThe command fails because SCOTT still has privileges.BThe command succeeds and privileges are revoked from JIM.CThe command fails because HR cannot revoke the privileges from JIM.DThe command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）ANo privileges.BOnly the SELECT privilege.COnly the CONNECT privilege.DAll the privileges of a default user.
单选题The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）AGRANT select ON dept TO ALL_ USER;BGRANT select ON dept TO ALL;CGRANT QUERY ON dept TO ALL_USERSDGRANT select ON dept TO PUBLIC;
单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A GRANT SELECT ANY TRANSACTION TO ARRENB GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC GRANT SELECT_ANY_TRANSACTION TO ARREND GRANT FLASHBACK TO ARRENE GRANT SELECT ANY VIEW TO ARREN
单选题Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）ASELECT*FROMDEPT；BSELECT*FROMSCOTT.DEPT；CSELECT*FROMDBASCOTTDEPT；DSELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；