Exam Code: C2090-612 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-612 Exam.
2021 May C2090-612 Study Guide Questions:
Q21. In a data sharing environment, how is the LRSN value created?
A. It is selected from the DB2 catalog.
B. It is generated from a sequence object.
C. It is derived from the sysplex timer (store clock).
D. It is derived from combining RBAs from multiple members.
Answer: C
Explanation:
Q22. The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
A. Filter factor information.
B. Stage 1 and stage 2 information.
C. Number of columns used in an index.
D. Number of times an SQL statement is executed.
Answer: D
Explanation:
Q23. The following DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES; Next, the following ALTER statements are done (in order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0 MAXPARTITIONS 20; 2) ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX USER1.IX1 BUFFERPOOL BP16K0; Which of the following will materialize all of the changes with the least amount of work?
A. Nothing needs to be done.
B. REORG INDEX USER1.IX1 SHRLEVEL CHANGE
C. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
D. REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE REORG INDEX USER1.IX1 SHRLEVEL CHANGE
Answer: C
Explanation:
Renewal C2090-612 real exam:
Q24. How can you find out which external and native stored procedures are active in the system?
A. Use the -DIS PROCEDURE(*.*) command.
B. Use the -DIS THREAD(*) TYPE(PROC) command.
C. There is no WLM or DB2 command to obtain this information.
D. You can only obtain this information indirectly if you know the WLM application environment by issuing the D WLM,APPLENV=xxxx command.
Answer: C
Explanation:
Q25. When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?
A. List prefetch
B. Dynamic prefetch
C. Sequential prefetch
D. Skip sequential prefetch
Answer: B
Explanation:
Q26. Which privilege allows the execution of the EXPLAIN STMTCACHE ALL SQL statement?
A. SYSOPR
B. SYSCTRL
C. SQLADM
D. SECADM
Answer: C
Explanation:
Real C2090-612 :
Q27. 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:
Q28. Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?
A. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
B. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);
C. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
D. CREATE INDEX empname1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/employee/name' as sql varchar(20);
CREATE INDEX empphone1 ON dept(info)
GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);
Answer: D
Explanation:
Q29. What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?
A. KEEPDYNAMIC(YES) and CACHEDYN=YES
B. KEEPDYNAMIC(NO) and CACHEDYN=NO
C. KEEPDYNAMIC(NO) and REOPT(ALWAYS)
D. KEEPDYNAMIC(YES) and REOPT(ALWAYS)
Answer: A
Explanation:
Q30. The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?
A. The encoding scheme of the table is EBCDIC.
B. The encoding scheme of the table is UNICODE.
C. This could never happen, this is an error and must be reported.
D. This is expected behavior and independent of the encoding scheme.
Answer: B
Explanation: