OCP最新考试题库解析之052考试原题-9-20180803
052题库解析,最新15道题 052-题库解析-9-20180803,题库新特点:, 最新052题库,按知识点分类,方便大家学习每周五晚8点-直播地址:ke.qq.com/course/326223 ocp考试讨论群:836361015 验证:ocp CUUG整理,官网:www.cuug.com,十三.Audit,32. 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) value-based auditing D) ne-grained auditing,Answer:D,33. 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 individual database users. D) DDL statements can be audited when they fail to execute. E) All Oracle auditing operations occur by default. F) DML statements can be audited when they execute successfully.,Answer:CDF,34. 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 successfully. C) All Oracle auditing operations occur by default. D) No Oracle auditing operations occur by default. E) DDL statements can be audited when they fail to execute. F) Some auditing is active before the database is open. G) Audit records are never stored in the database. H) Audit records are always stored in the database.,Answer:ABEF,34. Examine this session output:,SQL> connect scott/tiger Connected.,SQL> select name,value 2 from v$parameter,3 where name = 'audit_trail',NAME - - audit_trail DB,VALUE,SQL> audit all on emp; Audit succeeded.,Which two will generate an audit record ?,A) every UPDATE statement executed by SCOTT that updates SCOTT.EMP. B) every DDL statement executed by SCOTT that affects SCOTT.EMP. C) any DML statement executed by SYS on SCOTT.EMP. D) only the rst SELECT statement executed by SCOTT in a session on SCOTT.EMP,E) every UPDATE statement executed by SCOTT that updates HR.EMP,Answer:AB,十.DBlink 36. you successfully executed these commands: connect scott/tigerprod1; CREAET DATABASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING 'PROD2',Which type of database link is created?,A) private current user database link B) public connected user database link C) public current user database link D) private xed user database link E) public xed user database link,Answer:D,十五.External Table,37. 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 data to external tables.,E) DML operations may be performed on external tables.,Answer:D,CREATE TABLE scott.countries_ext,ORGANIZATION EXTERNAL,(,TYPE Oracle_DATAPUMP,DEFAULT DIRECTORY dir -生成dmp文件存放路径 LOCATION ('countries_ext.dmp') -生成外部文件的名称 ),AS SELECT * FROM scott.countries; -数据来源于实体表,38. 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 have extents.,E) They support all DML operations.,Answer:AC,39. You want to access employee details contained in at les created by an application. Which two methods will achieve this? A) Use a BFILE column in a table to access the at le. B) Use an Oracle Loader type External table. C) Use an Oracle Data Pump type External table. D) Use a CLOB column in a table to access the at le. E) Use a LONG RAW column in a table to access the at le.,Answer:AB,Flat File:平面文件,我们平常见到的txt、csv等都属于平面文件。,六.Temporary table,40. 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 into REPORT_WORK_AREA? A) Rows will be lost if a ROLLBACK is done. B) Rows will be lost upon session failure. C) Rows are visible to all sessions logged in by the same user until the session that inserted the rows terminates. D) Rows are visible to all sessions logged in by all users granted the DBA role until the session that inserted the rows terminates. E) Rows will be lost upon session normal termination. F) Rows are visible globally to all sessions logged in by any user until the session that inserted the rows terminates.,Answer:ABE,delete rows用于事务相关,也就在事务结束后truncate data in the temporary table. preserve rows表示在会话结束后清除临时表的数据,前者在事务提交后数据就已经清除了,后者在会话中止时或者导常退出时数据都会被清除掉,十七.ADDM,41. 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 diagnosing database instance startup failures. C) It can be used by executing the PL/SQL procedures in the DBMS_ADDM package. D) It runs automatically after each Automatic Workload Repository snapshot is created. E) It provides recommendations to improve database performance. F) Its ndings are accessible only by using Oracle Enterprise Manager.,Answer:CDE,