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
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.
A. True
B. False
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. Database Datafiles
B. Database Control Files
C. Online redo logs
D. Archived redo logs
E. The database SPFILE
F. None of the above,all these files are backed up
A. The tuned plan is not added to the SQL plan baseline.
B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
What is the end result of these commands if they are successful?()
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name
ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag=gold_copy plus archivelog tag=gold_copy delete input; Backup
database tag=silver_copy plus archivelog tag=silver_copy delete input;
A. Attempting to restore silver_copy will fail.
B. Attempting to restore gold_copy will fail.
C. Both backups will be available for restore without question.
D. Attempting to restore gold_copy may or may not succeed.
E. You will not be able to restore either gold_copy or silver_copy.
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
最新试题
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()
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?()
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?()
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM). Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()
Which three tasks can be performed using a duplicate database?()
Which three functions are performed by the SQL Tuning Advisor?()
Which three statements are true about windows?()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()