Oracle数据库19c闪回日志空间回收与服务器生成警报特性解析

需积分: 0 136 浏览量更新于2024-06-26 1 收藏 1.07MB DOCX 举报

"083知识资源083题目解析，涉及Oracle数据库19c的闪回日志空间回收和服务器自动生成的警告，以及Oracle Grid Infrastructure的升级" 在Oracle数据库19c及更高版本中，关于闪回日志（Flashback Log）所使用的空间回收有以下两个关键点： 1. 当Fast Recovery Area (FRA) 出现空间压力时，空间才会被回收。这意味着只有当FRA中的存储空间不足时，系统才会开始清理旧的闪回日志以释放空间。 2. 闪回日志的保留期降低后，空间可能会被自动提前回收。这表示如果调整了闪回日志的保留时间，系统可能会在达到新设定的时间期限前主动回收空间，以避免将来出现空间压力。关于服务器生成的警告（Server-Generated Alerts），有以下两个特点： A) Stateless alerts（无状态警告）可以被手动清除。这意味着无状态警告不会自动消失，需要管理员进行手动处理。 D) Stateless alerts 可以从警报历史中手动删除。这提供了另一种管理无状态警告的方式，即直接从历史记录中移除。在升级Oracle Grid Infrastructure时，有三个重要方面需要注意： 1. 新版本的Oracle Grid Infrastructure将在现有的Oracle Grid Infrastructure家目录之外安装一个新的家目录。这意味着升级过程通常涉及在现有环境旁边安装新的软件组件。 2. 升级可能需要对现有的集群配置进行检查和调整，以确保与新版本兼容。 3. 在升级过程中，必须谨慎操作，因为这可能会影响到依赖于Oracle Grid Infrastructure服务的数据库和其他应用程序。这些知识点对于Oracle数据库管理员和OCP（Oracle Certified Professional）来说至关重要，理解并掌握这些概念有助于管理和维护高效稳定的数据库环境。在实际工作中，了解如何有效地回收闪回日志空间以及处理服务器警告，可以提高系统的可用性和性能。同时，熟悉Oracle Grid Infrastructure的升级流程，能确保在升级过程中减少潜在的风险和中断。

D) Single-byte character sets always use 7-bit encoding schemes(还有8-bit)

E) Multibyte character sets allow more efficient space utilization than single byte character sets.

(应该是单字节拥有比多字节更好的空间利用率)

F) Single-byte character sets always use 8-bit encoding schemes.(还有7-bit)

答案: AC

33、Which three are true about using Database Upgrade Assistant(DBUA)to upgrade a database?

A) Multiple databases with the same ORACLE HOME can be upgraded simultaneously

(该工具以数据库级别)

B) All pluggable databases are automatically upgraded as part of a container database upgrade.(是的)

C) DBUA must be launched from the target Oracle Home(必须从ORACLE_HOEM启动)

D) The Pre-upgrade Information Tool script is executed by DBUA

E) A whole database backup must exist before upgrade(没有备份也是可以的)

F) The database must be opened in read-only mode.(read-write)

答案: BCD

34、PDB1 and PDB2 are pluggable databases in CDB1

Examine these commands

CDB1 is then restarted

Which three are true?

A) PDB2 will be opened READ WRITE B）

B) PDB2 will be MOUNTED（对的，因为没有保存状态）

C) PDB$SEED will be opened READ ONLY(PDB$SEED始终保持读写状态)

D) PDB1 will be opened READ WRITE(是的，因为做了状态保留)

E) PDB$SEED will be MOUNTED

F)PDB1 will be MOUNED.

答案: BCD

35、Which three are true about using Database Resource Manager in an Oracle multitenant

environment?

A) A Pdb-level resource plan can limit session PGA memory

B) A Cdb-level resource plan is mandatory(必须的) when using Pdb-level resource plans

C) A Cdb-level resource plan can limit session CPU utilization.(应该是特定的PDB)

D) A Cdb-level resource plan can limit PDB UNDO use

E) Pdb-level resource plans can limit uncommitted UNDO per consumer group(UNDO只能在CDB下)

F) A Cdb-level resource plan can limit PDB CPU utilization.

答案: ABF

You can specify an undo pool for each consumer group. An undo pool controls the total amount of undo for

uncommitted transactions that can be generated by a consumer group.

while from CDB level you cannot limit CPU on particular session level in PDB (it can be done on PDB

level) but you can "only" limit CPU generally for particular PDB

36、Which three are true about the FLASHBACK DATABASE feature?

A) It always generates REDO and UNDO(当然)

B) It requires that the target database be in ARCHIVELOG mode(必须处于归档模式)

C) FLASHBACK DATABASE only uses FLASHBACK Logs to get the database to the desired

flashback time(redo也是可以的)

D) FLASHBACK LOGS are archived after a log switch(并不存在闪回日志，只有online redo)

E) A database can be flashedback using SQL*PLUS

F) Queries and DML have the same FLASHBACK LOG overhead(开销) when flashback is

enabled for a database(DML的overhead会大一些)

答案: ABE

37、Which should be tuned(优化) first when doing a performance tuning exercise for an Oracle

Database environment?

A) log writer performance

B) SQL statements

C) database instance memory management and sizes(内存就是王)

D) general operating system health

E) database writer performance

答案: D

38、Which three are true about Rapid Home Provisioning(调配) (RHP), which has been available

since Oracle 18c?

A) It can be used to deploy(部署) Grid Infrastructure homes, including Oracle Restart.

B) It is an Oracle Grid Infrastructure service

C) It is an Oracle Database service

D) It cannot be used to provision middleware(中间件).

E) It cannot be used to provision applications(应用)

F) It can be used to deploy(部署) Oracle Database homes.

答案: ABF

39、You want to transport the UNIVERSIRY tablespace from one database to another.

The universiry tablespace is currently open read/write

The source and destination platforms have the same endian format.

Examine this list of steps:

1. Make the UNIVERSIRY tablespace read-only on the source system

剩余53页未读，继续阅读

Benjamin1109

粉丝: 47
资源: 3

Oracle数据库19c闪回日志空间回收与服务器生成警报特性解析

000-083最新题库分享

Java SCWCD 310-083 考试资源压缩包解析

计算机基础知识精选试题解析

计算机基础知识试题与解析

Linux基础知识考核题目与解析

计算机基础知识精选试题与解析

计算机基础知识试题与解析精华

计算机基础知识试题与答案解析

计算机基础知识精选试题与解析概览

事业单位计算机基础知识试题与解析

最新资源