1. When would a DBA need to perform a media
recovery?
A. After instance failure occurs.
B. After abnormal termination of client program.
C. After the failure of an Oracle background process.
D. After the database is shutdown by using SHUTDOWN TRANSACTIONAL.
E. When a data file is not synchronized with the other data files, redo logs, and control files.
correct answer: e
2. Why would you set a data file offline when the database is in MOUNT state?
A.To minimize downtime.
B.To allow for automatic data file recovery.
C.To prevent further corruption of a damaged data file.
D.To recover it later, when database is in NOARCHIVELOG mode.
correct answer: b
3. What is the causes of media failures?
A.The server computer loses power.
B.A table is accidentally truncated.
C.The user issues an abnormal interrupt.
E.There is a logic error in the application.
F.There is a head crash on the disk containing a database file.
correct answer: f
4. Which of the following would not require you to perform an incomplete recovery?
A. Instance failure
B. Missing archived redo log files during a media recovery
C. Loss of all copies of the control file
D. Media failure in a user tablespace in ARCHIEVELOG mode
correct answer: a
5. In what scenario you have to open a database with reset logs option?
A. Rename Database
B. Point in time recovery
C. All of the above
correct answer: c
6. Is it possible take consistent backup if the database is in NOARCHIVELOG mode?
A. Yes
B. No
correct answer: a
7. Database is in Archivelog mode and Loss of unbackedup datafile is__?
A. Complete Online Recovery
B. Incomplete Recovery
C. Complete Offline recovery
correct answer: a
8. You should issue a backup of the control file after issuing which command?
A. ALTER TABLE
B. CREATE TABLE
C. CREATE TABLESPACE
D. CREATE ROLLBACK SEGMENT
correct answer: c
9. The alert log will never contain specific information about which database backup activity) ?
A. Placing tablespaces in begin backup mode.
B. Shutting the database down with an ABORT.
C. Performing an operating system backup of the database files.
D. Changing the database backup mode from ARCHIVELOG to NOARCHIVELOG
correct answer: c
A. After instance failure occurs.
B. After abnormal termination of client program.
C. After the failure of an Oracle background process.
D. After the database is shutdown by using SHUTDOWN TRANSACTIONAL.
E. When a data file is not synchronized with the other data files, redo logs, and control files.
correct answer: e
2. Why would you set a data file offline when the database is in MOUNT state?
A.To minimize downtime.
B.To allow for automatic data file recovery.
C.To prevent further corruption of a damaged data file.
D.To recover it later, when database is in NOARCHIVELOG mode.
correct answer: b
3. What is the causes of media failures?
A.The server computer loses power.
B.A table is accidentally truncated.
C.The user issues an abnormal interrupt.
E.There is a logic error in the application.
F.There is a head crash on the disk containing a database file.
correct answer: f
4. Which of the following would not require you to perform an incomplete recovery?
A. Instance failure
B. Missing archived redo log files during a media recovery
C. Loss of all copies of the control file
D. Media failure in a user tablespace in ARCHIEVELOG mode
correct answer: a
5. In what scenario you have to open a database with reset logs option?
A. Rename Database
B. Point in time recovery
C. All of the above
correct answer: c
6. Is it possible take consistent backup if the database is in NOARCHIVELOG mode?
A. Yes
B. No
correct answer: a
7. Database is in Archivelog mode and Loss of unbackedup datafile is__?
A. Complete Online Recovery
B. Incomplete Recovery
C. Complete Offline recovery
correct answer: a
8. You should issue a backup of the control file after issuing which command?
A. ALTER TABLE
B. CREATE TABLE
C. CREATE TABLESPACE
D. CREATE ROLLBACK SEGMENT
correct answer: c
9. The alert log will never contain specific information about which database backup activity) ?
A. Placing tablespaces in begin backup mode.
B. Shutting the database down with an ABORT.
C. Performing an operating system backup of the database files.
D. Changing the database backup mode from ARCHIVELOG to NOARCHIVELOG
correct answer: c
0 comments:
Post a Comment