- 博客(65)
- 收藏
- 关注
RSS订阅转载 OCP-052考试题库汇总（54）-CUUG内部解答版
USER1 grants SELECT and UPDATE privileges on USER1.EMP to USER2。SYS executes this command：SQL> REVOKE SELECT ON user1.emp FROM user1;What will be the outcome?A)It will succeed and USER2 will be...
2019-09-11 10:47:52
168
转载 OCP-052考试题库汇总（53）-CUUG内部解答版
USER1 grants SELECT, INSERT, and UPDATE privileges on USER1.EMP to USER2.Sys executes this command:SQL> REVOKE UPDATE ON user1.emp FROM user1;What will be the outcome?A)It will fail because USE...
2019-09-10 13:03:16
133
转载 OCP-052考试题库汇总（52）-CUUG内部解答版
Your DB_RECOVERY_FILE_DEST_SIZE IS 8G,Currently,5G of the space is used of which 4G consists of obsolete backups, You execute this command;SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;What...
2019-09-10 09:27:57
156
转载 OCP-052考试题库汇总（51）-CUUG内部解答版
Your database is open in archive mode.LOG_archive_DEST is set to Fast Recovery Area (FRA) and It is 100% full when a log switch takes place.No alternative or optional archive destinations are define...
2019-09-09 13:17:29
155
转载 OCP-052考试题库汇总（50）-CUUG内部解答版
Which two are true about the Fast Recovery Area (FRA)?A)It should be larger than the database.B)Only consistent backups can be stored in the FRA.C)Space management in the FRA is influenced by the d...
2019-09-09 11:38:16
96
转载 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.B)It includes diagnostic data for critical errors for b...
2019-09-04 16:30:47
189
转载 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 only contains the alert log and trace files for backgr...
2019-09-04 15:34:36
59
转载 OCP-052考试题库汇总（47）-CUUG内部解答版
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)?A)It improves database performance by automatically implementing Oracle ‘s best practices.B)It can assist the DBA in diagn...
2019-08-30 14:39:20
86
转载 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 ROWS;Which three statements are true about rows inserted...
2019-08-29 13:24:33
81
转载 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 in a table to access the flat file.B)Use an Oracle Loa...
2019-08-28 13:27:10
52
转载 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)They support the ORACLE_DATAPUMP access driver.D)They hav...
2019-08-28 11:32:11
62
转载 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.D)The ORACLE_DATAPUMP access driver can be used to write...
2019-08-23 13:43:48
75
转载 OCP-052考试题库汇总（42）-CUUG内部解答版
You successfully executed these commands:connect scott/tiger@prod1;CREATE DATABASE LINK db_prod2CONNECT TO scott IDENTIFIED BY tigerUSING 'PROD2';Which type of database link is created?A)private...
2019-08-22 14:19:52
237
转载 OCP-052考试题库汇总（41）-CUUG内部解答版
Examine this session output:SQL> connect scott/tigerConnected.SQL>select name,value2 from v$parameter3 where name='audit_trail';NAME VALUEaudit_trail DBSQL> audit all on emp;Audit s...
2019-08-22 13:32:04
99
转载 OCP-052考试题库汇总（40）-CUUG内部解答版
Which four are true about auditing?A)DML statements can be audited when they fail to executeB)Select statements can be audited when they execute successfully.C)All Oracle auditing operations occur ...
2019-08-21 15:35:17
70
转载 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)Audit of the use of system privileges can be enabled for ...
2019-08-21 14:14:57
110
转载 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 auditingB)mandatory auditingC)value-based auditingD)fine-grained auditingAnswer:...
2019-08-20 10:31:06
64
转载 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 on EMP.MGR_NO.4.EMP_SEQ is a sequence used to generate...
2019-08-20 09:18:07
62
转载 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 database.B)You can rename tables during an import operat...
2019-08-19 13:18:06
114
转载 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 files, it overwrites them.B)It allows encryption to be pe...
2019-08-19 10:07:16
92
转载 OCP-052考试题库汇总（34）-CUUG内部解答版
Where is an expdp operation tracked?A)dump filesB)control fileC)log filesD)Automatic Diagnostic Repository(ADR)E)master table (MT)Answer: E赵：题译：哪里有一个 Exdp 操作跟踪?Master table 是一个临时 table，专门为 im...
2019-08-15 16:20:11
66
转载 OCP-052考试题库汇总（33）-CUUG内部解答版
Which two can be exported by a non-administrative account by using Data Pump?A)directory objectsB)tablesC)tablespacesD)schemasE)databaseAnswer: BD
2019-08-15 15:36:12
105
转载 OCP-052考试题库汇总（32）-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ?A)NOMOUNTB)OPEN IN READ WRITE modeC)OPEN IN READ ONLY modeD)OPEN IN RESTRICTED modeE)MOUNTAnswer: E赵：题译：数据库必须是哪个状态才能启用 ARCHIVELOG?oracle 启...
2019-08-14 14:52:37
74
转载 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)SRVCTL can be used to shut down Oracle instances.C)SQL* Plu...
2019-08-14 13:21:51
101
转载 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 for Oracle Grid Infrastructure and Oracle Database softw...
2019-08-13 14:21:36
74
转载 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 processing.C)when the ALTER SYSTEM CHECKPOINT statement is ...
2019-08-13 13:46:02
92
转载 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 DB_RECOVERY_FILE_DEST, and not specified.Which four ...
2019-08-12 15:27:34
67
转载 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 the current redo log group.D)spfile.E)TEMP tablespace...
2019-08-12 13:56:42
62
转载 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)SYSAUX tablespace.E)spfileAnswer: ABC赵：1 nomount：实例已经启...
2019-08-09 13:13:36
98
转载 OCP-052考试题库汇总（25）-CUUG内部解答版
Which four database objects never have any segments?A)A partitioned indexB)A view selecting from a populated tableC)An empty indexD)An Oracle Loader type external tableE)An empty tableF)A v...
2019-08-09 10:54:08
70
转载 OCP-052考试题库汇总（24）-CUUG内部解答版
Which structure can span multiple data files?A)a bigfile tablespaceB)a permanent tablespaceC)a segmentD)a temporary tablespaceE)an extentAnswer: C
2019-08-08 11:43:25
77
转载 OCP-052考试题库汇总（23）-CUUG内部解答版
11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。对于这些052考试新题，不仅老师给出了答案，学员也积极的找资料、查文档，形成了一份内部综合版本，通过分数非常高，一起渡过这次052考试的难关。052考试题-23（OCP考试题库讨论群：101-...
2019-08-08 10:52:59
95
转载 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 always used during instance recovery.D)They archive re...
2019-08-07 11:15:46
81
转载 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 recovery.C)They automatically delete obsolete archive log...
2019-08-07 10:32:36
67
转载 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 ROLLBACK occurs.C)LGWR never writes a single COMMIT t...
2019-08-05 11:26:59
116
转载 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 recoveryB)when dirty buffers are found during the processing of a checkpoi...
2019-08-05 10:15:54
202
转载 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)When LGWR is notified by a server process that performs a...
2019-08-02 13:11:20
77
转载 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 of columns in each view.C)Automatic AWR snapshots can...
2019-08-02 11:35:41
81
转载 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 statistics_level is set to basic.D)They are generated If...
2019-08-01 10:37:01
118
转载 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 retained forever.D)They can be modified by using DMLs.E)The...
2019-08-01 09:24:58
92
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人