cnblogs_5359

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