单选题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？（）APUBLIC should be replaced with specific

题目

单选题

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？（）

PUBLIC should be replaced with specific usernames.

ALL should be replaced with a list of specific privileges.

WITH GRANT OPTION should be added to the statement.

Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

参考答案和解析

正确答案： B

解析：暂无解析

更多“单选题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 specifi”相关问题

第1题

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;

点击查看答案
第2题

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？（）A、HR can grant the privilege to JIM but without GRANT OPTION.B、HR can grant the privilege to JIM because HR is the owner of the view.C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

点击查看答案
第3题

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

点击查看答案
第4题

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

点击查看答案
第5题

You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）A、All the objects of scott are moved to the Recycle Bin.B、Any objects in the Recycle Bin belonging to scott are purged.C、All the objects owned by scott are permanently dropped from the database.D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

点击查看答案
第6题

You issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（） A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.D、The code will execute successfully but no privilege will be granted to the user， Scott.

点击查看答案
第7题

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.

点击查看答案

单选题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 specifi

题目

参考答案和解析

更多“单选题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 specifi”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

单选题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 specifi

更多“单选题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 specifi”相关问题