Some candidates like to print, others prefer software, and many study on a phone. That is why Fast2test offers the 000-544 practice questions as a printable PDF, a desktop test engine that simulates the real exam environment, and an online test engine that runs in any browser — pick whichever fits the way you prepare for the IBM DB2 9.7 Advanced DBA for LUW.

IBM 000-544 Exam Overview:

IBM 000-544 Exam Syllabus Topics:

000-544 Exam FAQ: What Candidates Ask About IBM DB2 9.7 Advanced DBA for LUW

IBM DB2 9.7 Advanced DBA for LUW Sample Questions:

Question 1

A user with Security Administrator (SECADM) authority executes the following statements:

If user USER2 queries the table S.TAB1, how many rows will be returned?

A. 0
B. 2
C. 3
D. 1

Question 2

The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

A. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))
B. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (yearmonth))
C. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (yearmonth))
D. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (year))

Question 3

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.
B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
D. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.

Question 4

Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY

A. Any time after 11:07:04 am
B. Any time after 11:02:03 am
C. Any time after 11:07:03 am
D. Any time before 11:07:03 am

Question 5

Which conditions must be met to implement HADR?

A. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
B. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
C. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).
D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

Solutions: