网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
- A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
- B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
- C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
- D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
参考答案
更多 “When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（） A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management” 相关考题
考题
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.D. Either B or C
考题
Distribution layer: This layer includes LAN－based routers and layer 3 switches . When is a first－hop redundancy protocol needed in the distribution layer?()
A. OSPF is not supported by the designB. HSRP is not supported by the designC. preempt tuning of the default gateway is neededD. the design implements Layer 3 between the access switch and the distribution switch
考题
With our new Quick Pay system, your monthly subscription fee will be debited automati-cally from the bank account of your__________.A.choice
B.choose
C.choices
D.chose
考题
What stanza file does a system administrator view to determine what kernel-tuning parameter changes were made when the system was last booted？（）A、/etc/rc.netB、/etc/tunables/tuningC、/etc/tunables/lastbootD、/usr/samples/kernel/nextboot
考题
When is a first-hop redundancy protocol needed in the distribution layer?（）A、when HSRP is not supported by the designB、when multiple vendor devices need to be supportedC、when preempt tuning of the default gateway is neededD、when a robust method of backing up the default gateway is neededE、when the design implements Layer 2 between the access switch and the distribution switchF、when the design implements Layer 3 between the access switch and the distribution switch
考题
When is a first-hop redundancy protocol needed in the distribution layer？（）A、 when the design implements Layer 2 between the access arid distribution blocksB、 when multiple vendor devices need to be supportedC、 when preempt tuning of the default gateway is neededD、 when a robust method of backing up the default gateway is neededE、 when the design implements Layer 2 between the access switch and the distribution blocksF、 when the design implements Layer 2 between the access and distribution blocks
考题
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（） A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor
考题
When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）A、 Filter versionsB、 Filter loadsC、 Filter tasksD、 Filter options
考题
What happens when you run the SQL Tuning Advisor with limited scope？（） A、 Access path analysis is not performed for SQL statements.B、 SQL structure analysis is not performed for SQL statements.C、 SQL Profile recommendations are not generated for SQL statements.D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
考题
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）A、generating the SQL profileB、testing and accepting the SQL profileC、generating a list of candidate SQLs for tuningD、adding tuned SQL plans into the SQL plan baselineE、tuning each SQL statement in the order of importanceF、generating baselines that include candidate SQLs for tuning
考题
To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（） A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorB、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above
考题
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（） A、ADDMB、AWRC、Cursor CacheD、SQL Tuning SetsE、Flash Recovery Area
考题
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A、 DBMS_WORKLOAD_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_ADVISOR
考题
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）A、 generating the SQL profileB、 testing and accepting the SQL profileC、 generating a list of candidate SQLs for tuningD、 adding tuned SQL plans into the SQL plan baselineE、 tuning each SQL statement in the order of importance F、 generating baselines that include candidate SQLs for tuning
考题
To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（） A、 From the Advisor Central home page，select the tuning task from the Advisor Tasks section B、 From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task ResultsC、 From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task ResultsD、 Either B or C
考题
单选题Distribution layer: This layer includes LAN-based routers and layer 3 switches . When is a first-hop redundancy protocol needed in the distribution layer?（）A
OSPF is not supported by the designB
HSRP is not supported by the designC
preempt tuning of the default gateway is neededD
the design implements Layer 3 between the access switch and the distribution switch
考题
单选题You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A
DBMS_WORKLOAD_REPOSITORYB
DBMS_RESOURCE_MANAGERC
DBMS_SQLTUNED
DBMS_ADVISOR
考题
单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）A
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC
Use compression when performing tape backupsD
Configure multiple SBT channels
考题
单选题What stanza file does a system administrator view to determine what kernel-tuning parameter changes were made when the system was last booted？（）A
/etc/rc.netB
/etc/tunables/tuningC
/etc/tunables/lastbootD
/usr/samples/kernel/nextboot
考题
单选题现代智能建筑主要有三大系统组成，即：楼宇自控系统（Buiding Automati0n System，简称BAS）、通信自动化系统（Communication Automati0n System，简称CAS）、办公自动化系统（Office Automati0n System，简称0AS）。通常称为（）系统。A
5ASB
3ASC
7ASD
2AS
考题
单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?（）A
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC
Use compression when performing tape backupsD
Configure multiple SBT channels
考题
单选题To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）A
From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B
From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.C
From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.D
Either B or C
考题
单选题What happens when you run the SQL Tuning Advisor with limited scope？（）A
Access path analysis is not performed for SQL statements.B
SQL structure analysis is not performed for SQL statements.C
SQL Profile recommendations are not generated for SQL statements.D
Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
考题
单选题To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）A
EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorB
EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC
EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD
Either B or CE
All of the above
考题
单选题When is a first-hop redundancy protocol needed in the distribution layer？（）A
when the design implements Layer 2 between the access arid distribution blocksB
when multiple vendor devices need to be supportedC
when preempt tuning of the default gateway is neededD
when a robust method of backing up the default gateway is neededE
when the design implements Layer 2 between the access switch and the distribution blocksF
when the design implements Layer 2 between the access and distribution blocks
考题
单选题When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）A
Filter versionsB
Filter loadsC
Filter tasksD
Filter options
考题
多选题What happens when you run the SQL Tuning Advisor with limited scope?（）AAccess pathanalysis is not performed for SQL statements.BSQL structure analysis is not performed for SQL statements.CSQL Profile recommendations are not generated for SQL statements.DStaleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
考题
单选题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）A
ADDMB
AWRC
Cursor CacheD
SQL Tuning SetsE
Flash Recovery Area
热门标签
最新试卷