IBM DB2 A2090-544

A2090-544자격증시험은 전문적인 관련지식을 테스트하는 인증시험입니다.은 여러분이 A2090-544 시험을 통과할수 있도록 도와주는 사이트입니다. 많은 분들이 많은 시간과 돈을 들여 학원까지 다니면서 IBM A2090-544시험패스에 최선을 다합니다. 하지만 A2090-544덤프를 구매하시면 20시간 좌우만 투자하면 무조건 A2090-544시험을 패스할 수 있도록 도와드립니다.

최신 DB2 A2090-544 무료샘플문제:

1. Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?

A) UTIL_HEAP_SZ and STAT_HEAP_SZ
B) LOAD_HEAP_SZ and DATABASE_MEMORY
C) LOAD_HEAP_SZ and STAT_HEAP_SZ
D) UTIL_HEAP_SZ and DATABASE_MEMORY

2. Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?

A) SHEAPTHRES_SHR
B) SORTHEAP
C) SHEAPTHRES
D) SORTHEAP_SHR

3. Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

A) SORTHEAPTHRES 10000K
B) SORTHEAP AUTOMATIC, SHEAPTHRES 0
C) SORTHEAP AUTOMATIC, SHEAPTHRES 10000K
D) SORTHEAPTHRES 10000K, SORTHEAP 250K

4. A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full backup being taken.
What is the fastest way to restore the database?

A) RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
B) RESTORE DB proddb TAKEN AT (Friday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);
C) RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
D) RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

5. Which conditions must be met to implement HADR?

A) Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
B) Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).
C) Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).
D) Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

질문과 대답: