The command produces an error because the retention period cannot be reduced
All historical data older than 3 years is purged from the flashback archive FLA1
All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
第1题:
—Do you want another drink ?
——.
AI don’t think so B No way C Not at all D I wouldn’t say no
第2题:
A.whole
B.all
C.the whole
D.all the
第3题:
Where shall I go through the formalities if I want to store my luggage here?
A.You can store your luggage in the reception desk over there
B.You can store your luggage in the information room.
C.You can store your luggage in the safe box of the bank.
D.Luggage can be stored in the railway station and airport.
第4题:
A. Both tables have NULL values.
B. You want all unmatched data from one table.
C. You want all matched data from both tables.
D. You want all unmatched data from both tables.
E. One of the tables has more data than the other.
F. You want all matched and unmatched data from only one table.
第5题:
Why do you want to leave your previous job?().
A. I'm hoping to have a better position.
B. I don't want to work at all.
C. You won't understand it.
第6题:
9. —Do you want tea or coffee?
—I really don-t mind_________ .
A. None
B. Either
C. Neither
D. All
第7题:
第8题:
(A)All right. Thank you anyway.
(B) It’s a pleasure.
(C) Sorry, I’m not sure about it. Let’s go and ask the policeman.
(D) Don’t bother!
正确答案:C
解答参考:C。本题问题为请问,百货商店该怎么走?。选项A好的,谢谢你和选项B很高兴答非所问,选项D不要烦我为非礼貌用语。
第9题:
Shop-assistant: May I help you, sir?
Mr. Blair: Er…I want to buy my wife a gift for Christmas, but I don’t know what she would like.
Shop-assistant: _______________________ These are all from Paris.
Mr. Blair: No. She has very good taste in clothes. I don’t want to take the risk.
A: Do you want to buy a pair of shoes?
B: What about a gold necklace?
C: How about an evening gown?
D: Don’t you think a gold watch would be very nice?
第10题:
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command:ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS;What is the outcome of this command?()
A. The command produces an error because the retention period cannot be reduced
B. All historical data older than 3 years is purged from the flashback archive FLA1
C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time