自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

转载 OCP-052考试题库汇总(49)-CUUG内部解答版

Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE. ...

2019-09-04 16:30:00

阅读数 134

评论数 0

转载 OCP-052考试题库汇总(48)-CUUG内部解答版

Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. B) It...

2019-09-04 15:33:00

阅读数 130

评论数 0

转载 OCP-052考试题库汇总(47)-CUUG内部解答版

Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Orac...

2019-08-30 14:39:00

阅读数 130

评论数 0

转载 OCP-052考试题库汇总(46)-CUUG内部解答版

Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ...

2019-08-29 13:24:00

阅读数 130

评论数 0

转载 OCP-052考试题库汇总(45)-CUUG内部解答版

You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column ...

2019-08-28 13:27:00

阅读数 131

评论数 0

转载 OCP-052考试题库汇总(44)-CUUG内部解答版

Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL. C)Th...

2019-08-28 11:32:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(43)-CUUG内部解答版

Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes. C)They do not support partitioning. ...

2019-08-23 13:43:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(42)-CUUG内部解答版

You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING �...

2019-08-22 14:20:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(41)-CUUG内部解答版

Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail&#...

2019-08-22 13:32:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(40)-CUUG内部解答版

Which four are true about auditing? A)DML statements can be audited when they fail to execute B)Select statements can be audited when they execut...

2019-08-21 15:35:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(39)-CUUG内部解答版

Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database. C)A...

2019-08-21 14:15:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(38)-CUUG内部解答版

You want to audit update statements that refer to USER1.DEPT.DNAME. Which type of auditing must you use? A)standard auditing B)mandatory auditin...

2019-08-20 10:31:00

阅读数 86

评论数 0

转载 OCP-052考试题库汇总(37)-CUUG内部解答版

Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.ENO. 3.EMP_IDX is an index...

2019-08-20 09:17:00

阅读数 89

评论数 0

转载 OCP-052考试题库汇总(36)-CUUG内部解答版

Which two statements are true regarding the Oracle Data Pump export and import operations? (choose two) A)You cannot export data from a remote da...

2019-08-19 13:18:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(35)-CUUG内部解答版

Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A)If the directory used in the export operation has existing dump file...

2019-08-19 10:07:00

阅读数 96

评论数 0

转载 OCP-052考试题库汇总(34)-CUUG内部解答版

Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answe...

2019-08-15 16:20:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(33)-CUUG内部解答版

Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)tables C)tablespaces D)schemas E)database ...

2019-08-15 15:36:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(32)-CUUG内部解答版

Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E...

2019-08-14 14:52:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(31)-CUUG内部解答版

which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files. B)SRVCT...

2019-08-14 13:21:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(30)-CUUG内部解答版

Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a single server. B)It is required only f...

2019-08-13 14:21:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(29)-CUUG内部解答版

When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal proce...

2019-08-13 13:45:00

阅读数 91

评论数 0

转载 OCP-052考试题库汇总(28)-CUUG内部解答版

Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and...

2019-08-12 15:27:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(27)-CUUG内部解答版

Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file. B)the password file. C)all members of...

2019-08-12 13:56:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(26)-CUUG内部解答版

Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSA...

2019-08-09 13:11:00

阅读数 90

评论数 0

转载 OCP-052考试题库汇总(25)-CUUG内部解答版

Which four database objects never have any segments? A)A partitioned index B)A view selecting from a populated table C)An empty index D)An Orac...

2019-08-09 10:50:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(24)-CUUG内部解答版

Which structure can span multiple data files? A)a bigfile tablespace B)a permanent tablespace C)a segment D)a temporary tablespace E)an extent...

2019-08-08 11:43:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(23)-CUUG内部解答版

11g版本的OCP考试持续了好几年,一直比较稳定,直到2018年4月份左右,052考试不断的出现新的考题,虽然我们收集整理了不少,但新题还是难避免,这样出现一部分新题,我们收集一部分,持续了不短的时间。 对于这些052考试新题,不仅老师给出了答案,学员也积极的找资料、查文档,形成了一份内部综...

2019-08-08 10:53:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(22)-CUUG内部解答版

Which four are true about the Archive (ARCn) processes? A)They might be used during instance recovery. B)They can create archivelogs. C)They are...

2019-08-07 11:15:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(21)-CUUG内部解答版

Which two are true about the Archive (ARCn) processes? A)They archive redo directly from the redo log buffer. B)They are used during instance rec...

2019-08-07 10:32:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(20)-CUUG内部解答版

Which two are true about LGWR? A)LGWR always writes to the redo logs each time a COMMIT occurs. B)LGWR always writes to the redo logs each time a...

2019-08-05 11:27:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(19)-CUUG内部解答版

Which three events always result in a write request made to the LGWR process? A)after undo is applied by PMON during process recovery B)when dirt...

2019-08-05 10:16:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(18)-CUUG内部解答版

Which two events always request the LGWR to write? A)When DBWn writes dirty buffers. B)When a log switch occurs. C)When a checkpoint occurs. D)...

2019-08-02 13:10:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(17)-CUUG内部解答版

Which four are true about the Automatic Workload Repository (AWR)? A)AWR data can be retained for a month. B)It includes statistics on the number...

2019-08-02 11:35:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(16)-CUUG内部解答版

Which three are true about AWR snapshots? A)They are always created automatically. B)They are always created manually. C)They are generated If s...

2019-08-01 10:37:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(15)-CUUG内部解答版

Which two are true about AWR snapshots? A)They are stored in the SYSAUX tablespace. B)They are always created automatically. C)They can be retai...

2019-08-01 09:25:00

阅读数 85

评论数 0

转载 OCP-052考试题库汇总(14)-CUUG内部解答版

Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace. B)By default, AWR snapshots ar...

2019-07-31 11:09:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(13)-CUUG内部解答版

Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace. B)By default, AWR snapshots ar...

2019-07-31 09:45:00

阅读数 88

评论数 0

转载 OCP-052考试题库汇总(12)-CUUG内部解答版

Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tablespace. B)Automatic AWR snapshots are ...

2019-07-30 11:20:00

阅读数 86

评论数 0

转载 OCP-052考试题库汇总(11)-CUUG内部解答版

Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) background process. B)They can be gathered ...

2019-07-30 09:18:00

阅读数 87

评论数 0

转载 OCP-052考试题库汇总(10)-CUUG内部解答版

Which two are true about Oracle's Optimizer statistics? A)They are automatically updated when ddl statements execute. B)They can be calculated...

2019-07-29 11:15:00

阅读数 88

评论数 0

提示
确定要删除当前文章?
取消 删除