单项选择题

A.The command executes successfully and creates the table in the USERS tablespace.
B.The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C.The command produces an error because the user does not have the privilege to create the table.
D.The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.

相关考题

单项选择题 You want to create a role to meet these requirements:  1:The role is to be protected from unauthorized usage.  2:The password of the role is not to be embedded in the application source code or stored in a table.  Which method would you use to restrict enabling of such roles()

单项选择题 Examine the commands executed in the following sequence:  1:SQL> CREATE ROLE mgrrole;  2:SQL> GRANT create user,select any table,connect,resource TO mgrrole;  3:SQL> GRANT select,update ON sh.sales TO mgrrole;  4:SQL> CREATE ROLE ceo IDENTIFIED BY boss;  5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo;  6:SQL> GRANT ceo TO mgrrole;  Which statement is true about the above commands()

单项选择题 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()