单选题David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order?()   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN.A a, b, c, d, e, f, gB b, c, d, g, f, e, aC g, f, a, b, c, e, dD c, a, d, b, f, e, gE g, f, a, b, e, c, d

单选题
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order?()   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN.
A

  a, b, c, d, e, f, g

B

 b, c, d, g, f, e, a

C

 g, f, a, b, c, e, d

D

 c, a, d, b, f, e, g

E

 g, f, a, b, e, c, d


参考解析

解析: 暂无解析

相关考题:

A collection of relmed information,organized for easy retrieval.A.DataB.DatabaseC.BufferD.Stack

David: Good morning.l'd like to make an appointment to see Mr Bond this morning , please.Nursc: l' m sorry.I don' t have any appointments this morning.David: Oh , dear.I'm feeling really ill.Nurse: What's the matter?David: I feel terrible.I' ve got a headache , backache and a sore throat.Nurse: Have you got a temperature?David: I think so was hot and cold a1l night and I was sick this morning.Nursc: You feel awful.don't you? Do you think you've got flu?David: Yes, probably.Or an infection in my throat.Nursc: OK.I call give you an emergency appointment.Can you come at the end of th morning? Come at eleven thirty and wait until a doctor is free.David: OK.Thank you.26.David has got a headache , earache and backache.A.RightB.Wrong27.David felt hot and cold during the night.A.RightB.Wrong28.The nurse thinks David has an infection in his throat.A.RightB.Wrong29.Mr Bond is free at 11: 30.A.RightB.Wrong30.David gets an appointment finally.A.RightB.Wrong

删除数据库的命令是( )。A.CLOSE DATAB.SET DATAC.OPEN DATAD.DELETE DATA

A group of related fields is called a(75).A.dataB.fileC.recordD.database

______ processing offers many ways to edit text and establish document formats.you can easily insert, delete, change, move and copy words or blocks of text.A.DataB.DatabaseC.WordD.File

72( )A. dataB. controlC. requestD. session

The rifle was discharged accidentally.A:by surprise B:by the wayC:by accident D:by far

Which of the following is not an advantage of block media recovery (BMR)?()A、 Reduced MTTR.B、 Datafiles remain offline while corrupt blocks are repaired.C、 Datafiles remain online while corrupt blocks are repaired.D、 A and C

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement:   SQL DROP TABLE SCOTT.EMP PURGE;   After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database

A systems administrator has a high performance server with a file share full of data that has not been used in a long time, but is still important and might be used in the future. Which of the following should they do to reclaim the space off the high performance server?()A、Audit the dataB、Delete the dataC、Back up the dataD、Archive the data

David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order?()   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN. A、 a, b, c, d, e, f, gB、 b, c, d, g, f, e, aC、 g, f, a, b, c, e, dD、 c, a, d, b, f, e, gE、 g, f, a, b, e, c, d

In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()  A、 The datafiles have an ONLINE status.B、 The datafiles have an OFFLINE status.C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E、 The datafiles are in STANDBY mode.

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace

You are the administrator of your company's network. A user named David runs Windows 2000 Professional on his portable computer. David wants to be able to work at home on files that he created at the office and stored on the company network. Prior to logging off the network and leaving the office, David enables offline files.   David calls you from home and reports that copies of his folders and files on the network are not available on his portable computer. What should you instruct David to do, so that he can proceed with his work?()A、Enable file and print sharing. David will be able to access his files at home immediately. B、Synchronize all offline files. David will be able to access his files at home immediately. C、At the office, make all files available offline. David will be able to access his files the next time he logs off the network. D、At the office, create a shortcut to the Offline Files folder. David will be able to access his files the next time he logs off the network.

单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).EThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

单选题Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement:   SQL DROP TABLE SCOTT.EMP PURGE;   After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()A the datafiles associated with the SYSTEM tablespaceB the datafiles associated to the DATA1 tablespaceC the datafiles associated to the SYSTEM and DATA1 tablespacesD all the datafiles in the database

问答题While working on a case Dr Watson accidentally fell down a 30ft dry wishing well. Sherlock Holmes lowered him down a rope.  “Can you climb up?” shouted Holmes.  “I’ll be out before you know it.” came Watson’s reply.  But the climb wasn’t as easy as Watson had first imagined. Each hour he managed to climb 3ft—but slipped back 2ft.  How long did it take Watson to get out

单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()A The datafiles have an ONLINE status.B The datafiles have an OFFLINE status.C The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E The datafiles are in STANDBY mode.

单选题What is the result of this command?() RMAN Report need backup days 3;A Lists all datafiles created in the last three days that are not backed up.B Lists all datafiles not recoverable based on the current retention criteria.C Lists all datafiles not backed up in the last three days. The datafile is not recoverable. D Lists all datafiles that need to be backed up due to unrecoverable operations.E Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.

问答题Peter, David and Paul said following sentences:  Peter: David is a liar, Paul always tells the truth.  David: Peter is truthful.  Paul: David is a liar, Peter is truthful.  Two of these men always tell the truth, one of them sometimes tells the truth and sometimes lies. Which of these men is a liar?

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

单选题Which of the following best describes a full backup? ()AAll datafiles of a database BAll datafiles, archive logs, and control files CAll datafiles and control files DAll the used blocks in a datafile

单选题Which of the following is not an advantage of block media recovery (BMR)?()A Reduced MTTR.B Datafiles remain offline while corrupt blocks are repaired.C Datafiles remain online while corrupt blocks are repaired.D A and C

单选题A highly available WebLogic cluster in UNIX is configured for automatic server migration. Node Managed is configured on both machines to start managed servers. How should you simulate a managed server failure to test whether automatic server migration is working?()AShut down the managed server from the WebLogic console.BShut down the managed server using the WLST command through Node Manager.CRun kill -9 once to kill the managed server process.DRun kill -9 to kill the managed server process, and run kill -9 one more time if the managed  server is restarting.

单选题You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover?()A all the datafiles in the databaseB the datafiles associated with the SYSTEM tablespaceC the datafiles associated with the DATA1 tablespaceD all the datafiles in the database except those associated with the DATA1 tablespace

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