OracleOCP-052 & 053部分答案解析

OCP~052**
**

  1. GRANT ANY OBJECT
    PRIVILEGE(授予任何对象权限):允许吃授权人将那个本人不富有的目标的靶子权限授予他人,但不能够给予好。

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

      DISABLE NOVALIDATE
可以输入任何数据(无论是否符合要求),表中或许早就存在不合乎要求的多少

      ENABLE NOVALIDATE
表中好是不合乎要求的数据,但今天输入的有数据必须符合要求

      DISABLE VALIDATE
这种状况不可能:表中存有数据还入约束,但新行未必这么。最终结出是本着DML命令锁定表

14.
合享池主要包括以下4个零部件:库缓存(库缓存是内存区域,按其曾分析的格式存储最近实施之代码);数据字典缓存(它存储最近采用的目标定义:表、索引、用户以及其余元数据定义之叙说);PL/SQL区(存储的PL/SQL对象是过程、函数、打包之长河、打包的函数、对象类型定义和触发器。它们均像源代码那种存储在数码字典中,也采用就编译的个数);SQL查询和PL/SQL函数结果缓存

26. 

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.

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.

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

38.
DB_EXTENDED:与DB的打算大致相同,不过包含生成审核记录之、具有绑定变量的SQL内容

90.
DRA只能用来单实例数据库的环境。它不可知用来RAC群集数据库,也未能够用于Data
Guard备用数据库

132. 

1.tnsping 命令可以检查tcp协议是否业已接,俗称我们说之大网通不通

2.tnsping命令监听服务器上的监听是否曾被

3.tnsping命令不检测服务器上之监听的服务名,所以tnsping通,不意味就能够联网。

OCP~053

51.

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

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

3> (DROP,``integer``)

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.

52. 

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

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

  • 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.

58. Baseline Templates

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.

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.

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.

66.
手动管理SGA的参数如下:SHARED_POOL_SIZE,DB_CACHE_SIZE,LARGE_POOL_SIZE,STREAMS_POOL_SIZE,JAVA_POOL_SIZE。要启用
   
SGA自动管理,则需要以上述参数设置为0,并设置SGA_TARGET来启用自动共享内存管理(automatic
shared memory management,ASSM)

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

140. Health
Monitor凡是平等组检查,会以一定错误条件出现时自动运行,也足以因DBA的指示以手动智运行。检查结果未存储在数据库,而存储于文件系统
中。其原因在,一些谬误的性质决定了数据库不再可用:因此,需要一个表知识库来囤积Health
Monitor的结果。该知识库就是ADR。

       只能在不同等级运行不同之Health Monitor检查:

       在nomount阶段,仅运行“DB Structure
Integrity”检查,而且它不过检查控制文件之完成性。

       在mount阶段,“DB Structure
Integrity”检查用检查控制文件、联机重开日志文件及数据文件头的完整性,还只是运行“Redo
Integrity Check”,以检讨并和归档日志文件之只是访问性及其是否受损。

     
 在open阶段,可能运行扫描每个数据块是否受损的检查,并检查数据字典和注销段的完整性。 

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

相关文章