单选题

Examine the following steps performed on a database instance:  1:The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2:The SKD usercreates a table.  3:The SKD user grants theCREATETABLE system privilege to the HR user.  4:The HR user creates a table.  5:The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed()

AThe table created by SKD isnot accessibleand SKD cannot create new tables.

BThe tables created by SKD and HR remain, but both cannot create new tables.

CThe table created by HR remains and HR still has the CREATE TABLE system privilege.

DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

正确答案

来源:www.examk.com

答案解析

相似试题
  • View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement?()

    单选题查看答案

  • View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to().

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • Exhibit: View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABLE trans SHRINK SPACE CASCADE;  Which objects would be affected by this command?()

    多选题查看答案

  • View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?  ()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command()

    单选题查看答案

  • View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident()

    单选题查看答案