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.examcheets.com.
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
C. If hash joins are enabled, no other join method
can be used.
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