Oracle OCP 19c 认证1Z0-083考试(93-95题) #可下载

#完整版可于资源里下载

Which three are true about Optimizer Statistics Advisor? (Choose three.) A. It can be run only manually.

B.    It is part of the DBMS_ADVISOR package.

C.    It can recommend changes to improve the statistics gathering process.

D.    It always analyzes all schemas in the database.

E.    It runs automatically every night by default.

F.    It is part of the DBMS_STATS package.

Answer: CEF

(解析:DBMS_STATS 包已经扩展到包括与 advisor 交互的例程,答案 F 是对的;C 答案是会

给出建议;)

Reference: https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2 
54、You issued this command:

RMAN> BACKUP RECOVERY FILES;

Which two are true? (Choose two.)

A.    All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
B.    All non-Oracle files in the current FRA that have not been backed up already, are backed up.
C.    All Oracle r