Oracle OCP 19c 认证1Z0-083考试(第56-61题) - #必中

Which two are true about server-generated alerts? (Choose two.) A. Stateful alerts must be created by a DBA after resolving the problem. B. Stateless alerts can be purged manually from the alert history.

C.    Stateless alerts can be cleared manually.

D.    Stateless alerts are automatically cleared.

E.    Stateful alerts are purged automatically from the alert history.

Answer: BC

(解析:答案 A 的意思是如果解决了问题,dba 最好是创建一个预警机制,以防后患。有状 态的度量警告如果发生了,清除的方法是如何解决相关的底层问题,如果问题解决,则把告 警信息移动到历史表中,以后会自动清除。)

18、Which three are located by using environment variables? (Choose three.)

A.    the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
B.    the location of Oracle Net Services configuration files
 
C.    the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
D.    default directories for temporary files used by temporary tablespaces

E.    the temporary disk space used by Oracle Installer during installation

F.    the maximum number of database files that can be opened by a database instance Answer: ABE(56 道)
(解析:本道题的题目描述的不够清晰,不知道环境变量指的是什么,我们暂且理解为用户 的环
境变量,如果是这样子的话,那么能够影响的内容就是 ABE 三个答案。) 
19、Which three are true about opatch auto? (Choose three.)

A.    It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

B.    It must be invoked by a user with root user privileges.

C.    Patches are applied via opatchauto.

D.    Users must always input patch plans to opatchauto.

E.    It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

F.    It applies patches in nonrolling mode by default.

G.    It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: ABG

(解析: opatchauto 是 oracle 滚动式升级的一个重要方式,非常的方便。) 1. For each Oracle RAC database home and the GI home that are being patched run the following commands as the home owner to extract the OPatch utility.

$ unzip <OPATCH-ZIP> -d <ORACLE_HOME>

$ <ORACLE_HOME>/OPatch/opatch version

2.    OCM Configuration

$ export GRID_HOME

$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp <specify_the_location>/file.rsp

-no_banner

-output
 
3.    Validation of Oracle Inventory

Before beginning patch application, check the consistency of inventory information for GI home and each database home to be patched. Run the following command as respective Oracle home owner to check the consistency.

$ <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>

4.    Stop EM Agent Processes Prior to Patching and Prior to Rolling Back the Patch $
<ORACLE_HOME>/bin/emctl stop dbconsole

5.    Patching Oracle RAC Database Homes and GI Together

GI Home and the Database Homes that are not shared and ACFS file system is not configured. As root user, execute the following command on each node of the cluster:

# opatch auto <UNZIPPED_PATCH_LOCATION>/27475913 -ocmrf <ocm response file>

6.    Loading Modified SQL Files into the Database SQL> @?/rdbms/admin/catbundle.sql psu apply SQL> @?/rdbms/admin/utlrp.sql

20 、 Which two are true about the character sets used in an Oracle database? (Choose two.) A. Single-byte character sets provide better performance than multibyte character sets.

B. Unicode enables information from any language to be stored using a single character set. C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

D.    Single-byte character sets always use 7-bit encoding schemes.

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.

Answer: AB

(解析:本题考试超出 ocp 的范围,考相关编码的信息,单字节字符集在存储性能方面比多字节要好)
为了获得最佳性能,请选择一个避免字符集转换并对所需语言使用最有效编码的字符集。单字节字符集比多字节字符集具有更好的性能,并且在空间需求方面也是最有效的。但是,单字节字符集限制了可以支持的语言数量。

单字节 7 位编码方案最多可定义 128 个字符,通常只支持一种语言。7 位 ASCII 中定义的唯 一字符是 26 个拉丁字母字符。在 7 位 ASCII 中的某些字符(通常是标点符号)替换为特定 语言所需的附加字母数字字符时,还使用了其他各种 7 位方案。

单字节 8 位编码方案最多可定义 256 个字符,通常支持一组语言。例如,iso8859/1 支持许 多西欧语言。
 
亚洲语言需要多字节编码方案,因为这些语言使用数千个字符。双字节编码方案最多可支持65536 个字符。一些多字节编码方案使用最高有效位的值来指示一个字节是表示单字节字符 还是双字节字符的第一个或第二个字节。在其他方案中,控制代码区分单字节字符和双字节 字符。移位代码表示在遇到代码移位之前,以下字节是双字节字符。

有两组通用的编码方案,一组基于 7 位 ASCII,另一组基于 IBMEBCDIC。在每个组中,所有 方案通常对 26 个拉丁字符(A 到 Z)使用相同的编码,但对英语以外的语言中使用的其他字 符使用不同的编码。ASCII 和 EBCDIC 使用不同的编码,甚至拉丁字符也是如此。

Unicode 称为 UTF-16。后来为了双字节的 Unicode 能够在现存的处理单字节的系统上正确传输,出现了 UTF-8(注意 UTF-8 是编码,它属于 Unicode 字符集),使用类似 MBCS 的方式对Unicode 进行编码。UTF-8 以字节为编码单元,没有字节序的问题。UTF-16 以两个字节为编码单元。

unicode 字符集,编码长度是可变的,并且是 ASCII 字符集的严格超集,也就是说 ASCII 中每 个字符的编码在 UTF-8 中是完全一样的。UTF-8 字符集中,一个字符可能是 1 个字节,2 个字节,3 个字节或者 4 个字节长。一般来说,欧洲的字母字符长度为 1 到 2 个字节,而亚洲 的大部分字符则是 3 个字节,附加字符为 4...

21、Which three are true about monitoring waits for sessions and services? (Choose three.)

A.    V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

B.    V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

C.    V$SESSION_WAIT _CLASS displays waits broken down by wait class only for waiting sessions.

D.    V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

E.    V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

F.    V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Answer: BCF

(解析:有关会话等待的信息都包含在上面显示的视图中。) 
22 、 You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write.
 
The source and destination platforms have different endian formats. Examine this list of actions:
1.    Make the UNIVERSITY tablespace read-only on the source system.

2.    Export the UNIVERSITY tablespace metadata using EXPDP.

3.    Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.

4.    Copy the UNIVERSITY tablespace data files to the destination system.

5.    Copy the Data Pump dump set to the destination system.

6.    Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7.    Import the UNIVERSITY tablespace metadata using IMPDP.

8.    Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A. 1, 2, 4, 5, 7, 8

B. 1, 2, 4, 6, 7, 8

C. 1, 2, 3, 4, 5, 7, 8

D. 1, 2, 3, 4, 5, 6, 7, 8

E. 2, 4, 5, 6, 7

Answer: C(解析:异构平台表空间迁移,需要进行转换编码。顺序如答案 B 所述。)