08 2019 档案
摘要：Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Oracle ‘
阅读全文
摘要：Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Whic
阅读全文
摘要：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
阅读全文
摘要：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 sup
阅读全文
摘要：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
阅读全文
摘要：You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2';
阅读全文
摘要：Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE audit
阅读全文
摘要：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 execute suc
阅读全文
摘要：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 o
阅读全文
摘要：You want to audit update statements that refer to USER1.DEPT.DNAME. Which type of auditing must you use? A)standard auditing B)mandatory auditing C)va
阅读全文
摘要：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 EM
阅读全文
摘要：Which two statements are true regarding the Oracle Data Pump export and import operations? (choose two) A)You cannot export data from a remote databas
阅读全文
摘要：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, i
阅读全文
摘要：Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answer: E 赵： 题
阅读全文
摘要：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 Answer:
阅读全文
摘要：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)MOUNT A
阅读全文
摘要：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
阅读全文
摘要：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 Or
阅读全文
摘要：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
阅读全文
摘要：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_
阅读全文
摘要：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 c
阅读全文
摘要：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 tabl
阅读全文
摘要：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 Oracle Load
阅读全文
摘要：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 Answer:
阅读全文
摘要：11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。 对于这些052考试新题，不仅老师给出了答案，学员也积极的找资料、查文档，形成了一份内部综合版本，
阅读全文
摘要：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 alway
阅读全文
摘要：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
阅读全文
摘要：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 ROLL
阅读全文
摘要：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 dirty buf
阅读全文
摘要：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 LG
阅读全文
摘要：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 c
阅读全文
摘要：Which three are true about AWR snapshots? A)They are always created automatically. B)They are always created manually. C)They are generated If statist
阅读全文
摘要：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 fo
阅读全文
