Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following C2090-600 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

IBM DB2 11.1 DBA for LUW Questions and Answers

Question 1

The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

Options:

A.

You can change the principal standby of the primary without first stopping HADR on the primary.

B.

The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

C.

You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

D.

You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

E.

You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary’s target list.

Buy Now
Question 2

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

Options:

A.

The PAGESIZE database configuration parameter is set to 32K.

B.

The AUTO_REORG database configurationparameter is set to NO.

C.

The DFT_EXTENT_SZ database configuration parameter is set to 8.

D.

The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

E.

The INTRA_PARALLEL database manager configuration parameter is set to NO.

Question 3

On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

Options:

A.

As the db2 instance owner (db2inst1) execute the command:

exportDB2_FMP_COMM_HEAPSZ=256000

B.

Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000

C.

As the db2 instance owner (db2inst1) execute the command:

db2set –i DB2_FMP_COMM_HEAPSZ=256000

D.

As the db2 instance owner (db2inst1)execute the command:

db2set –i db2inst1 DB2_FMP_COMM_HEAPSZ=256000