C2090-611 試験問題を無料オンラインアクセス

If the following statement is executed:

What indexes will be created for table TAB1?

• A.3 dimension-block indexes and 1 composite-block index
• B.1 dimension-block index and 3 composite-block indexes
• C.3 dimension-block indexes and 3 composite-block indexes
• D.1 dimension-block index and 1 composite-block index

A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?

• A.Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.
• B.Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.
• C.Set the DISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.
• D.Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.

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

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

Which SQL data type CANNOT be used to store XML indexed values?

• A.DECIMAL
• B.DOUBLE
• C.INTEGER
• D.REAL

Which tool should be used to collect data during a potential hang without stopping the database manager?

• A.db2fodc
• B.db2cklog
• C.db2ls
• D.db2dart