OCP-052 & 053有的答案解析

       在nomount阶段,仅运维“DB Structure
Integrity”检查,而且它只检查控制文件的实现性。

The server forcefully terminates the client connection after integer cumulative bad packets. The server protects
itself at the expense of the client (for example, a client transaction
may be lost). The client may reconnect and attempt the same
operation.

58. Baseline Templates

3.tnsping命令不检查和测试服务器上的监听的劳动名,所以tnsping通,不意味着就能联网。

       在mount阶段,“DB Structure
Integrity”检查将检查控制文件、联机重做日志文件和数据文件头的完整性,还可运转“Redo
Integrity Check”,以检讨联机和归档日志文件的可访问性及其是不是受损。

14.
共享池首要回顾以下4个零部件:库缓存(库缓存是内部存款和储蓄器区域,按其已分析的格式存款和储蓄近来进行的代码);数据字典缓存(它存款和储蓄近期应用的靶子定义:表、索引、用户和其他元数据定义的描述);PL/SQL区(存款和储蓄的PL/SQL对象是进程、函数、打包的长河、打包的函数、对象类型定义和触发器。它们统统像源代码那种存款和储蓄在数量字典中,也应用已编译的个数);SQL查询和PL/SQL函数结果缓存

1> DB_SECUREFILE specifies whether or not to treat LOB files as
SecureFiles.DB_SECUREFILE = { NEVER | PERMITTED | ALWAYS | IGNORE }

38.
DB_EXTENDED:与DB的职能大约相同,然而包罗生成审核记录的、具有绑定变量的SQL内容

51.

You can use a repeating baseline template to create and drop baselines
based on a repeating time schedule. This is useful if you want Oracle
Database to automatically capture a contiguous time period on an ongoing
basis. For example, you may want to capture the AWR data during every
Monday morning for a month. In this case, you can create a repeating
baseline template to automatically create baselines on a repeating
schedule for every Monday, and automatically remove older baselines
after a specified expiration interval, such as one month.

      DISABLE NOVALIDATE
能够输入任何数据(无论是不是符合供给),表中恐怕早已存在不合乎需要的多寡

If the UNDO_TABLESPACE parameter is omitted, the first available undo
tablespace in the database is chosen. If no undo tablespace is
available, the instance will start without an undo tablespace. In such
cases, user transactions will be executed using the SYSTEM rollback
segment. You should avoid running in this mode under normal
circumstances.

90.
DRA只可以用于单实例数据库的条件。它无法用来RAC群集数据库,也不能够用于Data
Guard备用数据库

  • DATA_ONLY

    • DB_BLOCK_CHECKING will be set to MEDIUM.

    • DB_LOST_WRITE_PROTECT will be set to TYPICAL.

    • DB_BLOCK_CHECKSUM will be set to FULL.

66.
手动管理SGA的参数如下:SHARED_POOL_SIZE,DB_CACHE_SIZE,LARGE_POOL_SIZE,STREAMS_POOL_SIZE,JAVA_POOL_SIZE。要启用
   
SGA自动管理,则须要将上述参数设置为0,并安装SGA_TAMuranoGET来启用自动共享内部存款和储蓄器管理(automatic
shared memory management,ASSM)

132. 

      DISABLE VALIDATE
那种情景不容许:表中有所数据都适合约束,但新行未必如此。最终结果是本着DML命令锁定表

125. CHANGE FAILURE in RMAN,enables
you to change priority or close failures recorded in the Automatic
Diagnostic Repository.

  1. GRANT ANY OBJECT
    PXC60IVILEGE(授予任何对象权限):允许被授权人将其本身不富有的指标的目的权限授予别人,但无法给予自个儿。

  2. ENABLE VALIDATE
    无法输入违反约束的行,而且表中的拥有行都符合约束

       只可以在分化阶段运转不一致的Health Monitor检查:

2> DB_ULTRA_SAFEOracle, sets the default values for other parameters that
control protection levels.DB_ULTRA_SAFE = { OFF | DATA_ONLY |
DATA_AND_INDEX },

198. RMAN supports two basic types
of duplication: active database duplication and backup-based duplication

26. 

     
 在open阶段,大概运行扫描各种数据块是不是受损的自作者批评,并检查数据字典和撤除段的完整性。 

UNDO_TABLESPACE specifies the undo tablespace to be used when an
instance starts up. If this parameter is specified when the instance is
in manual undo management mode, then an error will occur and startup
will fail.

1> SEC_PROTOCOL_ERROR_FURTHER_ACTION specifies the further
execution of a server process when receiving bad packets from a possibly
malicious client.

You can replace an undo tablespace with another undo tablespace while
the instance is running.

OCP~052**
**

52. 

2.tnsping命令监听服务器上的监听是还是不是已开启

3> (DROP,``integer``)

2> SEC_PROTOCOL_ERROR_FURTHER_ACTION = { CONTINUE | (DELAY,``integer``) | (DROP,``integer``) }

You can use a single baseline template to create a baseline for a single
contiguous time period in the future. This technique is useful if you
know beforehand of a time period that you intend to capture in the
future. For example, you may want to capture the AWR data during a
system test that is scheduled for the upcoming weekend. In this case,
you can create a single baseline template to automatically capture the
time period when the test occurs.

      ENABLE NOVALIDATE
表中得以存在不合乎需求的数据,但明天输入的具有数据必须符合供给

140. Health
Monitor是一组检查,会在特定错误条件出现时自动运维,也能够根据DBA的指令以手动格局运维。检查结果不存款和储蓄在数据库,而存储在文件系统
中。其缘由在于,一些错误的习性决定了数据库不再可用:由此,须要3个外表知识库来存款和储蓄Health
Monitor的结果。该知识库正是ADOdyssey。

You can also create baselines for a contiguous time period in the future
using baseline templates. There are two types of baseline templates:
single and repeating.

1.tnsping 命令能够检查tcp协议是还是不是已通,俗称大家说的互联网通不通

OCP~053

相关文章