多选题
When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）
the query transaction rate
numeric data versus character data
extent size
the cardinality of the candidate columns
prefetch size
单选题
When is the connection concentrator enabled?（）
When the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENTS.
When the value of MAX_AGENTS is greater than the value of MAX_CLIENTS.
When the value of NUM_AGENTS is greater than the value of MAX_AGENTS.
When the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENTS.
单选题
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）
CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)
CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2)
CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)
CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）
单选题
Which data organization schemes are supported?（）
PARTITION BY HASH and ORGANIZE BY
PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE
PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE
PARTITION BY RANGE and ORGANIZE BY
单选题
If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）
All sorts will be done in a temporary table space.
The shared sort memory allocation will be calculated by DB2
No shared memory is allocated for sorting.
All sorts will be done in shared memory.
单选题
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）
CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)
CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3)
CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)
CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
推荐考题
-
下列属于直线行驶的是（）
-
某通信机房设置七氟丙烷预制灭火系统，该系统应有( )种启动方式。
-
唐后期书院产生的一个原因是受到（）的影响。
-
压力损失是指（）
-
干旱区造林，整地的主要目的是（）
-
治癫证痰气郁结证，治以（）
-
小学低、中年级的儿童____识记发展最为迅速。
-
（ ）是北京市制定的第一个全面保护历史文化名城的法规。
-
安全带的正确使用：使用前作外观检查，若破损应（）使用。
-
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? （）