A.data files B.control files C.parameter file D.online redo log files E.server parameter file
单项选择题You are using Enterprise Manager to schedule backups for your database. Which type of script wouldbe generated by the backup scheduler()
A.XML script B.PL/SQL script C.Operating system script D.Recovery Manager (RMAN) script
多项选择题You are managing an Oracle Database 11g database with the following backup strategy: 1.On Sunday, an incremental level 0 tape backup is performed. 2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed. Which two statements are true regarding the backups performed()
A.The backup performed in step 1 backs up all blocks that have ever been in use in the database. B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup. C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup. D.The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1.
单项选择题You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true()
A.The backup contains all the used blocks. B.The backup contains all the used and unused blocks. C.The backup contains blocks that have changed since the last level 0 backup. D.The backup contains blocks that have changed since the last level 1 backup taken last week.
多项选择题You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape. Which two statements are true about differential incremental backups()
A.The backup performed on Sundays contains all the blocks that have ever been used in the database. B.The backup performed on Sundays contains all the blocks that have changed since the last level 1backup. C.The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup. D.The backup performed on Monday contains all the blocks that have changed since the level 0 backup,and every other working day contains all the blocks that have changed since the level 1 backup.
多项选择题You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
A.You can perform consistent backups only. B.You can perform a complete database backup without shutting down the database instance. C.You can back up data files only when all data files have the same SCN recorded in the control file. D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.