ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-09-04 16:31:01
A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE.C)It only contains the alert log.E)It includes diagnostic data for critical errors for client processes.Answer: BF在 Oracle 的 11g 版本中，alert 文件的位置发生了变化，与此同时 Oracle 提供了一个命令行工具 ADRCI，它可以.........【阅读全文】
发布时间：2019-09-04 15:33:40
A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.C) Its location is always set by the ORACLE_BASE variable.Answer: DADR (Automatic Diagnostic Repository) ，ADR 是一个基于文件的资料档案库，用于存放数据库诊断数据(如跟踪、意外事件转储和程序包、预警日志、健康状况.........【阅读全文】
发布时间：2019-08-30 14:39:35
A)It improves database performance by automatically implementing Oracle ‘s best practices.C)It can be used by executing the PL/SQL procedures in the DBMS_ADDM package.E)It provides recommendations to improve database performance.Answer: CDEADDM(Automatic Database Diagnostic Monito.........【阅读全文】
发布时间：2019-08-29 13:24:46
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_areaenddate DATE,Which three statements are true about rows inserted into REPORT_WORK_AREA?B)Rows will be lost upon session failure.D)Rows are visible to all sessions logged in by all users granted the DBA role until the session that i.........【阅读全文】
发布时间：2019-08-28 13:27:28
Which two methods will achieve this?B)Use an Oracle Loader type External table.D)Use a CLOB column in a table to access the flat file.Answer: AB外部表可以实现通过数据库对象直接访问目录文件里的格式数据，加载方式分为两种 oracle_loader 和oracle_datapump。oracle_loader 方式通过 sqlldr .........【阅读全文】
