单选题

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.

正确答案

来源:www.examk.com

答案解析

相似试题
  • View the Exhibit.  You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS;  Which type of backup would this command perform?()

    单选题查看答案

  • A user is running a long update batch file. Many tables are updated and all the  statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?()

    单选题查看答案

  • Which statements are true regarding the USERS tablespace()

    多选题查看答案

  • View the Exhibit. Which statements are true regarding the USERS tablespace()

    多选题查看答案

  • You executed the following command to drop a user:   DROP USER scott CASCADE;   Which two statements regarding the above command are correct?()

    多选题查看答案

  • Given: If the user types the password aiko when prompted, what is the result?()

    单选题查看答案

  • View the Exhibit1, which shows the options that are selected to create the user SL_REP. Which two statements are true regarding this user()

    多选题查看答案

  • You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to ()

    单选题查看答案

  • View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS;  Which three types of files are backed up? ()

    多选题查看答案

  • View the Exhibit to observe the roles assigned to the SL_REP user.  Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user()

    单选题查看答案