Segment Advisor
SQL Access Advisor
Optimizer statistics gathering
Automatic SQL Tuning Advisor
Automatic Database Diagnostics Monitor
第1题:
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
第2题:
A.Finding queries that are not using indexes
B.Finding rows that are locked by InnoDB
C.Finding client connection attributes
D.Finding the part of a code in which a single query is spending time
E.Finding the size of each table
第3题:
A. A DBA can enable or disable an individual task in all maintenance windows.
B. A DBA cannot change the duration of the maintenance window after it is created.
C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
第4题:
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()
第5题:
Which statement is true regarding Backup tasks in Cisco UCS?()
第6题:
A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
第7题:
第8题:
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 recommendations
第9题:
Which three statements correctly describe the features of the I/O calibration process?()
第10题:
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)