当前位置:1Z0-053题库

问题:

[单选] 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?()

A .  statistics recommendations
B .  SQL profile recommendations
C .  index-related recommendations
D .  restructuring of SQL recommendatio

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。 一般适应综合症的反应分为三个时期:()、()和()。 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() The commands execute successfully.。 Command 6 produces an error because of circular role grant.。 Command 5 produces an error because a role cannot be granted to another role.。 Command 3 produces an error because the MGRROLE role already contains system privileges.。 The table created by HR remains and HR still has the CREATE TABLE system privilege.。 The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.。 Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.) You can use RMAN stored scripts。 Recovery is faster if data is stored in catalog in addition to the control file。 You can store backup information of all registered databases in one place。 Database backups are automatically deleted when they are older than the specified time period。 ()为财务费用。 保险费。 利息净支出。 差旅费。 工资。 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?()
参考答案:

  参考解析

本题暂无解析

在线 客服