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.
正确答案
答案解析
相似试题
(单选题)
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()