![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle ocp 053 考试
hanllove001
老菜鸟。
展开
-
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考试第18题
18. You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task.To view the ADDM report, you use the following command:SQL> SELECT dbms_addm.get_report('my_i...原创 2018-11-16 09:01:15 · 221 阅读 · 0 评论 -
OCP考试第17题
17. The INV_HISTORY table is created using the command:SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))partition by range (inv_date)interval (numtoyminterv...原创 2018-11-14 23:26:49 · 211 阅读 · 0 评论 -
OCP考试第16题
16. Because of a logical corruption(堕落) in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR).But before you start the recovery, you queried the TS_PITR_OBJEC...原创 2018-11-14 23:01:52 · 311 阅读 · 1 评论 -
OCP考试第15题
15. You are in the process of creating a virtual private catalog in your Oracle Database 11g dcatabase.11g 创建vpcThe PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base...原创 2018-11-14 21:19:24 · 230 阅读 · 0 评论 -
OCP考试第14题
14. Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts ...原创 2018-11-14 19:39:43 · 175 阅读 · 0 评论 -
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考试第13题
13. View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance(意义) Level threshold type not available in the threshold setting?A. because AWR baseli...原创 2018-11-11 08:53:15 · 115 阅读 · 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考试第8题
8. Which statement is true regarding online redefinition(在线重定义) for the migration(迁移) of BasicFile LOBs to SecureFile LOBs?A. It cannot be done in parallel.支持并发,特别是分区表B. It can be done at the ta...原创 2018-11-07 15:59:48 · 263 阅读 · 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考试第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 评论 -
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考试第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考试第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考试题第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考试第19题
19. A PL/SQL procedure queries only those columns of a redefined(重定义) table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefiniti...原创 2018-11-22 08:48:46 · 341 阅读 · 0 评论