Exam Code: C2090-312 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM DB2 11 DBA for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-312 Exam.
2021 Apr C2090-312 Study Guide Questions:
Q31. Prefetch l/Os are executed under a service request block in which address space?
A. IRLM
B. DBM1
C. MSTR
D. User address space
Answer: B
Q32. What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?
A. 1G
B. 2G
C. 4G
D. 8G
Answer: C
Q33. Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
A. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.
B. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache.
C. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.
D. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Global Dynamic Statement Cache.
Answer: D
Down to date C2090-312 free download:
Q34. Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A SELECT statement predicate against the transaction start ID of the base table.
D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.
E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.
Answer: C,E
Q35. Which statement regarding triggers is true?
A. A trigger can use global variables and change their contents.
B. A trigger can use global variables but cannot change their contents.
C. A trigger cannot use global variables but can change their contents.
D. A trigger cannot use global variables and cannot change their contents.
Answer: B
Q36. What does the UNLOAD utility allow you to unload?
A. Index entries from an index image copy.
B. Rows from an image copy after the table has been dropped.
C. Rows from an image copy after columns have been dropped.
D. Rows from a sequential image copy created by the COPYTOCOPY utility.
Answer: D
Precise C2090-312 preparation exams:
Q37. You have defined the array type PHONENUMBERS using the following DDL:
CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];
You also defined a variable named RECENT_CALLS based on this new array type as follows: CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?
A. SET LIST_SIZE = MAX(RECENT_CALLS)
B. SET LIST_SIZE = ARRAY_MAX(RECENT_CALLS)
C. SET LIST_SIZE = ARRAY_LAST(RECENT_CALLS)
D. SET LIST_SIZE = MAX_CARDINALITY(RECENT_CALLS)
Answer: B
Q38. Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for each route?
A. CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT, MAX_SPEED SPEEDJJMIT);
B. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEEDJJMIT);
C. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. SPEED_LIMIT);
D. CREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEED_LIMIT);
Answer: B
Q39. When performing several inserts into a table defined with an identity column, which attribute could be ALTERed to help with the performance?
A. RESET
B. CACHE
C. MAXVALUE
D. INCREMENT
Answer: D
Q40. Which statement is true?
A. Unicode and EBCDIC have a different collating sequence.
B. The collating sequence for ASCII and EBCDIC is identical.
C. The collating sequence for Unicode and EBCDIC is identical.
D. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.
Answer: A
Reference:http://www-01.ibm.com/support/knowledgecenter/SS4LQ8_3.1.0/com.ibm.datatools.aqt3.doc/gui/concepts/c_i daa_inconsistencies.html(first bulleted point on the page)