Braindumps of 000-704
DB2 UDB V8.1 for Linux,
UNIX and Windows Advanced Database
Exam Questions, Answers, Braindumps (000-704)
Thanks to www.exams.ws and www.examcheats.net
Q No: 1
When creating a regular DMS table space, what is the
minimum number of extents that must be specified?
Q No: 2
Given the following table definition and SQL statement
CREAT TABLE company
company_name VARCHAR (40)
amount_due Decimal (15,2)
WHERE amount_due =
SELECT MAX (amount_due) FROM company)"
Which index definition would provide the best performance
for the SQL statement?
A. CREATE INDEX i1 ON company (amount_due ASC)
B. CREATE INDEX i1 ON company (amount_due DESC)
C. CREATE INDEX i1 ON company (company_id,amount_due)
D. CREATE INDEX i1 ON company (amount_due DESC) INCLUDE(company_id)
Q No: 3
A table is defined using DMS table spaces with its index,
data, and long data separated into different table spaces.
The table space containing the table data is restored
from a backup image. Which of the table's other table
spaces must also be restored in order to roll forward
to a point in time prior to the end of the logs?
A. Long table space
B. Index table space
C. Temporary table space
D. Index and long table spaces
Q No: 4
Given the following DDL statement
CREATE TABLE "RMW" "TABEL46"
"D11" DECIMAL (1'0)NOT NULL'
"D12" DECIMAL (1'0) NOT NULL'
"C8" CHAR(1) WITH DEFAULT ' ')
organize by (
How many indexes will be created?
Q No: 5
Which of the following is required for the DB2 optimizer
to consider a hash join strategy?
A. Equijion predicates
B. Optimization level 1 or above
C. Registry variable DB_ANTIJOIN=YES
D. SORTHEAP large enough to contain the tables being
Q No: 6
Which two of the following table space attributes can
be changes after the table space has been created?
A. Page size
B. Extent size
C. Transfer rate
D. Table space type
E. Table space name
Q No: 7
The DBA can set the registry variable DB2_HASH_JOIN
on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can
D. Hash joins are only needed when the tables are portioned
using hash keys.
Q No: 8
Which of the following can be kept in memory when the
DB2 configuration parameter KEEPFENCED is enabled?
A. SQLDAS after their cursor is closed.
B. Referential integrity maps after a join.
C. Stored procedure processes after they are run.
D. Tables after they have been read into the buffer