网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup?()
A
ABORT
B
NORMAL
C
IMMEDIATE
D
TRANSACTIONAL
参考答案
参考解析
解析:
暂无解析
更多 “多选题You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup?()AABORTBNORMALCIMMEDIATEDTRANSACTIONAL” 相关考题
考题
You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler()A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from = http://www.amaderforum.comD、Recovery Manager (RMAN) script
考题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup
考题
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()A、Only the data files.B、Only the data files and the online logs.C、The data files, control files, and the online logs.D、The data files and control files, but not the online logs.
考题
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this? ()A、The DBMS_JOB packageB、The BACKUP_JOB packageC、The DBMS_BACKUP_RESTORE packageD、The calendar tool in the Operating System (OS)E、The backup scheduler in Enterprise Manager (EM)F、The DBMS_BACKUP_SCHEDULER packager inline mode
考题
Which two file types must be included in a closed database backup taken with operating system commands?()A、data filesB、control fileC、password fileD、online redo log filesE、initialization parameter file
考题
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()A、 The backup will not be performed at all.B、 three timesC、 four timesD、 six times
考题
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 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?()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
考题
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?() A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
考题
You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? ()A、SQL scriptB、PL/SQL scriptC、Operating System (OS) scriptD、Enterprise Manager (EM) scriptE、Recovery Manager (RMAN) script
考题
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?() A、 Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.
考题
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()A、until SCNB、until timeC、until cancelD、using backup control file
考题
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
考题
You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup?()A、ABORTB、NORMALC、IMMEDIATED、TRANSACTIONAL
考题
You are performing a backup of your database across the network. While taking the backup, you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup?()A、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET;B、 CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY;C、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET;D、 CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY;
考题
单选题You are using Enterprise Manager to schedule backups for your database. Which type of script wouldbe generated by the backup scheduler()A
XML scriptB
PL/SQL scriptC
Operating system scriptD
Recovery Manager (RMAN) script
考题
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A
Hot backupB
Online backupC
consistent backupD
incremental backupE
inconsistent backup
考题
多选题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? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
考题
多选题Which two file types must be included in a closed database backup taken with operating system commands?()Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file
考题
单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A
The backup status will be marked expired in RMAN recovery catalog.B
The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C
The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
考题
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
考题
单选题You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()A
SQL scriptB
PL/SQL scriptC
Operating System (OS) scriptD
Enterprise Manager (EM) scriptE
Recovery Manager (RMAN) script
考题
多选题You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation?()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
考题
多选题You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file: ORA-19815: WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area()ABack up the Flash Recovery Area.BDecrease the retention time for the database backup and flashback log files.CManually delete all the archived log files from the Flash Recovery Area by using operating system (OS)commands.DManually delete all the expired backup sets from the Flash Recovery Area by using operating system(OS) commands.
考题
单选题You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this?()A
The DBMS_JOB packageB
The BACKUP_JOB packageC
The DBMS_BACKUP_RESTORE packageD
The calendar tool in the Operating System (OS)E
The backup scheduler in Enterprise Manager (EM)F
The DBMS_BACKUP_SCHEDULER packager inline mode
考题
多选题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
考题
单选题You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()A
MAXSETSIZE TO 2B
DEVICE TYPE DISK PARALLELISM 2C
RETENTION POLICY TO REDUNDANCY 2D
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
热门标签
最新试卷