A backup is taken using the following command:tar -cvf abcdef.tar /usr/local/include/tcpd.h The operator is in the directory /usr/local/restores and runs the following command: tar -xvf abcdef.tar. Where will the file be restored?()
第1题:
You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()
第2题:
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()
第3题:
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()
第4题:
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
第5题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
第6题:
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database,the database will not be opened.
第7题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
第8题:
recover using Oracle Flashback Database technology
restore the data files from backup and perform a complete recovery
restore only the corrupted data file and perform tablespace recovery
restore the data files from backup and perform cancelbased recovery
restore the entire database from the most recent backup and start the instance and open the database
第9题:
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed
Using this command to create backups improves the performance of the backup process
第10题:
Restore using the tapes from Friday, Saturday, Sunday, Monday and Wednesday.
Restores using only Fridays tape
Restore using the tapes from Thursday, Friday, Saturday, Sunday and Tuesday.
Restore using the tapes from Friday and Tuesday.
Restore using the tapes from Tuesday and Thursday.
第11题:
Take a snapshot of each VM, and then run a full backup of the Hyper-V hosts by using Windows Server Backup.
Shut down the VMs,and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.
From each VM,run a full backup by using Windows Server Backup, and then run a full backup of the Hyper-V hosts by using Windows Server Backup.
From each VM,run a full backup by using Windows Server Backup. Shut down the VMs, and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.
第12题:
The target database must be in the MOUNT mode to ensure restoration of the datafiles.
You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
The control file must be recreated.
The database must be opened with the RESETLOGS option.
第13题:
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?()
第14题:
Examine the following RMAN command: BACKUP DATABASE TAG TESTDB KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06; Which two statements are true regarding the backup taken by using the above RMAN command?()
第15题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).
第16题:
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()
第17题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
第18题:
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
If you restart the database, the database will not be opened.
第19题:
backup database all
backup compressed database
backup as compressed backupset database
backup as compressed backup database plus archivelog all
backup as compressed backupset database plus compress archivelog all
第20题:
Only data files and the control file are backed up.
Archived redo logs are backed up only if the database is open during the backup.
The backup is deleted after one day,regardless of the default retention policy settings.
The backup becomes obsolete after one day,regardless of the default retention policy settings.
第21题:
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.
第22题:
Restore the USERS01.dbf file from the backup, and open the database using the STARTUP command.
Restore the USERS01.dbf file using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
Restore the USERS01.dbf file from the backup, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then, recover the USERS tablespace using the RECOVER TABLESPACE command, and open the database using the ALTER DATABASE OPEN statement.
第23题:
The data file backup is done with multiple channels
The data files is in the read-write mode after being backed up in the read only mode
The backup was taken after the data files was taken offline-normal or is in the read only mode
The data file backup complies with the back retention policy and the backup duplexing feature
第24题:
The data file backup is done with multiple channels
The data files is in the read-write mode after being backed up in the read only mode
The backup was taken after the data files was taken offline-normal or is in the read only mode
The data file backup complies with the back retention policy and the backup duplexing feature