Master the C2090-612 DB2 10 DBA for z/OS content and be ready for exam day success quickly with this Actualtests C2090-612 test engine. We guarantee it!We make it a reality and give you real C2090-612 questions in our IBM C2090-612 braindumps.Latest 100% VALID IBM C2090-612 Exam Questions Dumps at below page. You can use our IBM C2090-612 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-612 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-612 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-612-exam-dumps.html
Q71. On what type of index would an ALTER INDEX ADD COLUMN be allowed?
A. An XML index.
B. An auxiliary index.
C. A user defined catalog index.
D. An index defined with BUSINESS_TIME WITHOUT OVERLAPS.
Answer: C
Explanation:
Q72. A single table should allow for up to 100 Terabytes of application data. How do you design your table space?
A. A segmented compressed table space, BUFFERPOOL BP0.
B. A LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.
C. A table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.
D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.
Answer: D
Explanation:
Q73. When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose two.)
A. DB2 archive logs.
B. Image copies of indexes.
C. A copy of your ICF catalog.
D. Image copies of table spaces.
E. Backups of the DB2 catalog and directory.
Answer: B,C
Explanation:
Q74. Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME, E.LASTNAME FROM DEPT D INNER JOIN EMP E ON D.DEPTNO = E.WORKDEPT); Can an UPDATE statement be used to update the view EMPD on joined tables DEPT and EMP?
A. No, an UPDATE statement against the EMPD view is not allowed at all.
B. Yes, the view EMPD can be updated directly via an UPDATE statement.
C. No, only a clone of the view EMPD can be updated via an UPDATE statement.
D. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view.
Answer: D
Explanation:
Q75. In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?
A. Index
B. Table
C. Schema
D. Database
Answer: B
Explanation:
Q76. When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?
A. Domain
B. Entities
C. Attributes
D. Primary Key
Answer: C
Explanation:
Q77. Which of the following does NOT make a view a read-only view?
A. The outer fullselect contains a GROUP BY clause.
B. The first SELECT clause specifies the keyword DISTINCT.
C. The only table referenced is a system maintained temporal table and a period-specification is specified.
D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.
Answer: D
Explanation:
Q78. What START TRACE command provides detailed lock suspend and lock contention trace information?
A. START TRACE(AUDIT)
B. START TRACE(STATS) CLASS(1)
C. START TRACE(PERFM) CLASS(30) IFCID(44,45)
D. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
Answer: C
Explanation:
Q79. When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?
A. An inbound ID is subject to translation.
B. A request does not need an authentication token.
C. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
D. For outbound requests, the encrypted password is extracted from RACF.
Answer: B
Explanation:
Q80. What is the purpose of the following query? SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME = TS.NAME);
A. It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.
B. It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.
C. It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.
D. It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in SYSIBM.SYSTABLESPACE.
Answer: C
Explanation: