we provide 100% Correct IBM C2090-612 exam guide which are the best for clearing C2090-612 test, and to get certified by IBM DB2 10 DBA for z/OS. The C2090-612 Questions & Answers covers all the knowledge points of the real C2090-612 exam. Crack your IBM C2090-612 Exam with latest dumps, guaranteed!
♥♥ 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
Q1. 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:
Q2. When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?
A. DB2
B. RACF
C. USER
D. DEFINER
Answer: C
Explanation:
Q3. In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?
A. GBP32
B. SCA
C. LOCK
D. GBP0
Answer: B
Explanation:
Q4. What kind of information is stored in SYSIBM.SYSCOPY?
A. General information needed for recovery.
B. Only information about existing image copies.
C. Information about currently running and stopped copy jobs.
D. Only information about objects which are currently in copy pending.
Answer: A
Explanation:
Q5. A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?
A. Specify the column names to be hashed.
B. Create a unique index on the hash columns.
C. Create a clustering index on the hash columns.
D. Create a unique clustering index on the hash columns.
Answer: A
Explanation:
Q6. What IBM provided stored procedure will access DB2 real time statistics tables?
A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR
Answer: C
Explanation:
Q7. Which minimum system privilege allows you to create a trusted context?
A. DBADM
B. SECADM
C. SYSCTRL
D. ACCESSCTRL
Answer: B
Explanation:
Q8. What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort thread that you cancel was in the middle of a series of updates when DB2 abended?
A. The underlying page sets are stopped.
B. The underlying page sets are placed in REFP restrictive state.
C. The underlying page sets are placed in REORP restrictive state.
D. No restrictive state is set. It is your responsibility to ensure data consistency.
Answer: B
Explanation:
Q9. 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:
Q10. Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?
A. Run the BACKUP SYSTEM utility.
B. Run the REPAIR SET NOCOPYPEND utility.
C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.
D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.
Answer: C