摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
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
巴啦啦大魔王
阅读(112)
评论(0)
推荐(0)
摘要：
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)
摘要：
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)
摘要：
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)
摘要：
Exhibit: View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TA 阅读全文
posted @ 2017-11-17 10:23
巴啦啦大魔王
阅读(137)
评论(0)
推荐(0)
摘要：
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A. The user has dropped an important table that needs to 阅读全文
posted @ 2017-11-17 10:21
巴啦啦大魔王
阅读(142)
评论(0)
推荐(0)
摘要：
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but yo 阅读全文
posted @ 2017-11-17 10:20
巴啦啦大魔王
阅读(170)
评论(0)
推荐(0)
摘要：
Which statement is true regarding virtual private catalogs?A. A virtual private catalog owner can create a local stored script, and have read/write ac 阅读全文
posted @ 2017-11-17 10:19
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
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)
摘要：
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)
摘要：
Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or 阅读全文
posted @ 2017-11-17 10:14
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. 阅读全文
posted @ 2017-11-17 09:17
巴啦啦大魔王
阅读(144)
评论(0)
推荐(0)
浙公网安备 33010602011771号