최신 Oracle Database 11g 11gocmu 무료샘플문제:
1. What is the purpose of the catalog command?
A) To create metadata in the control file and the recovery catalog related to backup set pieces
B) To create a report that lists database backups
C) To rebuild the recovery catalog
D) To review RMAN control file and recovery catalog metadata and ensure that it's correct
E) To delete RMAN backup-related metadata from the recovery catalog
2. What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?
A) The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
B) The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
C) An upper limit on how far you can flash back the database, depending on the information in the redo logs
D) An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
3. Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?
a.shutdown immediate from RMAN
b.Log into RMAN
c.startup mount from RMAN
d.backup database
e.alter database open
f.backup database plus archivelog delete input
A) b, a, c, f, e
B) a, c, e, d
C) b, c, a, d, e
D) b, a, c, e, f
E) b, a, c, d, e
4. Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?
A) a cumulative level 1 backup
B) a differential level 1 backup
C) a whole backup
D) a full backup
5. You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?
a.Mount the database with the startup mount command.
b.Take the SYSTEM datafile offline with the alter database command.
c.Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
d.Restore all SYSTEM tablespace-related datafiles from backup media.
e.Issue the recover tablespace SYSTEM command.
f.Issue the recover datafile SYSTEM_01.dbf command.
g.Open the database with the alter database open command.
h.Open the database with the alter database open resetlogs command.
A) a, b, c, f, g
B) d, a, e, g
C) b, c, f, e, g
D) a, c, f, g
E) b, d, e, h
질문과 대답:
질문 # 1 정답: A | 질문 # 2 정답: A | 질문 # 3 정답: E | 질문 # 4 정답: A | 질문 # 5 정답: B |