多选题You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual
多选题
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
A
guarantee undo retention
B
add one more redo log group
C
size the redo log files appropriately
D
size the UNDO tablespace appropriately
E
size the SYSTEM tablespace appropriately
F
configure an appropriate undo retention interval
G
change automatic undo management to manual
参考解析
解析：
暂无解析
相关考题：
You can go out,()you promise to be back before 12 o'clock.A. so far asB. as far asC. as long as
I don't know why you're so concerned － it isn't your problem (). A、all the sameB、in the endC、after allD、before long
Could you tell me ()? A、how long you live hereB、how long have you lived hereC、how long you have lived hereD、how long did you live here
You can go out, ____________ you promise to be back before 11 o’clock.A、as far asB、as long asC、as well asD、as soon as
Could you please tell me ____________________ ? A、how long have you lived hereB、how long you lived hereC、how long you have lived hereD、you have lived here how long
You can go out, ______you promise to be back before 11 o'clock.A. even thoughB. ever sinceC. as far asD. as long is
Before CPR is started，you should ______．A.Establish an open airwayB.Treat any bleeding woundsC.Insure the victim is consciousD.Make the victim comfortable
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）A、guarantee undo retentionB、add one more redo log groupC、size the redo log files appropriatelyD、size the UNDO tablespace appropriatelyE、size the SYSTEM tablespace appropriatelyF、configure an appropriate undo retention intervalG、change automatic undo management to manual
You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.
单选题You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage，which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables. Which action would you take to delay the referential integrity checking until the end of thetransaction（）A Set the constraint to deferred before starting the transaction.B Alter the constraint to NOVALIDATE state before starting the transaction.C Enable the resumable mode for the session before starting the transaction.D Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
单选题Wise buying is a positive way in which you can make your money go further. The （）you go about purchasing an article or a service can actually （）you money or can add （）the cost. Take the （）example of a hairdryer. If you are buying a hairdryer, you might （）that you are making the （）buy if you choose one （）look you like and which is also the cheapest （）price. But when you get it home you may find that it （）twice as long as a more expensive （）to dry your hair. The cost of the electricity plus the cost of your time could well （）your hairdryer the most expensive one of all. So what principles should you （）when you go out shopping? If you （）your home, your car or any valuable （）in excellent condition, you’ll be saving money in the long （） Before you buy a new （）,talk to someone who owns one. If you can, use it or borrow it to check it suits your particular （） Before you buy an expensive （）,or a service, do check the price and （）is on offer. If possible, choose （）three items or three estimates.请在第（）处填上正确答案。AfunctionBpurposeCgoalDtask
多选题You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）Aguarantee undo retentionBadd one more redo log groupCsize the redo log files appropriatelyDsize the UNDO tablespace appropriatelyEsize the SYSTEM tablespace appropriatelyFconfigure an appropriate undo retention intervalGchange automatic undo management to manual
单选题I lost your address, otherwise I _____ you long before.Ahad visitedBhave visitedCwould have visitedDshould visit