A. It updates the existing SQL profiles with current statistics.
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
您可能感兴趣的试卷
你可能感兴趣的试题
You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?()
a. restore controlfile until time `09/30/2008:18:00:00’
b. restore database until time `09/30/2008:18:00:00’
c. restore spfile until time `09/30/2008:18:00:00’
d. recover database until time `09/30/2008:18:00:00’
e. alter database open resetlogs
f. alter database open
A. b, d, e
B. b, d, f
C. c, a, b, d, e
D. c, a, b, d, f
E. a, b, d, e
A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
D. Either B or C
E. All of the above
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true?()
A. The command restores only the missing control file.
B. The command restores all the control files.
C. The command fails because the database is running.
D. This is the correct way to address this problem.
E. This is not the correct way to address this problem.
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor
What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?()
a. sql ’alter database datafile 4 online’
b. restore datafile 4
c. recover datafile 4
d. sql ’alter database datafile 4 offline’
e. startup
f. shutdown
A. a, c, b, d
B. d, b, c, a
C. f, d, b, c, a, e
D. c, a, b, d, f
E. a, b, d, e
A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor
A. A single SQL statement provided by a user
B. An existing SQL Tuning Set (STS)
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources
最新试题
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?()
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?()
Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2; In which situation would you use this method of disk group creation?()
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()