It is more faster and easier to pass the IBM C2090-612 exam by using Verified IBM DB2 10 DBA for z/OS questuins and answers. Immediate access to the Regenerate C2090-612 Exam and find the same core area C2090-612 questions with professionally verified answers, then PASS your exam with a high score now.
♥♥ 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
Q51. Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?
A. MAXPARTITIONS
B. MAXPARTITIONS, DSSIZE
C. MAXPARTITIONS, page size
D. MAXPARTITIONS, DSSIZE, page size
Answer: D
Explanation:
Q52. Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)
A. LOG NO
B. SORTKEYS 16
C. FASTSWITCH YES
D. AUTOESTSPACE YES
E. DRAIN_WAIT & RETRY
Answer: C,E
Explanation:
Q53. Altering the DSSIZE is allowed for what type of table space?
A. XML table space.
B. Universal table space.
C. Segmented table space.
D. DSSIZE cannot be altered.
Answer: B
Explanation:
Q54. 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:
Q55. You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requirements?
A. BIGINT
B. INTEGER
C. DECFLOAT (34)
D. DECIMAL (31,18)
Answer: A
Explanation:
Q56. Which of the following tasks cannot be done via a single ALTER TABLE statement?
A. Add a new partition to the table space.
B. Change the VALIDPROC attribute of the table.
C. Change a table check constraint on the table.
D. Change the DATA CAPTURE attribute of the table.
Answer: C
Explanation:
Q57. An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?
A. Issue a RECOVER POSTPONED command.
B. Issue a START command with ACCESS(RW).
C. Recycle the system with the system parameter LBACKOUT=NO.
D. Issue a STOP command and then a START command with ACCESS(RW).
Answer: A
Explanation:
Q58. Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)
A. SECADM authority.
B. ACCESSCTRL authority.
C. DATAACCESS authority.
D. SYSADM authority when SEPARATE_SECURITY=NO.
E. The owner of the object as he/she has that authority implicitly.
Answer: A,D
Explanation:
Q59. Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?
A. 1
B. 4
C. 5
D. 6
Answer: D
Explanation:
Q60. When is a merge scan join a well performing access path?
A. When the number of qualifying rows of the inner and outer table are both large.
B. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.
C. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.
D. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicate qualifying rows.
Answer: A
Explanation: