《CUUG内部OCP题库解析-052-文档9》由会员分享，可在线阅读，更多相关《CUUG内部OCP题库解析-052-文档9（20页珍藏版）》请在金锄头文库上搜索。
1、CUUG内部OCP题库解析-052-文档9题库新特点：oracle 11g版本的ocp认证考试题库，来自cuug整理，考试题大部分都在这里能找到，如果想考ocp认证可以参考这些文档。下面的题是（052考试-第9个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档9 7/17/19十三.Audit 32. You want to audit update statements that refer to USER1.DEPT.DNAME.Which type of auditing must you u
2、se?A) standard auditing B) mandatory auditing C) value-based auditing D) ne-grained auditingAnswer：DAdministrator CUUG内部OCP题库解析-052-文档9 7/17/1933. 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 t
3、he use of system privileges can be enabled for individualdatabase 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：CDFAdministrator CUUG内部OCP题库解析-052-文档9 7/17/19
4、34. Which four are true about auditing?A) DML statements can be audited when they fail to executeB) 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 w
5、hen 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：ABEFAdministrator CUUG内部OCP题库解析-052-文档9 7/17/1934. Examine this session output:SQL connect scott/tiger Connecte
6、d.SQL select name,value 2 from v$parameter3 where name = audit_trail;NAME VALUE- -audit_trail DBSQL audit all on emp; Audit succeeded.Administrator CUUG内部OCP题库解析-052-文档9 7/17/19Which two will generate an audit record ?A) every UPDATE statement executed by SCOTT that updates SCOTT.EMP.B) every DDL st
7、atement 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 onSCOTT.EMPE) every UPDATE statement executed by SCOTT that updates HR.EMPAnswer:ABAdministrator CUUG内部OCP题库解析-052-文档9 7/17/19十.DBlink36.
8、 you successfully executed these commands: connect scott/tigerprod1;CREAET DATABASE LINK db_prod2CONNECT TO scott IDENTIFIED BY tiger USING PROD2;Which type of database link is created? A) private current user database linkB) public connected user database linkC) public current user database link D)
9、 private xed user database link E) public xed user database linkAnswer：DAdministrator CUUG内部OCP题库解析-052-文档9 7/17/19Administrator CUUG内部OCP题库解析-052-文档9 7/17/19十五.External Table37. which is true about external tables? A) Segments are allocated for external tables. B) They may have indexes.C) They do n
10、ot support partitioning.D) The ORACLE_DATAPUMP access driver can be used to write data toexternal tables.E) DML operations may be performed on external tables.Answer：DCREATE TABLE scott.countries_extORGANIZATION EXTERNAL (TYPE Oracle_DATAPUMPDEFAULT DIRECTORY dir -生成dmp文件存放路径 LOCATION (countries_ext
11、.dmp) -生成外部文件的名称)AS SELECT * FROM scott.countries; -数据来源于实体表Administrator CUUG内部OCP题库解析-052-文档9 7/17/1938. 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.
12、D) They have extents.E) They support all DML operations.Answer：ACAdministrator CUUG内部OCP题库解析-052-文档9 7/17/19 39. You want to access employee details contained in at les created byan application. Which two methods will achieve this? A) Use a BFILE column in a table to access the at le. B) Use an Orac
13、le 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：ABFlat File:平面文件,我们平常见到的txt、csv等都属于平面文件。Administrator CUUG内部OCP题库解析-052-文档9 7/17/19六.Temporary table40. Exam
14、ine 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 intoREPORT_WORK_AREA?A) Rows will be lost if a ROLLBACK is done. B) Rows will be lost upon session failure.C) R
15、ows are visible to all sessions logged in by the same user until the sessionthat inserted the rows terminates.D) Rows are visible to all sessions logged in by all users granted the DBA roleuntil 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 thesession that inserted the rows terminates.Answer：ABEAdministrator CUUG内部OCP题库解析-052-文档9 7/17/19delete rows用于事务相关,也就在事务结束后truncate data in the temporary table.preserv
