Which two are true about PL/SQL objects? A)They must be in an invalid state to be recompiled. B)They can never be manually recompiled. C)They can be manually recompiled. ...
Which two are true about PL/SQL objects? A)They must be in an invalid state to be recompiled. B)They can never be manually recompiled. C)They can be manually recompiled. ...
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 Loader type external table ...E)An empty table ...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tablespace. B)Automatic AWR snapshots are created by the Manageability Monitor (MMON) back...
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 buffers are found during the processing of a c...
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U • PASSWORD_REUSE_MAX is 5 • PASSWORD_REUSE_TIME is 10 • PASSWORD_GRACE_TIME is 15 ...
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. ...
Which four statements are true about truncating a table? A)Any insert triggers for the table will be executed. B)Any of the table’s indexes are also truncated. C)Any delete triggers fo...
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. ...
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)spfile ...1 nom...
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 arc...
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 snaps...
Which is true about invalid PL/SQL objects? A)They are automatically recompiled against the new definition of a referenced object when they are called. B)They must be manually recompiled ...
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 ...
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance by automatically implementing Orac...
Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. B) It...
Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ...
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 ...
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...
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...
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; N...
Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) background process. B)They can be gathered ...
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...
11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。...
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...
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...
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...
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...