cnblogs_5359

摘要： 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 阅读全文

摘要： 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 阅读全文

摘要： 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 阅读全文