《CUUG内部资料OCP最新考试题库-1Z0-062(1).pdf》由会员分享，可在线阅读，更多相关《CUUG内部资料OCP最新考试题库-1Z0-062(1).pdf（7页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、CUUGCUUG 内部资料内部资料 OCPOCP 最新考试题库最新考试题库-1Z0-1Z0-062(1)062(1)【CUUG 内部资料】OCP 讨论群：5267481【CUUG 内部资料】OCP 最新考试题库-1Z0-062(1)序：OCP认证是 Oracle 的一个中级认证，对于升职加薪跳槽都有很大的帮助，但是想考 OCP 证书其实有一定的难度，比如考试题的内容全部都是英文题、考题的内容会有稍微修改、考题的答案顺序并不固定、不定时的出现新考题等。这些都增加了考试的难度，所以我们收集了一些考试题并进行了讲解，这部分内容是关于12c-062 的考试解析，希望对广大考生有帮助。QUESTION1
2、 Examine the parameters for your database instance:NAME TYPE VALUE-undo_management string AUTO undo_retention integer1200 undo_tablespace string UNDOTBS1 You execute thefollowing mand:SQL ALTER TABLESPACE undotbs1 RETENTION第 1 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第1页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第1页NO
3、GUARANTEE;Which statement is true in this scenario?A.Undodata is written to flashback logs after1200 seconds.B.Inactive undo data is retained for1200 seconds even if subsequent transactions fail dueto lack of space in the undo tablespace.C.You can perform a Flashback Database operation onlywithin t
4、he duration of1200 seconds.D.An attempt is made to keep inactive undo for1200 seconds but transactions may overwrite the undobefore that time has elapsed.CorrectAnswer:D Section:(none)Explanation 验证过 QUESTION2 A user establishes a connection to a databaseinstance by using an Oracle connection.Youwan
5、t to ensure the following:1.Theuser account must be locked after five unsuccessfullogin attempts.2.Data read per session must be limited for the user.3-第 2 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第2页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第2页The user cannot have more than three simultaneoussessions.4.The user must
6、 have a maximum of10 minutes session idle time before being logged offautomatically.Howwould you acplish this?A.bygranting a secure application role to the user B.byimplementing Database Resource Manager C.byusing Oracle Label Security options D.byassigning a profile to the user Correct Answer:DSect
7、ion:(none)Explanation 验证过 QUESTION 3 As a userof the ORCL database,you establish a database link tothe remote HQ database such that all users in the ORCLdatabase may access tables only from the SCOTT schema inthe HQ database.SCOTTs password is TIGER.Theservice mane“HQ“is used to connect to the remot
8、eHQ database.Whichmand would you execute to create the database link?A.CREATEDATABASE LINK HQ USING HQ;B.CREATE第 3 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第3页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第3页DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ SC.CREATEPUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIEDBY
9、tiger USING HQ;D.CREATEDATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tigerUSING HQ;Correct Answer:C Section:(none)Explanation验证过 QUESTION 4 What happens if a maintenance windowcloses before a job that collects optimizer statisticspletes?A.Thejob is terminated and the gathered statistics are notsav
10、ed.B.The job is terminated but the gathered statistics arenot published.C.The job continues to run until all statistics aregathered.D.The job is terminated and statistics for theremaining objects are collected the next time themaintenance window opens.CorrectAnswer:D Section:(none)Explanation 在数据库一直
11、打开的情况下，GATHER_STATS_JOB 会伴随维护窗口一起被启动，默认情况下如果到维护窗口关闭该 JOB 仍未结束则将被终止(这取决于该 JOB 的属性 stop_on_window_close)，剩下的有待收集信息的第 4 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第4页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第4页对象将在下一个维护窗口中得到处理；如果数据库一直处于关闭的状态，并在某维护窗口的时间范围内该 DB 被打开，那么相应的维护窗口会被立即激活(ACTIVE)，同时 GATHER_STATS_JOB 自动作业也会被启动，但该自动
12、作业仅会在一个窗口中自动运行一次。QUESTION 5 You plan to create a database by using theDatabase Configuration Assistant(DBCA),with t hefollowing specifications:Applications will connect tothe database via a middle tier.lThe number of concurrent user connections will behigh.lThe database will have mixed workload,with
13、 t heexecution of plex BI queries scheduled at night.WhichDBCA option must you choose to create the database?A.aGeneral Purpose database template with default memoryallocation B.aData Warehouse database template,with t he dedicatedserver mode option and AMM enabled C.aGeneral Purpose database templa
14、te,with t he sharedserver mode option and Automatic Memory Management(AMM)enabled D.a第 5 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第5页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第5页default database configuration Correct Answer:CSection:(none)Explanation Explanation/Reference:QUESTION 6 Which two statements are true abou
15、t thelogical storage structure of an Oracle database?A.Anextent contains data blocks that are alwaysphysically contiguous on disk.B.An extent can span multiple segments,C.Eachdata block always corresponds to one operating systemblock.D.It is possible to have tablespaces of different blocksizes.E.A d
16、ata block is the smallest unit of I/O in datafiles.CorrectAnswer:DE QUESTION 7 Which two statements correctlydescribe the relationship between data files and logicaldatabase structures?A.Asegment cannot span data files.B.A data file can belong to only one tablespace.C.An extent cannot span data file
17、s.D.The size of an Oracle data block in a data fileshould be the same as the size of an OS block.Correct第 6 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第6页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第6页Answer:BC Section:(none)QUESTION 8 Which statement istrue about the第 7 页 共 7 页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第7页CUUG内部资料OCP最新考试题库-1Z0-062(1)-第7页