C2090-600 Online Practice Questions and Answers

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

A. db2pd

B. db2dart

C. db2expln

D. db2advis

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

A. SYSIBM

B. SYSFUN

C. SYSCAT

D. SYSIBMADM

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 phase of the LOAD utility is unique to loading column organized tables?

A. LOAD

B. BUILD

C. DELETE

D. ANALYZE

Which statement regarding event monitors is TRUE?

A. Event monitor data can be reviewed while the event monitor is active

B. Event monitors must always be started manually after activating a database

C. Event monitors must write data to .EVT files before the data can be loaded into database tables

D. Event monitors are used to obtain information about how a database system looks at a specific point in time

What does dsmtop use to gather metrics?

A. db2pd

B. db2dart

C. the system catalog

D. monitoring tablefunctions

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

A. A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.

B. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.

C. A master key must be generated and placed in an existing local keystore before a new encrypted

database will be created.

D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

Which operation can be performed with trusted context privileges that are acquired through a role?

A. DML operations

B. DDL operations

C. Server maintenance operations

D. Security administration operations

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

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