OCP考试题详解
2018年10月053试题详解
hanllove001
老菜鸟。
展开
-
OCP考试第12题
12. You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.After some days, you want to change the status of the database backup and you issued the fol...原创 2018-11-08 20:43:30 · 558 阅读 · 0 评论 -
OCP考试第11题
11. View the Exhibit to examine the metrics(标准) with a threshold(阈值). Which statement is true regarding the Number of Transactions (per second) metric?A. Oracle uses statistical relevance to dete...原创 2018-11-08 19:58:59 · 275 阅读 · 0 评论 -
OCP考试第10题
10. Consider the following scenario(方案) for your database:Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most recent backup to disk for the TOOLS tablespac...原创 2018-11-08 19:30:41 · 213 阅读 · 0 评论 -
OCP考试第9题
9. Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only BasicFile LOB chunks.B. It returns space usage o...原创 2018-11-07 16:44:50 · 195 阅读 · 0 评论 -
OCP考试第7题
7. You need to configure fine-grained(细粒度) access control(访问控制) to external network resources from within(从....里面) your database.你需要配置从数据库里面配置细粒度访问外部访问网络资源You create an access control list (ACL) u...原创 2018-11-07 15:33:16 · 223 阅读 · 0 评论 -
OCP考试第6题
6. You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11.你工作在11g的一个数据库上,RCO11是catlog schema.The INST1 database contains an Oracle...原创 2018-11-06 16:00:46 · 233 阅读 · 0 评论 -
OCP考试第1题
1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describ...原创 2018-10-31 18:12:38 · 411 阅读 · 0 评论 -
OCP考试题第2题
2.You plan to have a larger moving window size(移动窗口大小) for the default system-defined moving window baseline because you want to use the adaptive threshold.你计划增加的移动窗口大小(AWR保留时间必须比他大,dba_hist_wr_cont...原创 2018-10-31 18:50:43 · 717 阅读 · 0 评论 -
OCP考试第3题
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:数据库为archive...原创 2018-11-01 20:33:26 · 234 阅读 · 0 评论 -
OCP考试第4题
4. Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)调度器用哪三个组件管理oracle环境的任务?A. a jobB. a programC. a scheduleD. a PL/SQL procedur...原创 2018-11-01 22:46:53 · 220 阅读 · 0 评论 -
OCP考试第5题
Examine the section of the Health Check report given below:检查如下的health check报告如下:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check M...原创 2018-11-02 20:47:43 · 489 阅读 · 0 评论