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
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.
最新试题
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）
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？（）
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL> ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE 5. Open the database： SQL> ALTER DATABASE OPEN； Choose the correct sequence.（）
Which two statements are true about a job chain？（）
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？（）
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？（）
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（）
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？（）
Examine the following RMAN command： RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG； Which prerequisite must be met before accomplishing the backup？（）