Which package provides API’s for the SQL Tuning Advisor?()
A、 DBMS_MONITOR
B、 DBMS_STATS
C、 DBMS_SQLTUNE
D、 DBMS_ADVISOR
A、 DBMS_MONITOR
B、 DBMS_STATS
C、 DBMS_SQLTUNE
D、 DBMS_ADVISOR
A、It cannot be created without a package specification. B、It cannot invoke subprograms defined in other packages. C、It can contain only the subprograms defined in the package specification. D、It can be changed and recompiled without making the package specification invalid.
A、import Package1.*; B、import Package1.Package2.*; C、import Package2.*; D、import Package2.Package1.*;
A、 Enterprise Manager GUI B、 DBMS_TRACE package APIs C、 DBMS_ADVISOR package APIs D、 DBMS_MONITOR package APIs E、 $ORACLE_HOME/rdbms/admin/addmrpt.sql script
A、The DBMS_JOB package B、The BACKUP_JOB package C、The DBMS_BACKUP_RESTORE package D、The calendar tool in the Operating System (OS) E、The backup scheduler in Enterprise Manager (EM) F、The DBMS_BACKUP_SCHEDULER packager inline mode
A、use enterprise manager B、use DBMS_SQL package C、use DBMS_AWR package D、use PRVT_WORKLOAD package E、query the AWR snapshot repository objects F、use DBMS_WORKLOAD_REPOSITORY package
A、use enterprise manager B、use DBMS_SQL package C、use DBMS_AWR package D、use PRVT_WORKLOAD package E、query the AWR snapshot repository objects F、use DBMS_WORKLOAD_REPOSITORY package
A、You can add SQL test cases to the incident package. B、You can add or remove the trace files to the package. C、You cannot create an incremental incident package when the physical files are purged from the ADR. D、You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.
A、You can add SQL test cases to the incident package. B、You can add or remove the trace files to the package. C、You cannot create an incremental incident package when the physical files are purged from the ADR. D、You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.