首页计算机考试Oracle认证
(单选题)

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()

    答案解析

快考试在线搜题