UDB V8.1 for Linux, UNIX and Windows
Advanced Database Administration
Answers, Braindumps (000-704)
The exam is tough but the guide from www.exams.ws
was really helpful.
Q1: When creating a regular DMS table space, what
is the minimum number of extents that must be specified?
Q2: 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
Q3: 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
Q4: Which two of the following table space
attributes can be changes after the table space has
A. Page size
B. Extent size
C. Transfer rate
D. Table space type
E. Table space name
Q5: The DBA can set the registry variable
DB2_HASH_JOIN on or off because:
A. hash joins may require more resources
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.
Q6: Which of the following can be kept in
memory when the DB2 configuration parameter KEEPFENCED
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
Q7: In a 32-bit instance, to immediately create
a new buffer pool which of the following must the
DATABASE_MEMORY parameter be set to?
C. The size of the new buffer pool
D. At least the combined size of new and existing
Q8: Setting the configuration parameter INTRA_PARALLEL=YES
is required to allow DB2 to use multiple processors
for which of the following?
Q9: The FLUSH PACKAGE CACHE statement invalid
dates which of the following?
A. Stored procedures in the package cache.
B. Only static SQL statements in the package cache.
C. Only dynamic SQL statements in the package cache.
D. Both static and dynamic SQL statements in the package
Q10: A database is saved using online incremental
backups with the following schedule:
1 A full database backup on the first day of each
2 A cumulative backup on the fifteenth day of each
3 A nightly delta backup
Which of the following is the minimum set of backup
data required to restore a database to a point in
time on the fourteenth day of the month?
A. The full database backup image
B. The full database backup image, all delta images
for that month, and the logs
C. The full database backup image, the preceding cumulative,
and all delta images for that month
D. The full database backup image, the preceding cumulative,
all delta images for that month, and the logs
Q11: How do the ENCRYPT.DECRYPT_CHAR,DECRYPT_BIN
functions secure data?
A. By preventing casual browsing of table
B. By encrypting data that is following across the
C. By storing the encryption passwords in system catalogs.
D. By allowing only administrators to see the contents
of encrypted columns.