- 博客(69)
- 收藏
- 关注
RSS订阅转载 OCP-052考试题库汇总（47）-CUUG内部解答版
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)?A)It improves database performance b...
2019-08-30 14:39:38
105
转载 OCP-052考试题库汇总（46）-CUUG内部解答版
Examine this command:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area(startdate DATE,enddate DATE,cl...
2019-08-29 13:24:53
97
转载 OCP-052考试题库汇总（45）-CUUG内部解答版
You want to access employee details contained in flat files created by an application.Which two methods will ach...
2019-08-28 13:27:31
117
转载 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 a...
2019-08-28 11:32:29
87
转载 OCP-052考试题库汇总（43）-CUUG内部解答版
Which is true about external tables?A)Segments are allocated for external tables.B)They may have indexes.C)T...
2019-08-23 13:44:06
172
转载 OCP-052考试题库汇总（42）-CUUG内部解答版
You successfully executed these commands:connect scott/tiger@prod1;CREATE DATABASE LINK db_prod2CONNECT TO s...
2019-08-22 14:20:10
82
转载 OCP-052考试题库汇总（41）-CUUG内部解答版
Examine this session output:SQL> connect scott/tigerConnected.SQL>select name,value2 from v$paramete...
2019-08-22 13:32:26
97
转载 OCP-052考试题库汇总（40）-CUUG内部解答版
Which four are true about auditing?A)DML statements can be audited when they fail to executeB)Select statement...
2019-08-21 15:35:41
75
转载 OCP-052考试题库汇总（39）-CUUG内部解答版
Which three are true about auditing?A)Auditing is active only when the database is OPEN.B)Audit records are al...
2019-08-21 14:15:21
76
转载 OCP-052考试题库汇总（38）-CUUG内部解答版
You want to audit update statements that refer to USER1.DEPT.DNAME.Which type of auditing must you use?A)stand...
2019-08-20 10:31:28
74
转载 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 o...
2019-08-20 09:17:32
78
转载 OCP-052考试题库汇总（36）-CUUG内部解答版
Which two statements are true regarding the Oracle Data Pump export and import operations?(choose two)...
2019-08-19 13:18:22
70
转载 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 ...
2019-08-19 10:07:45
89
转载 OCP-052考试题库汇总（34）-CUUG内部解答版
Where is an expdp operation tracked?A)dump filesB)control fileC)log filesD)Automatic Dia...
2019-08-15 16:20:39
85
转载 OCP-052考试题库汇总（33）-CUUG内部解答版
Which two can be exported by a non-administrative account by using Data Pump?A)directory objectsB)ta...
2019-08-15 15:36:42
64
转载 OCP-052考试题库汇总（32）-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ?A)NOMOUNTB)OPEN IN READ WRITE modeC)OPEN ...
2019-08-14 14:53:09
81
转载 OCP-052考试题库汇总（31）-CUUG内部解答版
which four are true about the tools used to administer Oracle database?A)the Data Pump utility can be used...
2019-08-14 13:22:16
86
转载 OCP-052考试题库汇总（30）-CUUG内部解答版
Which two are true about the Inventory directory?A)It is shared by all Oracle software installations on a ...
2019-08-13 14:22:08
65
转载 OCP-052考试题库汇总（29）-CUUG内部解答版
When does an incremental checkpoint occur ?A)when an online redo log switch occurs.B)when DBWn write...
2019-08-13 13:45:17
76
转载 OCP-052考试题库汇总（28）-CUUG内部解答版
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’.The para...
2019-08-12 15:26:53
64
转载 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....
2019-08-12 13:56:05
82
转载 OCP-052考试题库汇总（26）-CUUG内部解答版
Which three of these must be accessible to keep a database open?A)Control file.B)All members of a re...
2019-08-09 13:11:15
68
转载 OCP-052考试题库汇总（25）-CUUG内部解答版
Which four database objects never have any segments?A)A partitioned indexB)A view selecting from a p...
2019-08-09 10:51:11
48
转载 OCP-052考试题库汇总（24）-CUUG内部解答版
Which structure can span multiple data files?A)a bigfile tablespaceB)a permanent tablespaceC)a...
2019-08-08 11:43:50
51
转载 OCP-052考试题库汇总（23）-CUUG内部解答版
11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。对于这些0...
2019-08-08 10:53:21
91
转载 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...
2019-08-05 11:27:20
57
转载 OCP-052考试题库汇总（19）-CUUG内部解答版
Which three events always result in a write request made to the LGWR process?A)after undo is applied by PM...
2019-08-05 10:16:20
60
转载 OCP-052考试题库汇总（18）-CUUG内部解答版
Which two events always request the LGWR to write?A)When DBWn writes dirty buffers.B)When a log swit...
2019-08-02 13:10:44
64
转载 OCP-052考试题库汇总（17）-CUUG内部解答版
Which four are true about the Automatic Workload Repository (AWR)?A)AWR data can be retained for a month....
2019-08-02 11:36:09
93
转载 OCP-052考试题库汇总（16）-CUUG内部解答版
Which three are true about AWR snapshots?A)They are always created automatically.B)They are always c...
2019-08-01 10:37:16
430
转载 OCP-052考试题库汇总（15）-CUUG内部解答版
Which two are true about AWR snapshots?A)They are stored in the SYSAUX tablespace.B)They are always ...
2019-08-01 09:25:20
49
转载 OCP-052考试题库汇总（14）-CUUG内部解答版
Which three are true about the Automatic Workload Repository (AWR)?A)AWR data is stored in the SYSTEM tabl...
2019-07-31 11:10:12
62
转载 OCP-052考试题库汇总（13）-CUUG内部解答版
Which three are true about the Automatic Workload Repository (AWR)?A)AWR data is stored in the SYSTEM tabl...
2019-07-31 09:45:04
50
转载 OCP-052考试题库汇总（12）-CUUG内部解答版
Which three are true about the Automatic Workload Repository (AWR)?A)AWR data is stored in the SYSAUX tabl...
2019-07-30 11:20:56
70
转载 OCP-052考试题库汇总（11）-CUUG内部解答版
Which two are true about Optimizer Statistics?A)They are gathered by the Manageability Monitor(MMON) backg...
2019-07-30 09:19:15
88
转载 OCP-052考试题库汇总（10）-CUUG内部解答版
Which two are true about Oracle's Optimizer statistics?A)They are automatically updated when ddl statement...
2019-07-29 11:14:44
101
转载 OCP-052考试题库汇总（9）-CUUG内部解答版
Which three are true about Optimizer Statistics?A)They can be gathered manuallyB)They are automatica...
2019-07-29 10:36:22
80
转载 OCP-052考试题库汇总（8）-CUUG内部解答版
Which two are true about PL/SQL objects? A)They must be in an invalid state to be recompiled. B)...
2019-07-26 11:06:45
56
转载 OCP-052考试题库汇总（7）-CUUG内部解答版
Which is true about invalid PL/SQL objects? A)They are automatically recompiled against the new definit...
2019-07-26 10:15:08
59
转载 OCP-052考试题库汇总（6）-CUUG内部解答版
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U • PASSWORD_REU...
2019-07-25 14:01:37
69
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人