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

 Which three actions are performed by the Oracle Preinstallation RPM, oracle- database-server- xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
A.    performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
B.    creating the oracle OS user

C.    creating the OSDBA (dba) group

D.    creating thte oraInventory (oinstall) group

E.    creating the grid OS user

F.    configuring the OS for Oracle Automatic Storage Management shared storage
 
access

Answer: BCD  (第 1 道)

11、Which two are true about common objects? (Choose two.)

A.    They can be created only in CDB$ROOT.

B.    They can be only metadata-linked in an application container.

C.    They can exist in user-defined schemas only in application containers.

D.    They can exist in CDB$ROOT and an application root.

E.    They can be extended data-linked in CDB$ROOT.

F.    They can be created only in an application root. Answer: DF (第 19 道)
(解析:通用用户只能在 cdb$ROOT 容器中创建,但是可以存在于所有的容器,application root 也
是一个 pdb,只不过是可以包含其它 pdb 的 pdb。)

12 、 Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
A.    It analyzes a period of time corresponding to the 12 hours of activity.

B.    It runs automatically after each AWR snapshot.

C.    A DBA can run it manually.

D.    Results are written to the alert log.

E.    It analyzes a period of time corresponding to the last day of activity. Answer: BC(第 81 道)
(解析:ADDM 工具可以自动和手动运行,属于简单的考点)

13 、 You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

A.    Database Replay

B.    Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.    Active Session History (ASH) report D. SQL Performance Analyzer
 
Answer: B

(解析:诊断数据库性能的变化,可以对不同时期 AWR 产生的报告进行比较,也可以手动 用
addm 进行比较。)

14 、 You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance? A. Enable Memory Access Mode, which reads performance data from SGA.

B.    Use emergency monitoring to fetch data directly from SGA for analysis.

C.    Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D.    Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E.    Run ADDM in diagnostic mode.

Answer: B

(解析:该题与前面的某些题的意思差不多,采用的方法就是用 ADDM 去比较不同时期的 AWR 报告,只要新的 AWR 快照产生,那么 ADDM 就会自动运行,把当前最近的 AWR 快 照二个产生一个报告进行分析。)

15 、 You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.

How can you detect the cause of the degraded performance?

A.    by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B.    by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

C.    by using Active Session History (ASH) data and performing hang analysis D. by running ADDM in diagnostic mode

Answer: A

(解析:这道题也是有关性能调优的经典题目,用 ADDM 工具可以应用在很多场景,在这个 场景中使用它比较两个时间段的性能统计,类似于 awr 报告;A 答案是自动运行的方式。)

16、choose four Which four are true about performance-related Oracle tools?
 
A)    The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.

B)    SQL Performance Analyzer can suggest schema changes.

C)    SQL Performance Analyzer can identify regressed SQL statements.

D)    Database Replay always uses one replay client for all the original database sessions.

E)    Database Replay always uses one replay client for each original database session.

F)    The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods.

G)    The Active Session History (ASH) report is based on wait event samples.

Answer:ABCF

(解析:这道题把调优过程中能够用到的工具都做了总结,比较有实际意义。

ASH 每秒采样$session,记录会话等待的事件,不活动的会话不会被采样。这个采样工 具是 非常有效的,因为它直接访问 oracle 内部结构。ASH 缺省每一秒搜集一下活动会话的情况, 间隔时间由_ash_sampling_interval 参数确定。 由于数据量巨大,把所有的 ASH 数据写到 磁盘上是不可接受的。通常 60 分钟 mmon 进程会 写这些信息,当 ASH BUFFER 满的话 MMNL 进程就会写。