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

Given a system-period temporal table POLICY_INFO with its associated history table HIST_POLICY_INFO, which statement is true?

• A.When querying with no time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.
• B.When querying with no time period specification, only the HIST_POLICY_INFO table is queried.
• C.When querying with a time period specification, only the HIST_POLICY_INFO table is queried.
• D.When querying with a time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

What are two types of DB2 Discovery requests that a client can make? (Choose two.)

• A.KNOWN
• B.UNTRUSTED
• C.TRUSTED
• D.LOOKUP
• E.SEARCH

If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?

• A.Self-tuning is occurring only on the instance memory area.
• B.Self-tuning is not occurring because there are less than two memory consumers enabled.
• C.Self-tuning is not occurring because it is waiting for the database to be recycled.
• D.The memory tuner is actively tuning the memory on the system.

Which statement about updating index statistics with the RUNSTATS command is true?

• A.It requires a full index scan.
• B.It must be executed against all indexes for the table.
• C.It can be accomplished by sampling the index.
• D.It cannot be accomplished without scanning the associated table.

What information can be obtained by analyzing EXPLAIN data?

• A.Join methods, index use, and access type
• B.Work load, access type, and join methods
• C.Access type, index use, and work load
• D.Index use, work load, and join methods