C2090-600 Table Practice Questions

For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

Select 2 answers.

• AA. XML
• BB. BLOB
• CC. CLOB
• DD. VARCHAR
• EE. DATETIME

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

• AA. CONNECT TO mydb PRUNE HISTORY TO /outdir
• BB. db2trc on –db mydb –m “backup,load” run the desired operations db2tc dump db2trc.dmp db2tc format db2tc.dmp db2tc.fmt db2tc off
• CC. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
• DD. db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed). Run the desired operations. Afterwards, issue db2trc dump <outfile>

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

• AA. It does not acquire locks on the table
• BB. It does not require additional temporary disk space
• CC. It enables the user to control when the table will be offline
• DD. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

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

Select 2 answers.

• AA. ALTER TABLE tab1 APPEND ON
• BB. ALTER TABLE tab1 DROP COLUMN col1
• CC. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
• DD. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
• EE. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)