单选题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 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.

查看答案

考题 Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）A. 1,6,5,4,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered

查看答案

考题 You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?() A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

查看答案

考题 A customer has a BladeCenter H chassis with a single AMM. The AMM is defective. Which of the following is the method to backup the existing AMM so the new AMM automaticlally picks up the configuration? （）A、Back up the AMM configuration to a file B、Back up the AMM configuration to the chassis C、Back up the AMM using IBM Systems Director D、Back up the AMM using Tivoli Storage Manager

查看答案

考题 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

查看答案

考题 Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.

查看答案

考题 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

查看答案

考题 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

查看答案

考题 When performing an online backup，what is the proper order of the following steps？（） a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command. d. Back up the database files. e. Determine the beginning log sequence number. f. Determine the ending log sequence number. g. Force a log switch with the alter system switch logfile command.A、a， b， c， d， e， f， gB、c， d， a， b， e， g， fC、f， d， b， g， a， c， eD、e， c， d， a， g， f， bE、a， f， b， g， e， c， d

查看答案

考题 If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command

查看答案

考题 You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

查看答案

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

查看答案

考题 You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）A、USER_DUMP_DESTB、CORE_DUMP_DESTC、TRACE_DUMP_DESTD、BACKUP_DUMP_DESTE、BACKGROUND_DUMP_DEST

查看答案

考题 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

查看答案

考题 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？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all

查看答案

考题 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.

查看答案

考题单选题You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）A USER_DUMP_DESTB CORE_DUMP_DESTC TRACE_DUMP_DESTD BACKUP_DUMP_DESTE BACKGROUND_DUMP_DEST

查看答案

考题多选题If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）AThe next time you back up the database when you are also connected to the recovery catalog and the target databaseBThe next time you are connected to the target database and the recovery catalog database and issue the resync commandCThe next time you connect RMAN to just the recovery catalogDThe next time you connect to the recovery catalog and the target database with RMANEConnecting to the recovery catalog and issuing the resync all databases command

查看答案

考题单选题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？（）A backup database allB backup compressed databaseC backup as compressed backupset databaseD backup as compressed backup database plus archivelog allE backup as compressed backupset database plus compress archivelog all

查看答案

考题单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

查看答案

考题单选题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

查看答案

考题单选题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 logfileA a， b， c， d， eB e， d， a， b， cC a， c， b， d， eD d， b， c， a， eE a， c， b， e， d

查看答案

考题单选题You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）A Restore the backup control file and open the database with RESETLOGS option.B Perform point-in-time recovery because flashback cannot be performed again on this tableC Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

查看答案

考题单选题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

查看答案

考题单选题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

查看答案

考题单选题A company uses raw logical volumes. Which command can be used to back up the data in the raw logical volumes to a tape？（）A ddB tarC cpioD mksysb

查看答案

考题多选题You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）AEvent Viewer gives more details on the failure.BThe alert log file gives detailed information about the failure.CPMON rolls back the transaction and releases the locks.DSMON rolls back the transaction and releases the locks.EThe transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.FData modified by the transaction up to the last commit before the abnormal termination is retained in 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 logfileA a， b， c， d， eB e， d， a， b， cC a， c， b， d， eD d， b， c， a， eE a， c， b， e， d

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：