[单选]
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（）

A . The commands execute successfully.
B . Command 6 produces an error because of circular role grant.
C . Command 5 produces an error because a role cannot be granted to another role.
D . Command 3 produces an error because the MGRROLE role already contains system privileges.
E . The table created by HR remains and HR still has the CREATE TABLE system privilege.
F . The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

Data files of which three tablespaces can be recovered by performing an open recovery？（） TEMP。 UNDO。 INDEX。 SYSAUX。 SYSTEM。充装量：气瓶内充装的气体（）重量。体积。容积。 You issue the following statement： SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（） by using the DBMS_REPAIR package。 by using the DBVERIFY utility。 by using Block Media Recovery。 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command。 The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（） statistics recommendations。 SQL profile recommendations。 index-related recommendations。 restructuring of SQL recommendatio。资产评估的现实性表现在（）。资产评估是在当前条件下进行的。资产评估以现实存在的资产作为估价的依据。资产评估强调客观存在。资产评估以现实状况为基础反映未来。资产评估是客观的。

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

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-052题库

相关题目: