C2090-600 Online Practice Questions and Answers

Which of the following enables the user to connect to the HADR standby database and execute select statements?

A. DB2_HADR_ROS

B. HADR_SPOOL_LIMIT

C. DB2_HADR_SOSNDBUF

D. DB2_HADR_PEER_WAIT_LIMIT

Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

A. ALTER TABLE tab1 APPEND ON

B. ALTER TABLE tab1 DROP COLUMN col1

C. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL

D. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1

E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

What does dsmtop use to gather metrics?

A. db2pd

B. db2dart

C. the system catalog

D. monitoring tablefunctions

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

A. Authentication

B. Roles and privileges

C. Mandatory access control

D. Discretionary access control

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

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

Which statement about the db2move command is TRUE?

A. The LOAD actions can be run from a client machine.

B. Object ownership cannot be changed after a successful schema copy operation.

C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

D. Loading data into tables containing XML columns is only supported for the LOAD actions.

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

A. db2val

B. db2set

C. db2look

D. db2greg

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.

C. Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

Which of the following statements is TRUE?

A. REORGCHK automatically runstables reorganization.

B. REORGCHK uses only current table and index statistics.

C. REORGCHK can only be used for user tables, not for system tables.

D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

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

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).

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.)

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.

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. LOAD

B. INGEST

C. IMPORT

D. TRANSPORT

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?

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 璱 DB2_FMP_COMM_HEAPSZ=256000

D. As the db2 instance owner (db2inst1)execute the command:db2set 璱 db2inst1 DB2_FMP_COMM_HEAPSZ=256000

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

A. CONNECT TO mydbPRUNE HISTORY TO /outdir

B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir

D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump

Which statement about NOT ENFORCED unique constraints is TRUE?

A. NOT ENFORCED unique constraints can not be defined on primary key columns

B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned

D. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index