单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()A Restore and recover the datafile.B Restore and recover the tablespace.C Restore and recover the database.D Restore and recover the control file.E Restore and recover the parameter file.

单选题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()
A

 Restore and recover the datafile.

B

 Restore and recover the tablespace.

C

 Restore and recover the database.

D

 Restore and recover the control file.

E

 Restore and recover the parameter file.


参考解析

解析: 暂无解析

相关考题:

I must hold ______ for any damage which may result from the accidents you have caused.A.your responsibleB.you responsibleC.you are responsibleD.your are responsible

It is not until you have lost your health()you know its value.AuntilBwhenCwhatDthat

It is not until you have lost your health()you know its value.A、untilB、whenC、whatD、that

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()  A、 Restore and recover the datafile.B、 Restore and recover the tablespace.C、 Restore and recover the database.D、 Restore and recover the control file.E、 Restore and recover the parameter file.

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager (RMAN) to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem? ()A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files, after you lost all the control files in your database

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

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 executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()Arenaming the control filesBdropping a user in your databaseCenabling or disabling redo log archivingDdropping a tablespace in your databaseEre-creating the control files, after you lost all the control files in your database

单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?()AALTER DATABASE ENABLE BLOCK CHANGE TRACKINGBALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE CALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE DALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

单选题It is not until you have lost your health()you know its value.AuntilBwhenCwhatDthat

单选题You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically, and not have to do it manually.  What should you do?()AUse the DROP DATAFILE command.BUse the DROP TABLESPACE command.CEnsure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.DEnsure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()A Restore and recover the datafile.B Restore and recover the tablespace.C Restore and recover the database.D Restore and recover the control file.E Restore and recover the parameter file.

单选题Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database?()A 13:00 on Tuesday.B 15:00 on Tuesday.C Up until the last available archived redo log on Sunday.D To any point; all the redo should still be available in the online redo logs.E The database is not recoverable.

单选题You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? ()AClone BCopy CTemplate DTerminal

单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads information into memory for users

单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()ARestore and recover the datafile. BRestore and recover the tablespace. CRestore and recover the database. DRestore and recover the control file. ERestore and recover the parameter file.

单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()ASMON would automatically restore the lost file.BYou would need to restore the whole database from the last backup.CYou would need to restore the file from the last full database backup.DYou would need to use flashback technology to restore the lost redo log member.EYou would need to use Recovery Manager (RMAN) to restore the lost redo log member.FYou would need to restore the missing log file by copying one of the remaining files from the same group.

单选题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.Aa, c, f, gBb, c, f, hCa, b, c, f, gDa, b, c, f, g, hEb, c, f, e, g

单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now you get an order from your company CIO, you have to identify whether a database integrity check (DBCC CHECKDB) was run for a particular database.  Which log file should you examine?()Alog.trc Bdefault.trc CERRORLOG DSQLAGENT

单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure, you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time?()A Restore all the datafiles from the backup.B Restore only the lost datafile from the backup.C Restore all the datafiles for the lost tablespace from the backup.D Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

单选题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?()Aa, b, e, cBb, e, dCa, b, d, cDb, g, c, fEa, b, d, f

多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.

单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file?()ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file, just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery

单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature?()A ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

单选题You have lost datafiles 1 and 3 from your database,and the database has crashed.  In what order should you perform the following steps to recover your database?() 1. Take the datafiles that were lost offline.  2. startup mount the database  3. Issue the alter database open command. 4. Restore the datafiles that were lost  5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online.  7. Recover the database with the recover database command.A 2,1,3,4,5,6B 2,4,5,3C 4,7,3D 2,4,7,3E 2,7,3