网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()
- A、 Restore the lost data file from the backup, and then flash back the database.
- B、 Restore the data file pertaining to index tablespace, and then recover the tablespace.
- C、 Restore all the data files, and then perform an incomplete recovery to get the tablespace back.
- D、 Restore all the data files, and then perform an incomplete recovery using the backup control file.
- E、 Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.
参考答案
更多 “You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()A、 Restore the lost data file from the backup, and then flash back the database.B、 Restore the data file pertaining to index tablespace, and then recover the tablespace.C、 Restore all the data files, and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files, and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.” 相关考题
考题
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
考题
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 transmission
B.productivity
C.displacement
D.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.condense
B.squeeze
C.obtain
D.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.
考题
You are the domain administrator for your company. Roaming profiles are enabled for all users in the sales department. Roaming profiles are stored on a server named Server1, in a shared folder named Profiles. Roger is a user in the sales department. Susan is Roger's manager. Susan reports that Roger modifies his desktop settings, which results in the need for help desk assistance and in lost productivity for Roger. You want to ensure that Roger cannot modify his roaming profile. What should you do?() A、In Active Directory Users and Computers, on Roger's profile tab, change the profile path to //Server1/Profiles/%username%.dat. B、In Active Directory Users and Computers, on Roger's profile tab, change the profile path to //Server1/Profiles/%username%.man. C、In Roger's profile on Server1, change the file name of Ntuser.dat to Ntuser.man.D、In Roger's profile on his computer, change the file name of Ntuser.dat to Ntuser.man.
考题
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?()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)
考题
单选题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.
考题
单选题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.A
I want you help me find my lost camera.B
I wonder if you have a camera of mine.C
Do you think if you have a camera of mine?D
I doubt if you could help me find my lost camera.
考题
单选题What are you majoring in?()A
In a university.B
Very hard.C
Mathematics.D
At nine in the morning
热门标签
最新试卷