You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）A、4， 1， 3， 2， 5B、1， 3， 4， 5， 2C、1， 3， 2， 5； 4 not requiredD、4， 1， 5， 2； 3 not requiredE、1， 3， 4， 5； 2 not required
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
- A、4， 1， 3， 2， 5
- B、1， 3， 4， 5， 2
- C、1， 3， 2， 5； 4 not required
- D、4， 1， 5， 2； 3 not required
- E、1， 3， 4， 5； 2 not required
相关考题：
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.
The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command. 4. End read or update activity on the former primary and standby database.A、1，2，3，4B、3，2，4，1C、4，2，1，3D、4，3，2，1
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A、 Enable the flash recovery area and specify it as the archived redo log destination.B、 Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、 Enable the flash recovery area but do not specify it as the archived redo log destination. D、 Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON； command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）A、Execute the ALTER DATABASE ARCHIVELOG statementB、Select ARCHIVELOG option in the database control and restart the database to apply the changes.C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
Case 1： 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files， open the database using the RESETLOGS option. 6. Back up the database. Case 2： 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3： 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A、 Only case 1B、 Only case 2C、 Only case 3D、 Case 1 and 2E、 Case 2 and 3F、 Case 1 and 3G、 All cases， case 1， case 2， case 3
Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（） a. Issue a checkpoint. b. Shut down the database. c. Issue an alter database open command to open the database. d. Startup mount the database. e. Issue an alter database clear logfile command. f. Recover all database datafiles.A、a， b， c， dB、b， d， e， cC、a， b， d， e， cD、b， f， d， f， cE、b， d， a， c
You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order： 1：Shut down the instance. 2：Execute the ALTER DATABASE ARCHIVELOG command. 3：Start up the instance and mount the database. 4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database. Which is the correct sequence of steps for accomplishing the task（）A、4，1，3，2，5B、1，3，4，5，2C、1，3，2，5；4 not requiredD、4，1，5，2；3 not requiredE、1，3，4，5；2 not required
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）A、2，1，4，3，5，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，6
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）A、Multiplex all database files.B、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter
Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command. A、a， c， f， gB、b， c， f， hC、a， b， c， f， gD、a， b， c， f， g， hE、b， c， f， e， g
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1）Shut down the instance. 2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3）Execute the ALTER DATABASE FLASHBACK OFF command. 4）Start up the instance and mount the database. 5）Execute the ALTER DATABASE FLASHBACKON command. 6）Open the database. Select the correct order in which these tasks need to be performed. （）A、2，1，4，3，5，6B、1，4，3，2，6，5C、1，4，2，6，3，5D、3，2，1，4，5，6
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）A、Shut down the database.B、Set the appropriate parameters in init.ora file.C、Start the database in NOMOUNT state.D、Issue the ALTER DATABASE ARCHIVELOG command.E、Open the database.F、Take a full closed backup.
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A、Only bring the tablespace back online.B、Only recover the tablespace and then bring the tablespace back online.C、Shut down the database， recover the data file and then start up the database.D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）A、Multiplex all database filesB、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter.
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）A、a， b， e， cB、b， e， dC、a， b， d， cD、b， g， c， fE、a， b， d， f
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）A、Shut down the database, restore the two data files and then start up the database. B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A Enable flashback logging.B Start the database in the ARCHIVELOG mode.C Issue the ALTER DATABASE FLASHBACK ON； command.D Set the FAST_START_MTTR_TARGET initialization parameter.
单选题You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）A4， 1， 3， 2， 5B1， 3， 4， 5， 2C1， 3， 2， 5； 4 not requiredD4， 1， 5， 2； 3 not requiredE1， 3， 4， 5； 2 not required
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination. D Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging
单选题You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL SHUTDOWN IMMEDIATE 5. Open the database： SQL ALTER DATABASE OPEN； Choose the correct sequence.（）A 4， 1， 3， 2， 5B 4， 3， 1， 2， 5C 2， 4， 3， 5， 1D 4， 2， 5， 3， 1
多选题You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.