覆蓋率可以
不過答案不是很准確
What are two benefits of making recovery operations parallel? (Choose two)
Answer: Recovering more than one data file
With the instance down
how would you recover a lost control file?
Answer: Use the CREATE CONTROLFILE command
You are restoring a backup data file to a different location
To recover
successfully
what must you do?
Answer: Use the ALTER DATABASE command to rename the data file
Which two benefits does the command ALTER DATABASE MOUNT
CLOSE DATABASE offer for the tablespace point
in
time recovery?
(Choose two)
Answer: It prevents accidental corruption of the primary database
It allows you to remove a data file that has been added to the wrong tablespace
Which statement about
cancel
based recovery
is true?
Answer: Recovery is stopped by entering CANCEL at the recovery prompt
A media management layer is always used when Recovery Manager
________
Answer: Performs media recovery
Why would you set a data file offline when the database is in MOUNT state?
Answer: To allow for automatic data file recovery
When configuring a database in ARCHIVELOG mode and enabling automatic archiving
the database must be shut down and opened in the MOUNT stage
Which three options can be used to do this? (Choose Three)
Answer: SHUTDOWN NORMAL AND STARTUP MOUNT
SHUTDOWN IMMEDIATE AND STARTUP MOUNT
SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT
When configuring a database in ARCHIVELOG mode and enabling automatic archiving
the database must be shut down and opened in the MOUNT stage
Which two options should not be used to do this? (Choose two)
Answer: STARTUP FORCE MOUNT
SHUTDOWN ABORT and STARTUP MOUNT
What is the correct procedure for multiplexing existing online redo logs?
Answer: Issue the ALTER DATABASE
ADD LOGFILE MEMBER command
In the view V$DATAFILE_HEADER
what does value
YES
in the
FUZZY
column as specified?
Answer: The data file is in backup mode
During an opened database backup
a power failure occurs
Which SQL statement do you issue to resolve this situation after mounting the database?
Answer: ALTER DATABASE DATAFILE n END BACKUP
You perform an incomplete recovery using RMAN
You write the following
script:
RUN{
SET UNTIL TIME =
yyyy
nm
dd:hh:mi:ss
;
RESTORE DATABASE;
RECOVER DATABASE;
SQL
alter database open resetlogs
;}
Which command is missing?
Answer: RELEASE CHANNEL
Which statement regarding Recovery Manager with a database operating in
NOARCHIVELOG mode is true?
Answer: Recovery Manager supports multi
level incremental backups
After rebuilding the recovery catalog by resynchronizing it with a copy of the backup control file
you notice references to files that no longer exist
Which CRETAE command clause should you use to remove these references?
Answer: UNCATALOG
When configuring a database for ARCHIVELOG mode
you use initialization parameter to specify which two actions? (Choose two)
Answer: Where log files will be archived
The names that will be given to archived log files
A tablespace becomes unavailable because of a failure
The database is
running in NOARCIVELOG mode? What should the DBA do to make the database available?
Answer: Restore the data files
redo log files
and control files from an earlier copy of a full database backup
In which situation would you need to create a new control file for an existing
database?
Answer: When MAXLOGMEMBERS needs to be changed
Why would a DBA load a table using the NOLOGGING options?
Answer: To reduce redo during a direct loaded operation
Which technique does Oracle use to perform full backups of data files?
Answer: The server process reads the entire file and skips blocks that have never
been used
Which statement regarding the allocation of processes to Recovery Manager is true?
Answer: Setting BACKUP_TAPE_IO_SLAVES=TRUE will enable a dedicated
slave to write to a tape device
What is the effect of issuing an ALTER DATABASE OPEN RESETLOGS command on the primary database?
Answer: It invalidates the standby database
In order to keep a standby database up
to
date
archived redo
log files need
to be transferred from the primary to the standby server
What are two ways
to do this? (Choose two)
Answer: Specify LOG_SARCHIVE_DEST_n on the standby database
When configuring a database for ARCHIVELOPG mode
you use an initialisation parameter to specify which action?
Answer: That the database is in ARCHIVELOG mode
You have just created a script in Recovery Manager
After noticing an error
in the script
you decide to recreate it
Which command replaces the stored script in the recovery catalog?
Answer: REPLACE_SCRIPT
When two or more databases are backed up using RMAN
is it appropriate
to use each database as the other
s recovery catalog? Why?
Answer: No
A database that contains a catalog cannot be target database
What is the advantage of managed recovery mode?
Answer: The standby database automatically applies the archived redo log when the
files become available
Which import option do you use to create tables without data?
Answer: ROWS
Which statement is true when using the LogMiner utility?
Answer: The dictionary file is created in a directory as defined as defined by
UTL_FILE_DIR
The developers have implemented parallel DML operations
How can a DBA
make sure that the archiving process is able to keep up with archiving the redo
log files?
Answer: Spawn multiple database writers
Which action does Oracle recommend after a DBA recovers from the loss of
the current online redo
log?
Answer: Back up the instance
Back up the control file
What is the last step when setting up a recovery catalog?
Answer: Run the REGISTER DATABASE command
What is the difference between using NOLOGGING operations in a single
database environment and a standby database environment?
Answer: NOLOGGING operations can be used on the standby database
but not on the primary database
What is the function of SMON in instance recovery?
Answer: It roles forward by applying changes in the redo log
What are two causes of user errors? (Choose two)
Answer: Incorrect data is committed
A table is accidentally truncated
Which statement is true when using the DELIVERY utility to detect corruptions in an Oracle data block?
Answer: The utility can be used to verify the data files of a backup database
The alert log can contain specific information about which database backup activity?
Answer: Placing tablespace in begin and end backup mode
In which two situations would you have to apply redo information to a read
only
tablespace? (Choose two)
Answer: When the tablespace being recovered is writeable
but was read
only when the last backup occurred
When the tablespace being recovered is read
only
but was writeable when the last backup occurred
Your database is configured in ARCHIVELOG mode
Which three types of
backups can be performed? (Choose three)
Answer: Open database backups
Operating system back
From:http://tw.wingwit.com/Article/program/Oracle/201311/18673.html
