随笔分类 -  SQL

1 2 下一页
051-17
摘要：View the E xhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to da 阅读全文
posted @ 2017-12-20 15:42 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
051-15
摘要：View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDP 阅读全文
posted @ 2017-12-20 15:33 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
052-57
摘要：Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly becaus 阅读全文
posted @ 2017-12-07 15:18 巴啦啦大魔王 阅读(82) 评论(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)
053-44
摘要：You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance o 阅读全文
posted @ 2017-11-17 11:11 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
053-270
摘要：Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)A. Segment AdvisorB. SQL Access Adviso 阅读全文
posted @ 2017-11-17 11:10 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
053-123
摘要：What two statements are true regarding the recommendations received from the SQL Access Advisor?(Choose two.)A. It cannot generate recommendations tha 阅读全文
posted @ 2017-11-17 10:59 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0)
053-232
摘要：What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)A. selection of SQL plan baselinesB. part 阅读全文
posted @ 2017-11-17 10:58 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
053-262
摘要：In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)A. partitioning recommendations B. statistics colle 阅读全文
posted @ 2017-11-17 10:17 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
053-294
摘要：Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?A. Segment 阅读全文
posted @ 2017-11-17 10:15 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
053-38
摘要：The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL T 阅读全文
posted @ 2017-11-16 14:06 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
053-69
摘要：The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MIN 阅读全文
posted @ 2017-11-16 14:02 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)

1 2 下一页