多选题Which two are characteristics of user-managed backup and recovery operations?()ARecovery is initiated using SQL*Plus.BDatabase files are backed up using SQL commands.CDatabase files are backed up with Recovery Manager.DDatabase files are restored using Recovery Manager.EDatabase files are backed up using operating system commands.
多选题
Which two are characteristics of user-managed backup and recovery operations?()
A
Recovery is initiated using SQL*Plus.
B
Database files are backed up using SQL commands.
C
Database files are backed up with Recovery Manager.
D
Database files are restored using Recovery Manager.
E
Database files are backed up using operating system commands.
参考解析
解析:
暂无解析
相关考题:
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.() A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tablespaces are required to be in backup mode before taking the backup.D. The tablespaces are required to be in read-only mode before taking the backup
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two). A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database
Which two characteristics describe the UDP protocol?()A、limited error checkingB、defined timersC、no recovery mechanismsD、three-way handshake
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform?() A、 standard backup setB、 image copyC、 compressed backupD、 user-managed backup
Which two of these are characteristics of Metro Ethernet? ()A、class of serviceB、bandwidth profilesC、user-network interfaceD、Ethernet LAN circuit attributesE、Ethernet virtual circuit attributes
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?() A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
In which scenario will you perform a cancel-based recovery?()A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)A、Backup compression should be enabledB、Parallelism for the channel should be set to 2C、All the files must be backed up as backup setsD、The backup may be stored either on disk or on media with media manager
Which two are characteristics of user-managed backup and recovery operations?()A、Recovery is initiated using SQL*Plus.B、Database files are backed up using SQL commands.C、Database files are backed up with Recovery Manager.D、Database files are restored using Recovery Manager.E、Database files are backed up using operating system commands.
You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)A、The KEEP option overrides the configured retention policyB、The KEEP option is an attribute of an individual backup pieceC、The backup contains only data files and archived redo log filesD、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).A、The backup as copy can only be taken to diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()A、 RMAN image copies.B、 RMAN database backups.C、 RMAN tablespace backups.D、 User-managed backups placed in the flash recovery area.E、 User-managed backups that have been cataloged with RMAN.F、 User-managed data file backups for which the pull path name is specified.
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()A、The backup as copy can only be taken to diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database
Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery?()A、Online backups.B、Skipping unused block. C、Partial database backups.D、Incremental block-level backup.E、Detection of corrupted blocks during backup.
You want to perform a backup of your database to tape. Which backup format can you use?()A、backup set onlyB、image copy onlyC、only user-managed backupD、both image copy and backup setE、only incremental image copy backup
单选题In which scenario will you perform a cancel-based recovery?()A when a tablespace is dropped and you have only RMAN-based backup of the databaseB when a table is dropped and stored in the Recycle BinC when you are required to recover an existing table to its previous stateD when a tablespace is dropped and you have only a user-managed full backup of the database
单选题You want to perform a backup of your database to tape. Which backup format can you use?()Abackup set onlyBimage copy onlyConly user-managed backupDboth image copy and backup setEonly incremental image copy backup
多选题You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.()AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup
多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’; Which two statements are true regarding the backup created using this command?()AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.
多选题You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)AThe KEEP option overrides the configured retention policyBThe KEEP option is an attribute of an individual backup pieceCThe backup contains only data files and archived redo log filesDThe backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database
单选题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform?()A standard backup setB image copyC compressed backupD user-managed backup
多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager
多选题Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery?()AOnline backups.BSkipping unused block.CPartial database backups.DIncremental block-level backup.EDetection of corrupted blocks during backup.
多选题Which two characteristics describe the UDP protocol?()Alimited error checkingBdefined timersCno recovery mechanismsDthree-way handshake
多选题Which two of these are characteristics of Metro Ethernet? ()Aclass of serviceBbandwidth profilesCuser-network interfaceDEthernet LAN circuit attributesEEthernet virtual circuit attributes