Pass4Test는 많은 분들이 IBM Certified Database Administrator C2090-312시험을 응시하여 성공하도록 도와주는 사이트입니다. Pass4Test의 IBM Certified Database Administrator C2090-312학습가이드는 시험의 예상문제로 만들어진 아주 퍼펙트한 시험자료입니다.IBM Certified Database Administrator C2090-312시험은 최근 가장 인기있는 시험으로 IT인사들의 사랑을 독차지하고 있으며 국제적으로 인정해주는 시험이라 어느 나라에서 근무하나 제한이 없습니다. Pass4Test로 여러분은 소유하고 싶은 인증서를 빠른 시일내에 얻게 될것입니다.
NO.1 Which type of column can be dropped from a table via the ALTER TABLE ...
DROP COLUMN ...
DROP COLUMN ...
SQL statement?
A. XML column
B. LOB column
C. DOCID
column
D. Hidden ROWID column
Answer: A
NO.2 DB2 will not allow
certain processing to occur when the soft limit of RBA TFF800000000'x
is
reached and an object's RBA remains in basic 6-byte format.
What
processing is NEVER allowed?
A. Changes to the BSDS.
B. RECOVER to
CURRENT.
C. REORGwith RBALRSN_CONVERSION EXTENDED.
D. SQL update
activities (INSERT. UPDATE, DELETE, MERGE).
Answer: B
NO.3 The degree
of parallelism can vary for the REBUILD INDEX utility.
What action should be
taken to limit the use of real memory using the REBUILD INDEX utility?
A.
Increase the value of the PARALLEL option.
B. Decrease the value of the
PARALLEL option.
C. Increase the value in the CURRENT DEGREE special
register.
D. Decrease the value in the CURRENT DEGREE special
register.
Answer: C
NO.4 You must be able to process recoveries for
DB2 objects to any point in time between now and
two weeks ago.
What is
the recommended amount of recovery data needed?
A. One set of
SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least
two
weeks.
B. One set of SHRLEVEL(CHANGE) full image copy at least every
week that are kept for at least three
weeks as well as the active/archive
logs during that time.
C. One set of SHRLEVEL(CHANGE) full images copies at
least every week that are kept for at least two
weeks as well as the
active/archive logs during that time.
D. One set of SHRLEVEL(CHANGE) full
images copies during week#1 and one set of
SHRLEVEL(REFERENCE) incremental
images copies during week #2, all are kept for at least two weeks.
Answer:
A
NO.5 What is the maximum partition size for a table space created with
NUMPARTS 128, a page size
of 8K, and a default DSSIZE of 4G?
A. 1G
B.
2G
C. 4G
D. 8G
Answer: D
NO.6 Assuming you are the SYSADM, what
is the effect of executing the EXPLAIN STMTCACHE ALL
statement?
A. The
table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in
the
Local Dynamic Statement Cache.
B. The PLAN_TABLE contains the access
path of each SQL statement in the Local Dynamic Statement
Cache.
C. The
PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic
Statement
Cache.
D. The table DSN_STATEMENT_CACHE_TABLE table contains a
row for each SQL statement in the
Global Dynamic Statement Cache.
Answer:
A
NO.7 A statement-level access path hint can be applied to which type of
SQL statement?
A. Static SQL statements only.
B. Dynamic SQL statements
only.
C. Both static and dynamic SQL statements.
D. Statements included in
a CREATE PROCEDURE statement only.
Answer: B
NO.8 Which statement is
true?
A. Unicode and EBCDIC have a different collating sequence.
B. The
collating sequence for ASCII and EBCDIC is identical.
C. The collating
sequence for Unicode and EBCDIC is identical.
D. If you use BETWEEN in your
SQL statement, the collating sequence does not matter for the
predicate
evaluation.
Answer: B
A. XML column
B. LOB column
C. DOCID
column
D. Hidden ROWID column
Answer: A
NO.2 DB2 will not allow
certain processing to occur when the soft limit of RBA TFF800000000'x
is
reached and an object's RBA remains in basic 6-byte format.
What
processing is NEVER allowed?
A. Changes to the BSDS.
B. RECOVER to
CURRENT.
C. REORGwith RBALRSN_CONVERSION EXTENDED.
D. SQL update
activities (INSERT. UPDATE, DELETE, MERGE).
Answer: B
NO.3 The degree
of parallelism can vary for the REBUILD INDEX utility.
What action should be
taken to limit the use of real memory using the REBUILD INDEX utility?
A.
Increase the value of the PARALLEL option.
B. Decrease the value of the
PARALLEL option.
C. Increase the value in the CURRENT DEGREE special
register.
D. Decrease the value in the CURRENT DEGREE special
register.
Answer: C
NO.4 You must be able to process recoveries for
DB2 objects to any point in time between now and
two weeks ago.
What is
the recommended amount of recovery data needed?
A. One set of
SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least
two
weeks.
B. One set of SHRLEVEL(CHANGE) full image copy at least every
week that are kept for at least three
weeks as well as the active/archive
logs during that time.
C. One set of SHRLEVEL(CHANGE) full images copies at
least every week that are kept for at least two
weeks as well as the
active/archive logs during that time.
D. One set of SHRLEVEL(CHANGE) full
images copies during week#1 and one set of
SHRLEVEL(REFERENCE) incremental
images copies during week #2, all are kept for at least two weeks.
Answer:
A
NO.5 What is the maximum partition size for a table space created with
NUMPARTS 128, a page size
of 8K, and a default DSSIZE of 4G?
A. 1G
B.
2G
C. 4G
D. 8G
Answer: D
NO.6 Assuming you are the SYSADM, what
is the effect of executing the EXPLAIN STMTCACHE ALL
statement?
A. The
table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in
the
Local Dynamic Statement Cache.
B. The PLAN_TABLE contains the access
path of each SQL statement in the Local Dynamic Statement
Cache.
C. The
PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic
Statement
Cache.
D. The table DSN_STATEMENT_CACHE_TABLE table contains a
row for each SQL statement in the
Global Dynamic Statement Cache.
Answer:
A
NO.7 A statement-level access path hint can be applied to which type of
SQL statement?
A. Static SQL statements only.
B. Dynamic SQL statements
only.
C. Both static and dynamic SQL statements.
D. Statements included in
a CREATE PROCEDURE statement only.
Answer: B
NO.8 Which statement is
true?
A. Unicode and EBCDIC have a different collating sequence.
B. The
collating sequence for ASCII and EBCDIC is identical.
C. The collating
sequence for Unicode and EBCDIC is identical.
D. If you use BETWEEN in your
SQL statement, the collating sequence does not matter for the
predicate
evaluation.
Answer: B