C2090-611 Online Practice Questions and Answers

What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

A. Set

B. Tree

C. Group

D. Range

E. Hierarchy

What does the FLUSH PACKAGE CACHE statement do?

A. It removes all dynamic SQL statements from the package cache.

B. It removes only inactive SQL statements from the package cache.

C. It saves dynamic SQL stored in the package cache to an external file.

D. It causes all SQL statements in the package cache that are currently in use to be recompiled.

You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

A. Alter the view and add the ENFORCE SELECT clause to the view definition.

B. Drop and recreate the view with the WITH CHECK OPTION clause specified.

C. Alter the view and add the WITH CHECK OPTION clause to the view definition.

D. Create a new view with the same name and the ENFORCE SELECT clause specified.

Which statement about the db2pd tool is true?

A. It may retrieve data that is not completely accurate.

B. It collects information from the log buffer and active log files.

C. It ensures that information is not retrieved on changing data.

D. It collects information from the snapshot monitor and a predefined set of event monitors.

Which statement is true regarding the workload management dispatcher?

A. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.

B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.

C. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.

D. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.

A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO What is the recommended way to convert the database MYDB to an automatic storage database?

A. Use the ALTER DATABASE statement to add storage paths to the database.

B. Use the CREATE STOGROUP statement to define a new storage group in the database and to assign storage paths to the new storage group.

C. Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE configuration parameter for the database toYES.

D. Use the DROP DATABASE command to drop the database; then, recreate the database by executing a CREATE DATABASE commandstatement that does not contain the AUTOMATIC STORAGE NO option.

Which statement is true about Insert Time Clustering (ITC) tables?

A. An existing MDC table can be converted to an ITC table.

B. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.

C. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.

D. ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.

Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?

A. DB2LDAP

B. DB2AUTH

C. CLNT_PW_PLUGIN

D. SRVCON_PW_PLUGIN

Which statement is NOT true about a database restore operation?

A. A table space restore operation must be done offline.

B. A table space is not usable until the restore operation completes successfully.

C. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.

D. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.

What authorization is needed to use the AUDIT statement to create an audit policy?

A. DBADM

B. SYSADM

C. SECADM

D. SYSMAINT