- 博客(224)
- 收藏
- 关注
RSS订阅转载 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
604
转载 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
560
转载 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
561
转载 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
542
转载 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
529
转载 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
371
转载 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
402
转载 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
358
转载 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'; N...
2019-08-22 13:32:00
387
转载 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
376
转载 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
357
转载 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
415
转载 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
412
转载 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
372
转载 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
417
转载 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
366
转载 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
362
转载 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
362
转载 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
370
转载 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
408
转载 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
380
转载 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
384
转载 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
439
转载 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
362
转载 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
340
转载 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
339
转载 OCP-052考试题库汇总（23）-CUUG内部解答版
11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。 对于这些052考试新题，不仅老师给出了答案，学员也积极的找资料、查文档，形成了一份内部综...
2019-08-08 10:53:00
378
转载 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
372
转载 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
341
转载 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
393
转载 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
337
转载 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
362
转载 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
364
转载 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
372
转载 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
347
转载 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
353
转载 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
362
转载 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
336
转载 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
392
转载 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 ex...
2019-07-29 11:15:00
357
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人