C2090-600 Online Practice Questions and Answers

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

A. To prunethe contents of a staging table.

B. To prune the contents of a synopsis table.

C. To prune the contents of a materialized query table (MQT).

D. To prune the contents of a declared global temporary table.

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 of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

A. Select from the ADMIN_GET_ENCRYPTION_INFO table function

B. Run the db2ckbkp command and verify the compression settings

C. Checkthe encrypted database parameter in database configuration

D. Check ENCROPTS database configuration parameter for encryption options

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?

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;

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

A. All data, both new and existing, will becompressed.

B. Only new or updated data for XML columns will be compressed.

C. New and existing XML columns will be compressed but other columns remain unchanged.

D. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

What is the result of the following scenario?

A. The row is updated to (2, NULL)

B. The row is updated to (2, 110.00)

C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

What levels of authority are needed to create a storage group? (Choose two.)

A. DBADM

B. SYSADM

C. SQLADM

D. SYSCTRL

E. SYSMAINT

What does dsmtop use to gather metrics?

A. db2pd

B. db2dart

C. the system catalog

D. monitoring tablefunctions

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

A. It does not acquire locks on the table

B. It does not require additional temporary disk space

C. It enables the user to control when the table will be offline

D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

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

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

A. Set the DB2COMM registry variable to DB2COMM=SSL

B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

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

What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

A. NONE

B. LOCAL

C. DOMAIN

D. GLOBAL

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