Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

C2090-600 by Ibm - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

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, a warning will be returned
D Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Question 4

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 be compressed.
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.

Question 5

Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

A When the registry variable DB2_AUTORECLAIMSPACE=YES
B After termination all the back-end processes using TERMINATE command
C After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
D When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

Question 6

Which statement about label-based access control (LBAC) is TRUE?

A LBAC protection can be applied to a nickname
B LBAC cannot be used to restrict access to a staging table
C LBAC cannot be used to restrict access to data of columns and rows in the same table
D LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Question 7

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 sales AND INDEXES ALL;
C RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
D RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Question 8

Which of the following are valid Explain operators? (Choose two.)

A CTQ
B XSCAN
C IXSCAN
D SELECT
E COLSCAN

Question 9

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 mydb PRUNE HISTORY TO /outdir
B db2trc on –db mydb –m "backup,load" run the desired operations db2tc dump db2trc.dmp db2tc format db2tc.dmp db2tc.fmt db2tc off
C BACKUP DATABASE mydb NO TABLESPACE TO /outdir
D db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed). Run the desired operations.

Question 10

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

A SELECT tbsp_name, tbsp_utilization_percent FROM TABLE(sysproc.mon_tbsp_utilization()) AS t WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 1;
B SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 0;
C SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 1;
D SELECT tbsp_name, tbsp_utilization_percent FROM sysibmadm.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 2 • Questions 1-25 of 48

1 2

→

Know a question that should be here? Contribute to this exam

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

A Catalog a storage access alias in the DB2 database
B Create an FTP account on IBM Softlayer Object Storage
C Use the DB2REMOTE parameter of the LOAD command
D Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
E Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity
(inserts, updates, and deletes).

Sunday Delta -

Monday Incremental -

Tuesday Delta -

Wednesday Delta -

Thursday Incremental -

Friday Delta -

Saturday Full -
Which day would you expect a RECOVER DATABASE following that days backup to take the longest time to complete?

A Friday
B Monday
C Saturday
D Wednesday