What would indicate intra-partition parallelism in an Optimizer Plan?（）

A、BTQ  

B、LTQ  

C、IP  

D、DTQ

Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)

It detects changes in SQL execution plans.

It produces results that can be used to create the SQL plan baseline.

The importance of SQL statements is based on the size of the objects accessed.

It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

It shows only the overall impact on workload and not the net SQL impact on workload.

In which two environments would intra-partition parallelism be used? （）

Single database partition, single processor  

Single database partition, multiple processors  

Multiple database partitions, single processor  

Multiple database partitions, multiple processors

Which action(s) will cause a compression dictionary to be removed from a table?（）

A、Set the table COMPRESS attribute to NO.  

B、Set the table COMPRESS attribute to NO; run REORG against the table.  

C、Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.  

D、Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

在URL中不填写协议类型，IE浏览器默认使用（）协议。

A、FTP

B、Gopher

C、File

D、HTTP

A DNS server for a large network is experiencing performance problems.  Which of the following options is the best solution to fix the problem？（）

A、Enable NIS

B、Purchase a larger server

C、Use /etc/hosts on all of the systems

D、Create secondary name servers throughout the network