Oracle OCP 19c 认证1Z0-083考试(100-110题) #7月最新

最新推荐文章于 2023-03-10 11:19:59 发布

原创

最新推荐文章于 2023-03-10 11:19:59 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-083 #oracle19c #19c ocp

本文详细解析了Oracle OCP 19c认证考试1Z0-083中的多项选择题，涉及PDB关闭与回滚、AWR、ADDM、PDB创建、RMAN诊断输出、内存管理、数据库恢复等多个关键知识点，旨在帮助考生理解和准备考试。

Examine this configuration:

1. CDB1 is a container database.

2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these commands successfully:

Which two are true? (Choose two.)

A. Uncommitted transactions in PDB1 have been rolled back.

B. PDB1 is closed.

C. Uncommitted transactions in CDB1 and PDB1 have been rolled back. D. CDB1 is shut down.

E. CDB1 is in MOUNT state Answer: AB
(解析:注意操作是在 pdb1 下,所以生效的范围在 pdb1.)
62、

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

A. ADDM can recommend shrinking the buffer cache.

B. ADDM can recommend extending the buffer cache.

C. By default, MMON creates an AWR snapshot every 30 minutes.

D. ADDM performs its analysis only when a DBA requests it.

E. By default, AWR snapshots are automatically purged after eight days.

F. AWR snapshots must be deleted when no longer required by ADDM.

Answer: ABE

(解析:ADDM 可以动态调整 sga 中各个组件的尺寸。)
63、

Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)
A. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

B. Add only the CREATE_FILE_DEST clause to the statement.

C. Set only the PDB_FILE_NAME_CONVERT parameter.

D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E. Enable only OMF.

F. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF) Answer: BCE (解析:
This example assumes the following factors:

· Storage limits are not required for the PDB. Therefore, the STORAGE clause is not required.

· The PDB does not require a default tablespace.