You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）A、restore the tablespace from the backup; there is no need to apply the redo information B、restore the full database to recover the data up to the point when you performed the backup C、restore the tablespace from the backup， and then perform a recovery using the backup control fileD、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）
- A、restore the tablespace from the backup; there is no need to apply the redo information
- B、restore the full database to recover the data up to the point when you performed the backup
- C、restore the tablespace from the backup， and then perform a recovery using the backup control file
- D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
相关考题：
I’m really quiet lost.______ me how to get out of here? A.Would you mind showingD.Would you be showingD.you to beD.Would you mind to showing
27． If you lost your keys ，you may call________ to find them．A． 487~2349B．498-2456C．412 - 9856D．476-5939
—I lost my money.—_________ .A.Oh, you will be more carefulB.Oh, you must be more carefulC.Oh, you would be more carefulD.Oh, you should have been more careful
"It tells you how to find your way when you get lost.But it’s all right. I'll get another one in London." is said by().A、Pocahontas' dadB、PocahontasC、John SmithD、Grandma Willow
Those numbers come to mean the world to you ()they give you the record of how much money you’ve earned or lost. A、becauseB、so thatC、in case
– – We lost in the game.() A.What‘s your feeling?B.What‘s the matter with you?C.Is there something wrong with you?D.Do you feel ok?
– I lost my purse. -- _________________.A、I’m sorry to hear that.B、Where?C、How could you lose it?D、How can I help you?
－ I’m sorry. I lost the key.－______________ A、No, it’s all right.B、Well, it’s OK.C、You are welcome.D、You are wrong.
If you go into the forests with friends，stay with them． If you don't，you may get lost．If you do get lost，this is what you should do．Sit down and stay where you are．'Don't try to find your friends． Let them find you． You can help them to find you by staying in one place．There is another way to help your friends or other people to find you． Give them a signal (信号) by shouting or whistling(吹口哨) three times． Stop． Then shout or whistle three times again． Any signal given three times is a call for help．Keep on shouting or whistling，always three times'together． When people hear you，they will give two shouts or two whistles． When a signal is given twice，it is an answer to a call for help．lf you don-t think that you will get help before night comes，try to make a small room with branches(树枝)．What should you do if you get hungry or need to drink water? You would have to leave your little branch room to look for something to eat and drink． Don't just walk away． Drop small branches as you walk so that you can find your way back．The most important thing to do when you are lost-stay in one place．( )16． If you get lost in the forests，you should walk everywhere to find your friends as soon as possible．
When a dog is barking, you assume it is barking for something or at someone that exists here and now. It couldn’t be sorrowful for some lost love or lost bone. This indicates the design feature of __________.?A.cultural transmissionB.productivityC.displacementD.duality
If you____the trigger of a gun really hard and really fast, it doesn't fire any faster or harder than if you just squeezed it gently.A.condenseB.squeezeC.obtainD.lost
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
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.
When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.
Which statement about recovering from the loss of a redo log group is true?（）A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B、If the lost redo log group is CURRENT, you must clear the log file.C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）A、 You find that one of the redo log members in each redo log group is lost.B、 You find that a data file that belongs to the USERS tablespace is damaged.C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.D、 You find that the current redo log group is damaged and is not available for recovery.E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）AComplete Recovery with online redo logBComplete Recovery with archived redo logCTablespace Point-in-Time Recovery (TSPITR)DIncomplete Recovery with system change number (SCN)
单选题In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）A Complete Recovery with online redo logB Complete Recovery with archived redo logC Tablespace Point-in-Time Recovery （TSPITR）D Incomplete Recovery with system change number （SCN）
单选题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.
单选题I lost your address, otherwise I _____ you long before.Ahad visitedBhave visitedCwould have visitedDshould visit
单选题Which statement about recovering from the loss of a redo log group is true？（）A If the lost redo log group is ACTIVE， you should first attempt to clear the log file.B If the lost redo log group is CURRENT， you must clear the log file.C If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.
单选题Telephone enquiry Clerk: Lost property department. Can I help you? Phone caller: ______ I left it on the "Margate Mermaid" when we cross from Olsten yesterday morning.AI want you help me find my lost camera.BI wonder if you have a camera of mine.CDo you think if you have a camera of mine?DI doubt if you could help me find my lost camera.