OCP - 随笔分类(第13页) - 巴啦啦大魔王

052-6

摘要：Note the following points describing various utilities in Oracle Database 11g:1. It enables the transfer of data from one database to another--数据泵(ben 阅读全文

posted @ 2017-12-01 10:40 巴啦啦大魔王阅读(161) 评论(0) 推荐(0)

052-5

摘要：The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity che 阅读全文

posted @ 2017-12-01 10:13 巴啦啦大魔王阅读(129) 评论(0) 推荐(0)

052-3

摘要：While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would 阅读全文

posted @ 2017-12-01 09:55 巴啦啦大魔王阅读(163) 评论(0) 推荐(0)

052-2

摘要：Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A. All AWR tables belong to the SYSTEM schemaB. The AWR cont 阅读全文

posted @ 2017-11-30 18:27 巴啦啦大魔王阅读(146) 评论(0) 推荐(0)

052-1

摘要：View the Exhibit and examine the attributes of an undo tablespace.In an OLTP system, the user SCOTT has started a query on a large table in the peak t 阅读全文

posted @ 2017-11-30 18:07 巴啦啦大魔王阅读(134) 评论(0) 推荐(0)

051-174

摘要：Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set of DML and DDL statements.B. A part 阅读全文

posted @ 2017-11-30 17:48 巴啦啦大魔王阅读(124) 评论(0) 推荐(0)

051-144

摘要：View the Exhibit and examine the structure of the PRODUCTS table.You want to display the category with the maximum number of items.You issue the follo 阅读全文

posted @ 2017-11-30 14:35 巴啦啦大魔王阅读(108) 评论(0) 推荐(0)

051-139

摘要：Which three statements are true about multiple-row subqueries? (Choose three.)A. They can contain a subquery within a subquery.B. They can return mult 阅读全文

posted @ 2017-11-30 14:11 巴啦啦大魔王阅读(126) 评论(0) 推荐(0)

051-133

摘要：Which two statements are true regarding subqueries? (Choose two.)(关于子查询哪两句话是正确的？)A. A subquery can retrieve zero or more rows.（子查询能检索 0 行或多行）B. Only t 阅读全文

posted @ 2017-11-30 13:38 巴啦啦大魔王阅读(100) 评论(0) 推荐(0)

051-127

摘要：Examine the data in the CUSTOMERS table: CUSTNO CUSTNAME CITY You want to list all cities that have more than one customer along with the customer det 阅读全文

posted @ 2017-11-29 18:20 巴啦啦大魔王阅读(147) 评论(0) 推荐(0)

053-附加题1

摘要：What happens if you shutdown abort ASM instance?A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance 阅读全文

posted @ 2017-11-17 13:40 巴啦啦大魔王阅读(159) 评论(0) 推荐(0)

053-159

摘要：Which package provides API's for the SQL Tuning Advisor?A. DBMS_MONITORB. DBMS_STATSC. DBMS_SQLTUNED. DBMS_ADVISOR 运行 SQL 调整顾问程序运行 SQL Tuning Advisor 阅读全文

posted @ 2017-11-17 13:32 巴啦啦大魔王阅读(130) 评论(0) 推荐(0)

053-509

摘要：Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)A. A single SQL statement provided by a userB. An ex 阅读全文

posted @ 2017-11-17 13:25 巴啦啦大魔王阅读(109) 评论(0) 推荐(0)

053-298

摘要：While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available.What would th 阅读全文

posted @ 2017-11-17 13:23 巴啦啦大魔王阅读(149) 评论(0) 推荐(0)

053-255

摘要：Which two statements about the SQL Management Base (SMB) are true? (Choose two.)A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It 阅读全文

posted @ 2017-11-17 13:21 巴啦啦大魔王阅读(141) 评论(0) 推荐(0)

053-253

摘要：You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL planbaseline. The STA generates a SQL profile for the SQL sta 阅读全文

posted @ 2017-11-17 13:19 巴啦啦大魔王阅读(182) 评论(0) 推荐(0)

053-493

摘要：Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose three.)A. It detects changes in SQL execution plans.B. 阅读全文

posted @ 2017-11-17 13:18 巴啦啦大魔王阅读(122) 评论(0) 推荐(0)

053-487

摘要：When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.Which two statements describe the 阅读全文

posted @ 2017-11-17 11:37 巴啦啦大魔王阅读(172) 评论(0) 推荐(0)

053-610

摘要：Which of the following advisors is run in every maintenance window by the auto-task system?A.The Memory AdvisorB.The SQL Tuning AdvisorC.The Undo Advi 阅读全文

posted @ 2017-11-17 11:21 巴啦啦大魔王阅读(144) 评论(0) 推荐(0)

053-61

摘要：Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance impr 阅读全文

posted @ 2017-11-17 11:13 巴啦啦大魔王阅读(133) 评论(0) 推荐(0)

随笔分类 - OCP

公告