4、You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays.
Which two statements are true about the differential incremental backups?(choose two)
A.The backup performed on Sundays contains all the blocks that have ever been use in the database.
B.The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
C.The backup performed on each working day contains all the blocks that have changed since the last level 0 or level 1 backup.
D.The backup performed on each working day contains all the blokcs that have changed since the last level 0 backup.
level 0相当于一种特殊的增量备份.
level 0就相当于全备,但是0级备份不等于全备.其中全备不能作为增量备份的基础,而0级备份则可以作为增量备份的基础.
0级备份的定义(全备),就是:The backup performed on Sundays contains all the blocks that have ever been use in the database.
5、According to your backup strategy,you performed an incremental level 0 backup of your database.Which statement regarding this backup is true?
A.The backup is similar to image copy.
B.The backup contains all used data blocks.
C.The backup contains only unused data blocks.
D.The backup contains all data blocks changed since the last incremental level 1 backup.
9、You executed the following command to back up your control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which initialization parameter is used to specify the location of the trace file?
A.USER_DUMP_DEST
B.CORE_DUMP_DEST
C.TRACE_DUMP_DEST
D.BACKUP_DUMP_DEST
E.BACKGROUND_DUMP_DEST
Your database is configured in NOARCHIVELOG mdoe.All the control files have been lost due to a hard disk failure bu the data files are not lost.You have the closed whole database backup available to you.
那么这种情况下,你能否重构数据文件呢?答案不能.因为数据库时处于非归档模式下.
10、Your database is configured in NOARCHIVELOG mode.All the control files have been lost due to a hard disk failure but the data files are not lost.You have closed whole database backup availbale to you.
Which two statements are true in this scenario?(Choose two)
A.the instance aborts.
B.The database cannot be recovered.
C.The database can be recovered by restoring the control files from the backup.(时间点不一致,无法通过拷贝方式,直接使用控制文件)
D.The database remains opened and you have to shut it down with the ABORT option.
E.The database can be restored till the point of the last closed whole database backup.
11、In your database,the Log Writer(LGWR)process is unable to write to a member of a current redo log group due to read/write failure.Which two effects would you see in your database?(Choose two)
A.the database instance aborts.
B.the database operation temporaily halts till the member becomes available.
C.Writing proceeds as normal.LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.