单项选择题
You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement:
SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400;
What is the outcome of this statement? ()
A. The statement will not execute successfully.
B. The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 days
C. The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.
D. Backups will be deleted from the media after 400 days.
相关考题
-
单项选择题
YouaremaintainingyourdatabaseinOracle10g.Youarenotusingtherecoverycatalogtomaintainthebackupinformationofyourdatabase.WhichfilecanbeusedasarepositorytostoreinformationregardingtheRMANbackup?()
A. online redo log files
B. alert log files
C. control file
D. datafiles associated with the SYSTEM tablespace -
多项选择题
IdentifyfourusesoftheOracleScheduler.()
A. enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
B. enables Oracle database to do patches according to a DBA-defined schedule
C. enables you to schedule the execution of jobs based on time
D. enables you to execute jobs in a clustered environment
E. enables you to periodically execute operating systemscript files located on the same server as the database
F. enables you to create a job that makes use of saved programs and schedules
G. enables you to automate the management of the jobs that are created using the DBMS_JOB package -
多项选择题
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()
A. The database is in NOMOUNT state.
B. The database is in NOARCHIVELOG mode and the tablespace is online.
C. The database is in NOARCHIVELOG mode and the tablespace is offline.
D. The database is in ARCHIVELOG mode and the tablespace is offline.
E. The database is in ARCHIVELOG mode and the tablespace is online.
