CertsTopics Logo

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

IBM C2090-600 Dumps

Page: 1 / 2
Total 60 questions
Get C2090-600 Full Access Download C2090-600 PDF

IBM DB2 11.1 DBA for LUW Questions and Answers

Question 1

When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

Options:

A.

The routine cannot contain comments.

B.

The routine must return either an integer or a null.

C.

The routine must be cross-compatible with Oracle PL/SQL syntax rules.

D.

The routine cannot contain argument lists or variable arguments (varargs).

E.

The routine must be generated with IBM Database Conversion Workbench (DCW).

Question 2

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.

Question 3

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 4

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 5

If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

Options:

A.

1

B.

2

C.

3

D.

4

Question 6

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

Question 7

Where does the DB2 Problem Determination tool (db2pd) get information from?

Options:

A.

DB2memory sets

B.

the db2diag.log file

C.

Monitoring table functions

D.

A set of pre-defined event monitors

Question 8

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

Options:

A.

REORG TABLE sales INPLACE RESETDICTIONARY

B.

REORG TABLE sales INPLACE REBUILDDICTIONARY

C.

REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

D.

REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Question 9

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

Options:

A.

SYSIBM

B.

SYSFUN

C.

SYSCAT

D.

SYSIBMADM

Page: 1 / 2
Total 60 questions
Get C2090-600 Full Access Download C2090-600 PDF