Free IBM C2090-611 Exam Dumps Questions & Answers

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 UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE configuration parameter for the database toYES.
• 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 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.
• D.  Use the ALTER DATABASE statement to add storage paths to the database.

Which command is used to export connectivity configuration information from a file known as a configuration profile?

• A.  db2ca
• B.  db2cfexp
• C.  db2cfgexp
• D.  db2cfimp

Which statement about DB2 aggregate registry variables is true?

• A.  A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.
• B.  An aggregate registry variable that is explicitly set by an application cannot be overwritten.
• C.  An aggregate registry variable overrides any corresponding explicitly set registry variable.
• D.  A registry variable that is explicitly set by an application can only be overwritten by aggregate registry variable.

Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

• A.  DBADM
• B.  SQLADM
• C.  SYSADM
• D.  SECADM

Which statement about insert time clustering tables (ITC) is true?

• A.  ITC tables are supported in DB2 pureScale environments.
• B.  ITC tables cannot be range-partitioned tables.
• C.  If an ITC table is clustered by one or more user specified dimensions, the specified dimensions must be timestamps.
• D.  Rows of an ITC table are clustered by the time they are inserted into the table.