What are three facts about backups with mysqldump?（）A、Can back up a remote database serverB、Allow a consistent backup to be takenC、Are always faster to restore than binary backupsD、Are able to back up specific items within a databaseE、Create automatically compressed backupsF、Will lock all storage engines for duration of backup
What are three facts about backups with mysqldump?（）
- A、Can back up a remote database server
- B、Allow a consistent backup to be taken
- C、Are always faster to restore than binary backups
- D、Are able to back up specific items within a database
- E、Create automatically compressed backups
- F、Will lock all storage engines for duration of backup
相关考题：
You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?() A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
What are three facts about backups with mysqldump?() A.Can back up a remote database serverB.Allow a consistent backup to be takenC.Are always faster to restore than binary backupsD.Are able to back up specific items within a databaseE.Create automatically compressed backupsF.Will lock all storage engines for duration of backup
What is the correct order of steps for upgrading a cisco wcs？（）A、back up the database， stop the wcs， upgrade the wcs， restore the database， start the wcs B、stop the wcs， back up the database， upgrade the wcs， restore the database， start the wcsC、back up the database， stop the wcs， upgrade the wcs， start the wcs， restore the database D、stop the wcs， back up the database， upgrade the wcs， start the wcs， restore the database
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
What RMAN command must you use before you can back up a database using the recovery catalog？（）A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
You issue the following command： RMANCONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）A、 An incremental backup strategy will be used automatically.B、 Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C、 RMAN will configure itself for maximum performance at the cost of CPU.D、 RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E、 RMAN will automatically compress backups.
Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（） A、 backup databaseB、 backup database and archivelogsC、 backup database plus archivelogsD、 backup database plus archivelog delete inputE、 backup database and archivelog delete input
Your workgroup’s project is critical and there is no time for rebuilding the Windows 2000 Professional desktops in case of disaster. Your company has not yet established automated system replacement that Windows 2000 can provide. What is your most comprehensive option for disaster recovery at this time？（）A、Back up each project desktop with the System State option enabled.B、Back up everything on each desktop as a backup option and perform this daily. Create an Emergency Repair Disk weekly to keep the registry backup current.C、Back up everything on each desktop as a backup option and perform this daily.D、Back up each project desktop with the System State option enabled， including the systerotected files.
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 a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do？（）A、Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.B、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.C、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.D、Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.
Your data recovery strategy must meet the following requirements： Back up all data files and folders in C:///Data. Restore individual files and folders in C:///Data. Ensure that data is backed up to and restored from external media. What should you do？（）A、Use the Previous Versions feature to restore the files and folders.B、Use the System Restore feature to perform backup and restore operations.C、Use the NTBackup utility to back up and restore individual files and folders.D、Use the Backup and Restore Center to back up and restore files.
You need to back up your Encrypting File System (EFS) certificate. You must achieve this goal in theminimum amount of time. What should you do?（）A、Run Cipher.exe /x.B、Run Ntbackup.exe /p.C、From Backup and Restore，click Back up now.D、From Backup and Restore，click Create a system image.
A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases， a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do？（）A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.B、Back up the current transaction log. Restore the database to the point just before the data loss.C、Restore the database from the existing backup files to a time just before the data loss.D、Restore the database to the point of the last full backup.
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do？（）A、Create a System Restore point.B、Perform an Automated System Recovery （ASR） backup and restore.C、In the Backup and Restore Center window， click the Back up files button.D、In the Backup and Restore Center window， click the Back up computer button.
单选题Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）A backup databaseB backup database and archivelogsC backup database plus archivelogsD backup database plus archivelog delete inputE backup database and archivelog delete input
多选题You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands
单选题You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）AImage of the control fileBLocation of the control fileCContents of the control file in text formatDSQL command to re-create the databaseESQL command to re-create the control fileFContents of the control file in binary format
单选题What RMAN command must you use before you can back up a database using the recovery catalog？（）A create catalogB install databaseC catalog databaseD merge Catalog with databaseE register database
单选题You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do？（）ACreate a System Restore point.BPerform an Automated System Recovery （ASR） backup and restore.CIn the Backup and Restore Center window， click the Back up files button.DIn the Backup and Restore Center window， click the Back up computer button.
单选题You issue the following command： RMANCONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）A An incremental backup strategy will be used automatically.B Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C RMAN will configure itself for maximum performance at the cost of CPU.D RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E RMAN will automatically compress backups.
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
单选题What is the correct order of steps for upgrading a cisco wcs？（）Aback up the database， stop the wcs， upgrade the wcs， restore the database， start the wcs Bstop the wcs， back up the database， upgrade the wcs， restore the database， start the wcsCback up the database， stop the wcs， upgrade the wcs， start the wcs， restore the database Dstop the wcs， back up the database， upgrade the wcs， start the wcs， restore the database
单选题What is the correct order of steps to perform an online database backup？（） a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfileAa， b， c， d， eBe， d， a， b， cCa， c， b， d， eDd， b， c， a， eEa， c， b， e， d
多选题What are three facts about backups with mysqldump?（）ACan back up a remote database serverBAllow a consistent backup to be takenCAre always faster to restore than binary backupsDAre able to back up specific items within a databaseECreate automatically compressed backupsFWill lock all storage engines for duration of backup