【OCP-062】1Z0-062最新考试题库解析-第1次课
-
资源ID:89054928
资源大小:19.26KB
全文页数:7页
- 资源格式: DOCX
下载积分:0金贝
快捷下载
账号登录下载
微信登录下载
微信扫一扫登录
1、金锄头文库是“C2C”交易模式,即卖家上传的文档直接由买家下载,本站只是中间服务平台,本站所有文档下载所得的收益全部归上传人(卖家)所有,作为网络服务商,若您的权利被侵害请及时联系右侧客服;
2、如你看到网页展示的文档有jinchutou.com水印,是因预览和防盗链等技术需要对部份页面进行转换压缩成图而已,我们并不对上传的文档进行任何编辑或修改,文档下载后都不会有jinchutou.com水印标识,下载后原文更清晰;
3、所有的PPT和DOC文档都被视为“模板”,允许上传人保留章节、目录结构的情况下删减部份的内容;下载前须认真查看,确认无误后再购买;
4、文档大部份都是可以预览的,金锄头文库作为内容存储提供商,无法对各卖家所售文档的真实性、完整性、准确性以及专业性等问题提供审核和保证,请慎重购买;
5、文档的总页数、文档格式和文档大小以系统显示为准(内容中显示的页数不一定正确),网站客服只以系统显示的页数、文件格式、文档大小作为仲裁依据;
6、如果您还有什么不清楚的或需要我们协助,可以点击右侧栏的客服。
|
下载须知 | 常见问题汇总
|
【OCP-062】1Z0-062最新考试题库解析-第1次课
【CUUG内部资料】OCP讨论群:1015267481【OCP-062】1Z0-062最新考试题库解析-第1次课序:OCP11g认证即将结束,12c已经越来越热,考试共分为3个科目:071、062、063,071的题库解析已经上传,这次整理的是062的考试题,虽然考题多变、不断的增加新题,但有了下面的这些考题,相信会对广大考生有帮助作用,顺利通过OCP考试。QUESTION 1Examine the parameters for your database instance:NAME TYPE VALUE- - -undo_management string AUTOundo_retention integer 1200undo_tablespace string UNDOTBS1You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?A. Undo data is written to flashback logs after 1200 seconds.B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lackof space in the undo tablespace.C. You can perform a Flashback Database operation only within t he duration of 1200 seconds.D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwritethe undo before that time has elapsed.Correct Answer: DSection: (none)Explanation 验证过QUESTION 2A user establishes a connection to a database instance by using an Oracle Net connection. Youwant to ensure the following:1. The user account must be locked after five unsuccessful login attempts.2. Data read per session must be limited for the user.3- The user cannot have more than three simultaneous sessions.4. The user must have a maximum of 10 minutes session idle time before being logged offautomatically.How would you accomplish this?A. by granting a secure application role to the userB. by implementing Database Resource ManagerC. by using Oracle Label Security optionsD. by assigning a profile to the userCorrect Answer: DSection: (none)Explanation 验证过QUESTION 3As a user of the ORCL database, you establish a database link to the remote HQ database suchthat all users in the ORCL database may access tables only from the SCOTT schema in the HQdatabase. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remoteHQ database.Which command would you execute to create the database link?A. CREATE DATABASE LINK HQ USING 'HQ'B. CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ' SC. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ'D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ'Correct Answer: CSection: (none)Explanation 验证过QUESTION 4What happens if a maintenance window closes before a job that collects optimizer statisticscompletes?A. The job is terminated and the gathered statistics are not saved.B. The job is terminated but the gathered statistics are not published.C. The job continues to run until all statistics are gathered.D. The job is terminated and statistics for the remaining objects are collected the next time themaintenance window opens.Correct Answer: DSection: (none) Explanation在数据库一直打开的情况下,GATHER_STATS_JOB会伴随维护窗口一起被启动,默认情况下如果到维护窗口关闭该JOB仍未结束则将被终止(这取决于该JOB的属性stop_on_window_close),剩下的有待收集信息的对象将在下一个维护窗口中得到处理;如果数据库一直处于关闭的状态,并在某维护窗口的时间范围内该DB被打开,那么相应的维护窗口会被立即激活(ACTIVE),同时GATHER_STATS_JOB自动作业也会被启动,但该自动作业仅会在一个窗口中自动运行一次。QUESTION 5You plan to create a database by using the Database Configuration Assistant (DBCA), with t hefollowing specifications:Applications will connect to the database via a middle tier.l The number of concurrent user connections will be high.l The database will have mixed workload, with t he execution of complex BI queriesscheduled at night.Which DBCA option must you choose to create the database?A. a General Purpose database template with default memory allocationB. a Data Warehouse database template, with t he dedicated server mode option and AMMenabledC. a General Purpose database template, with t he shared server mode option and AutomaticMemory Management (AMM) enabledD. a default database configurationCorrect Answer: CSection: (none)ExplanationExplanation/Reference:QUESTION 6Which two statements are true about the logical storage structure of an Oracle database?A. An extent contains data blocks that are always physically contiguous on disk.B. An extent can span multiple segments,C. Each data block always corresponds to one operating system block.D. It is possible to have tablespaces of different block sizes.E. A data block is the smallest unit of I/O in data files.Correct Answer: DEQUESTION 7Which two statements correctly describe the relationship between data files and logicaldatabase structures?A. A segment cannot span data files.B. A data file can belong to only one tablespace.C. An extent cannot span data files.D. The size of an Oracle data block in a data file should be the same as the size of an OS block.Correct Answer: BCSection: (none)QUESTION 8Which statement is true about the Log Writer process?A. It writes when it receives a sig