IBM DB2 11 DBA for z/OS - C2090-312 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which command populates the EXPLAIN tables but does not create a package?

A. REBINDEXPLAIN(NO) B. REBINDEXPLAIN(YES) C. REBINDCOPY D. REBIND EXPLAIN(ONLY)

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

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 DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEEDJJMIT); B. CREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEED_LIMIT); C. CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT, MAX_SPEED SPEEDJJMIT); D. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. SPEED_LIMIT);

Discussion 0

Correct Answer: A Vote an answer

Question 3

A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?

A. An application-period temporal table B. A system-period temporal table C. A range-based temporal table D. A rate-period temporal table

Discussion 0

Correct Answer: A Vote an answer

Question 4

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 Global Dynamic Statement Cache. B. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache. C. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache. D. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which component is NOT shared between DB2 data sharing members?

A. SCA B. DB2 catalog C. IRLM D. DB2 directory

Discussion 0

Correct Answer: B Vote an answer

Question 6

What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?

A. This stored procedure helps you monitor currently running threads. B. You can create a detailed report of currently running and stopped utilities. C. You can create RUNSTATS profiles and RUNSTATS recommendations for DB2 tables in your DB2 subsystem. D. This stored procedure materializes SYSIBM.SYSSTATFEEDBACK for the page sets you specify as input parameter.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index.
Which statement is true?

A. The index has now a status of RBDP. B. The index has now a status of RECP. C. The index has now a status of CHKP. D. The index has now a status of REFP.

Discussion 0

Correct Answer: C Vote an answer