Which of the following best describes a full backup? ()
第1题:
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement: SQL> DROP TABLE SCOTT.EMP PURGE; After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()
第2题:
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
第3题:
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement: SQL>ALTER DATABASE OPEN RESETLOGS; Which of the following options is true about using the RESETLOGS option?()
第4题:
What is the result of this command?() RMAN> Report need backup days 3;
第5题:
Why would you execute the report obsolete command?()
第6题:
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)
第7题:
All datafiles of a database
All datafiles, archive logs, and control files
All datafiles and control files
All the used blocks in a datafile
第8题:
Corrupted blocks, if any, are repaired.
Checks are performed for physical corruptions.
Checks are performed for logical corruptions.
Checks are performed to confirm whether all database files exist in correct locations
Backup sets containing both data files and archive logs are created.
第9题:
when all the control files are missing and only a binary backup of the current control file exists
when a multiplexed copy of the current control file is missing
when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
when the SPFILE is missing
第10题:
The log sequence is reset to 0.
All the online redo logs are deleted.
All the archived redo logs from a previous incarnation become useless.
The full database backup taken from a previous incarnation can be used in future.
Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
第11题:
RECOVER DATABASE;
SWITCH DATAFILE ALL;
RESTORE CONTROL FILE;
RECOVER DATABASE USING BACKUP CONTROL FILE;
第12题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
第13题:
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)
第14题:
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()
第15题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
第16题:
In which scenario will you issue the following command?() SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;
第17题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第18题:
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?()
第19题:
Restore all the datafiles from the backup.
Restore only the lost datafile from the backup.
Restore all the datafiles for the lost tablespace from the backup.
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
第20题:
This operation resets the SCN for the database.
This operation creates a new incarnation of the database.
This operation moves all the redo log files to a different location.
This operation deletes the old redo log files and creates new redo log files.
This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
第21题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
第22题:
the datafiles associated with the SYSTEM tablespace
the datafiles associated to the DATA1 tablespace
the datafiles associated to the SYSTEM and DATA1 tablespaces
all the datafiles in the database
第23题:
Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
Datafiles are not written to during hot backups.
Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
The datafile headers are not updated during the backup.
The way data is written to the online redo logs is unchanged during the backup.