网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In user-managed backup and recover procedures， how are data files backed up？ （）
A
Using SQL commands.
B
Using SQL*Plus commands.
C
Using operating system commands.
D
Using Recover Manager commands.
参考答案
参考解析
解析：
暂无解析
更多 “单选题In user-managed backup and recover procedures， how are data files backed up？ （）A Using SQL commands.B Using SQL*Plus commands.C Using operating system commands.D Using Recover Manager commands.” 相关考题
考题
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
考题
A company has a policy that states that all servers will be fully backed up on the weekend.Additionally， all changed items will be backed up each night. In the event of a server failure， the administrator wants to be able to fully recover the system using two restore jobs. Which of the following backup levels should be used nightly？（）A、IncrementalB、NormalC、DifferentialD、Full
考题
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
考题
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script
考题
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository
考题
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 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
考题
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
考题
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 issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
考题
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file
考题
Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A、Rebuild the index using the online option. B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
考题
In user-managed backup and recover procedures， how are data files backed up？ （）A、Using SQL commands.B、Using SQL*Plus commands.C、Using operating system commands.D、Using Recover Manager commands.
考题
You have a Windows Server 2008 R2 Hyper-V server. Virtual machines （VMs） store data on pass-through disks. You need to design a backup solution that allows you to restore VMs. What should you do？（）A、Back up the VMs by using Windows Server Backup within the VMsB、Back up the system state on the VMs by using Windows Server Backup within the VMsC、Back up the Hyper-V server by using Microsoft System Center Data Protection Manager （DPM） 2007 with SP1D、Create checkpoints of the VMs by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2
考题
单选题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
考题
单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）A
cannot be used in RMANB
by starting up the database againC
by using the CATALOG command of RMAND
by using the RECOVER CATALOG command in RMANE
by re-creating the target control file to rebuild the RMAN repository
考题
单选题The Certkiller has a Windows 2008 domain controller server. This server is routinely backed up over the network from a dedicated backup server that is running Windows 2003 OS. You need to prepare the domain controller for disaster recovery apart from the routine backup procedures. You are unable to launch the backup utility while attempting to back up the system state data for the data controller. You need to backup system state data from the Windows Server 2008 domain controller server. What should you do（）A
Add your user account to the local Backup Operators groupB
Install the Windows Server backup feature using the Server Manager feature.C
Install the Removable Storage Manager feature using the Server Manager featureD
Deactivating the backup job that is configured to backup Windows 2008 server domain controller on the Windows 2003 server.E
None of the above
考题
多选题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.
考题
单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A
The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B
The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C
The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D
The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
考题
单选题Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A
Rebuild the index using the online option. B
Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C
Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D
Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
考题
单选题In user-managed backup and recover procedures， how are data files backed up？ （）A
Using SQL commands.B
Using SQL*Plus commands.C
Using operating system commands.D
Using Recover Manager commands.
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A
restore the tablespace from the backup； there is no need to apply the redo informationB
restore the full database to recover the data up to the point when you performed the backupC
restore the tablespace from the backup and then perform a recovery using the backup control fileD
restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
考题
单选题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 have a Windows Server 2008 R2 Hyper-V server. Virtual machines （VMs） store data on pass-through disks. You need to design a backup solution that allows you to restore VMs. What should you do？（）A
Back up the VMs by using Windows Server Backup within the VMsB
Back up the system state on the VMs by using Windows Server Backup within the VMsC
Back up the Hyper-V server by using Microsoft System Center Data Protection Manager （DPM） 2007 with SP1D
Create checkpoints of the VMs by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2
考题
单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A
You need to perform the restore and recover operations manually, because the backup was made manually. B
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
考题
单选题A company has a policy that states that all servers will be fully backed up on the weekend.Additionally， all changed items will be backed up each night. In the event of a server failure， the administrator wants to be able to fully recover the system using two restore jobs. Which of the following backup levels should be used nightly？（）A
IncrementalB
NormalC
DifferentialD
Full
考题
单选题You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A
It is a SQL script.B
It is a PL/SQL file.C
It is an operating system （OS） file.D
It is a Recovery Manager （RMAN） script
考题
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A
by using the Flashback Table featureB
by using the Flashback Database featureC
by performing incomplete recovery using RMAN utilityD
by performing incomplete recovery using user-managed recovery
热门标签
最新试卷
