Your success in IBM C2090-612 is our sole target and we develop all our C2090-612 braindumps in a way that facilitates the attainment of this target. Not only is our C2090-612 study material the best you can find, it is also the most detailed and the most updated. C2090-612 Practice Exams for IBM C2090-612 are written to the highest standards of technical accuracy.
♥♥ 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
Q61. When is changing an index from non-clustering to clustering NOT allowed?
A. If the table space is defined as member cluster.
B. If the data is not ordered by the new clustering index.
C. If the new clustering index is for a table that uses hash organization.
D. If the new clustering index OBID is greater than the old clustering index OBID.
Answer: C
Explanation:
Q62. Which connection type can exploit trusted connections?
A. IMS
B. CAF
C. CICS
D. RRSAF
Answer: D
Explanation:
Q63. If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?
A. Nothing because DB2 will control the values.
B. A unique index must be defined on the ROWID column.
C. An identity column must also be created to control uniqueness.
D. Extra space must be allocated for an overflow area in the table space.
Answer: B
Q64. Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?
A. NUMTCB parameter must be set to 1 for Java stored procedures.
B. NUMTCB parameter must be set to 1 for REXX stored procedures.
C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.
Answer: B
Explanation:
Q65. 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:
Q66. Which DSNZPARM will define the number of RID Blocks in the RID Pool?
A. NUMTCB
B. MAXRBLK
C. CONDBAT
D. URLGWTH
Answer: B
Explanation:
Q67. 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:
Q68. 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:
Q69. 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:
Q70. When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur?
A. Function A.B is stopped and queues all access.
B. Function A.B is stopped and rejects all access.
C. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.
D. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.
Answer: D
Explanation: