156.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 user creates a table.
3: The SKD user grants the CREATE TABLE 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?
A.The table created by SKD is not accessible and SKD cannot create new tables.
B.The tables created by SKD and HR remain, but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
答案:C
解析:
A:错误,由于dba已经收回了skd的create table的权限,因此skd不能在create table,但是已经创建的table是不受影响的,因此前半句是错误的
B:错误,sdk不能create table了,但是hr是不受影响的
C:正确,这里都是dba对skd操作的,并没有对hr进行任何操作
D:错误,skd只给了hr用户create table的权限,并没有 with adin option因此hr不可以将create table授予其他用户
1: The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2: The SKD user creates a table.
3: The SKD user grants the CREATE TABLE 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?
A.The table created by SKD is not accessible and SKD cannot create new tables.
B.The tables created by SKD and HR remain, but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
答案:C
解析:
A:错误,由于dba已经收回了skd的create table的权限,因此skd不能在create table,但是已经创建的table是不受影响的,因此前半句是错误的
B:错误,sdk不能create table了,但是hr是不受影响的
C:正确,这里都是dba对skd操作的,并没有对hr进行任何操作
D:错误,skd只给了hr用户create table的权限,并没有 with adin option因此hr不可以将create table授予其他用户