多选题You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET

题目内容(请给出正确答案)

多选题

You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）

set SQL_TRACE=True

set UNDO_RETENTION=14400

set FAST_START_MTTR_TARGET=240

set LOG_CHECKPOINT_INTERVAL=240

set DB_FLASHBACK_RETENTION_TARGET=14400

set the RETENTION GUARANTEE clause for the undo tablespace

参考答案和解析

正确答案： F,E

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

点击查看答案
第2题

多选题You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET=240Dset LOG_CHECKPOINT_INTERVAL=240Eset DB_FLASHBACK_RETENTION_TARGET=14400Fset the RETENTION GUARANTEE clause for the undo tablespace

点击查看答案
第3题

单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A the time when the last flashback operation in your database was performedB the time when the first flashback operation in your database was performedC a list of flashback operations performed in your database using SCN and timeD the approximate time and the lowest system change number （SCN） to which you can flash back your database

点击查看答案
第4题

单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A set the CPU time per call in the users profileB set the CPU time per session in the users profilesC set the CPU levels for the users’ group using Resource ManagerD set the TIMED_STATISTICS parameter to TRUE in the parameter file

点击查看答案
第5题

单选题You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication. You decide to make use of Microsoft ASP.NET 3.5 in order to create the application. The followingmarkup is present on the page： " SelectCommand="GetUsers" SelectCommandType="StoredProcedure" FilterExpression="Active=1 AND Name LIKE ’{0}%’"> The page is used to retrieve the Users from a company database. However， only the active usersare displayed. The TextBox control allows you to also filter users by status. You do not specify astatus when you click the Filter button. You notice that the page does not filter by active users andshows all the users that are retrieved from the database. You need to make the necessary settingsto ensure that only the active users are being displayed on the page when a status is notspecified. What should you do？（）A You should ensure that a default value for the Status property of the ControlParameter controlis set.B You should ensure that the PropertyName property of the ControlParameter control is set toText.C You should ensure that the ControlParameter control’s ConvertEmptyStringToNull property isset to false.D You should ensure that the {0} placeholder in the FilterExpression property is replaced with the（？） symbol.

点击查看答案
第6题

单选题You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）AUse ROLLBACK command with SCN 663571.BPerform Flashback Transaction Query with SCN 663571.CExecute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.DExecute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

点击查看答案
第7题

单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）AThe time when the last flashback operation in your database was performed.BThe time when the first flashback operation in your database was performed.CA list of flashback operations performed in your database using SCN and time.DThe approximate time and the lowest system change number （SCN） to which you can flash back your database.

点击查看答案

多选题You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容