Pass4Test 에서 제공해드리는 IBM Certified Database Administrator C2090-312덤프는 아주 우수한 IT인증덤프자료 사이트입니다. IT업계엘리트한 강사들이 퍼펙트한 IBM Certified Database Administrator C2090-312덤프문제집을 제작하여 디테일한 시험문제와 답으로 여러분이 아주 간단히 IBM Certified Database Administrator C2090-312시험을 패스할 수 있도록 최선을 다하고 있습니다.
NO.1 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.2
Which type of column can be dropped from a table via the ALTER TABLE ... DROP
COLUMN ...
SQL statement?
A. XML column
B. LOB column
C. DOCID
column
D. Hidden ROWID column
Answer: A
NO.3 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.4 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.5 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.6 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.7 Consider a logical
data model that includes an Employees entity and a Projects entity. In
this
model, employees work on many projects and projects are worked on by
many employees.
The Employees and Projects entity is considered what kind of
relationship?
A. A one-to-one relationship.
B. A one-to-many
relationship.
C. A many-to-one relationship.
D. A many-to-many
relationship.
Answer: A
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
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.2
Which type of column can be dropped from a table via the ALTER TABLE ... DROP
COLUMN ...
SQL statement?
A. XML column
B. LOB column
C. DOCID
column
D. Hidden ROWID column
Answer: A
NO.3 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.4 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.5 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.6 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.7 Consider a logical
data model that includes an Employees entity and a Projects entity. In
this
model, employees work on many projects and projects are worked on by
many employees.
The Employees and Projects entity is considered what kind of
relationship?
A. A one-to-one relationship.
B. A one-to-many
relationship.
C. A many-to-one relationship.
D. A many-to-many
relationship.
Answer: A
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