单选题
A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）
one server having at least two processors
two servers having one processor and one logical database partition
one server having four processors and two logical database partitions
two servers each having four processors and two logical database partitions
单选题
Which server houses the database partitions in the AIX BCU V2.1? （）
IBM System p5 570
IBM System p5 575
IBM System p5 590
IBM System p5 595
单选题
If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）
All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.
Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.
Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.
A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
多选题
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
单选题
What would indicate intra-partition parallelism in an Optimizer Plan?（）
BTQ
LTQ
IP
DTQ
单选题
A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）
Code the application to issue a LOCK TABLE statement.
Code the application to issue a LOCK ROW statement.
Decrease the number of I/O servers.
Increase the locklist parameter.
单选题
Which registry variable should be set to keep the buffer pools in memory on AIX and Linux?（）
DB2_KEEP_BP
DB2_PINNED_BP
DB2MEMDISCLAIM
DB2MEMMAXFREE
单选题
Which action(s) will cause a compression dictionary to be removed from a table?（）
Set the table COMPRESS attribute to NO.
Set the table COMPRESS attribute to NO; run REORG against the table.
Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.
Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
单选题
A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）
db2advis -d proddb -i workload.sql -P
db2advis -d proddb -i workload.sql -partitioning
db2advis -d proddb -i workload.sql -m P
db2advis -d proddb -i workload.sql -m ALL
多选题
Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful?（）
INTRA_PARALLEL NO
MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
MAX_AGENTS 100, MAX_CONNECTIONS 2000
MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
INTRA_PARALLEL YES
推荐考题
-
下列属于直线行驶的是（）
-
某通信机房设置七氟丙烷预制灭火系统，该系统应有( )种启动方式。
-
唐后期书院产生的一个原因是受到（）的影响。
-
压力损失是指（）
-
干旱区造林，整地的主要目的是（）
-
治癫证痰气郁结证，治以（）
-
小学低、中年级的儿童____识记发展最为迅速。
-
（ ）是北京市制定的第一个全面保护历史文化名城的法规。
-
安全带的正确使用：使用前作外观检查，若破损应（）使用。
-
Your network consists of a single Active Directory domain. The domain contains more than 300 group objects. The group objects are divided between several regional organizational units (OUs). You need to create a list of all groups that have names that begin with the word Sales. Which command should you use? （）