單項選擇題

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（）

A.The table created by SKD isnot accessibleand 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.

你可能感興趣的試題

單項選擇題

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：
SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；
Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

A.The command fails because SCOTT still has privileges.
B.The command succeeds and privileges are revoked from JIM.
C.The command fails because HR cannot revoke the privileges from JIM.
D.The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

單項選擇題

View the Exhibit and examine the privileges granted to the MGR_ROLE role.

The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the user SKD by executing the command： SQL> GRANT MGR_ROLE TO SKDWITH ADMIN OPTION；
Which statement is true about the user SKD after he/she is granted this role（）

A.The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.
B.The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C.The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.
D.The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privileges from them.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久