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

When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

• A.All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
• B.When crash recovery is occurring on the standby cluster.
• C.When the primary database is not connected to the standby database.
• D.When all the log streams are in peer or assisted remote catchup state.

Which statement about expression-based indexes is true?

• A.The RUNSTATS command cannot be used to collect statistics for expression-based indexes.
• B.The index key values of expression-based indexes are not the same as the values in the corresponding table columns.
• C.Expression-based index keys consist of a concatenation of one or more specified table columns.
• D.Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.

Which scenario does NOT require intraquery parallelism?

• A.The addition of a primary key constraint to an empty column-organized table.
• B.The execution of the LOAD command against an empty column-organized table.
• C.A DML operation that references a populated column-organized table.
• D.The execution of the RUNSTATS command against a populated column-organized table.

Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?

• A.ASYNC
• B.SUPERSYNC
• C.SYNC
• D.NEARSYNC
• E.SUPERASYNC