Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

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

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

Options:

A.

REORG TABLE sales AND INDEXES ALL;

RUNSTATS ON TABLE sales AND INDEXES ALL;

B.

REORG TABLE sales INPLACE;

REORG INDEXES ALL FOR TABLE sales;

RUNSTATS ON TABLE salesAND INDEXES ALL;

C.

RUNSTATS ON TABLE sales AND INDEXES ALL;

REORGCHK ON TABLE sales;

D.

RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Question 3

What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

Options:

A.

SYSIBM

B.

SYSFUN

C.

SYSCAT

D.

SYSIBMADM