86、Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?
A. The backup will consist of used data blocks only. B. The database must be shut down to accomplish the backup. C. The backup can be accomplished without shutting down the database. D. The backup will contain all database files that have never been backed up.
Answer: B
87、
87.Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled? A. It is the time period after which the undo data becomes obsolete. B. It is the time period after which the committed undo data would be transferred to a temporary tablespace. C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available. D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.
Answer: C
88、
88.You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database? A. Use the database link. B. Use the SQL*Loader utility. C. Use the Oracle Data Pump utility. D. Create an external table and leave the data in the flat file.
Answer: D
89、
89.Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.) A. You can add SQL test cases to the incident package. B. You can add or remove the trace files to the package. C. You cannot create an incremental incident package when the physical files are purged from the ADR. D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
Answer: ABD
90、
90.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task? A. Multiplex all database files. B. Configure the Flash Recovery Area. C. Configure the database instance for ARCHIVELOG mode. D. Configure the FAST_START_MTTR_TARGET initialization parameter.
Answer: C
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步