True
False
第1题:
Which RMAN backup command is used to create the block-change tracking file?()
第2题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第3题:
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?() a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.
第4题:
Which is the correct command to put the database in ARCHIVELOG mode?()
第5题:
RECOVER DATABASE;
SWITCH DATAFILE ALL;
RESTORE CONTROL FILE;
RECOVER DATABASE USING BACKUP CONTROL FILE;
第6题:
Issue the grant command from the SYS user (or equivalent) of the target database.
Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
Issue the grant command from RMAN when connected to the target database.
第7题:
The script is stored only in the control file.
The script is stored only in the recover catalog.
The script can be executed only by using the RMAN RUN command.
The commands of the script can be displayed with the LIST command.
The commands of the script can be displayed with the PRINT command.
The commands of the script can be displayed with the REPORT command.
第8题:
Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
Issue the restore spfile from autobackup command from the RMAN prompt.
第9题:
a, b, c, d, e, f
c, d, a, b, f
d, c, a, b, f
d, b, d, c, e
d, c, a, b, e
第10题:
RMAN recovers up to log sequence 230, but not including 230.
RMAN returns an error because the log sequence number mentioned in the command should be 229.
RMAN returns an error because the log sequence number mentioned in the command may never be missing.
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
第11题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第12题:
’SQL ALTER DATABASE OPEN’;
SQL ALTER DATABASE ’OPEN’;
OPEN DATABASE;
DATABASE OPEN
第13题:
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?() a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN.
第14题:
After the recovery is complete, which command should you execute?()
第15题:
Which command will result in a trace file being created with the create controlfile command contained in it?()
第16题:
alter database open
alter database open repairlog
alter database open resetlogs
alter database open resetlog
alter database resetlogs open
第17题:
a, b, c, d, e, f, g
b, c, d, g, f, e, a
g, f, a, b, c, e, d
c, a, d, b, f, e, g
g, f, a, b, e, c, d
第18题:
Flashback logs are not deleted.
Flashback logs are deleted automatically.
Flashback logs are deleted only if you are using Recovery Manager (RMAN)
Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
Flashback logs are deleted only if you are using Automatic Storage Management (ASM)
第19题:
shutdown restore datafile 4; recover datafile 4; alter database open;
Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;
Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;
Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4;Sql alter database datafile 4 online;
Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;
第20题:
alter database backup controlfile
alter database backup controlfile to trace
alter database controlfile backup
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
alter database begin controlfile backup
第21题:
alter database create block change tracking file
alter database enable block change file
alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil
alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
alter system block change tracking on
第22题:
Flashback logs are not deleted.
Flashback logs are deleted automatically.
Flashback logs are deleted only if you are using Recovery Manager (RMAN).
Flashback logs are deleted only if you are using Oracle Managed Files (OMF).
Flashback logs are deleted only if you are using Automatic Storage Management (ASM).
第23题:
The alter database archivelog command will fail
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode
The alter database archivelog command will succeed
The alter database archivelog command will ask if you want to make the database consistent first
There is no alter database archivelog command. The correct command is alter database alterlogging