C2090-312 Exam Questions
191 real C2090-312 exam questions with expert-verified answers and explanations. Page 4 of 4.
- Question #161
Which statement is true?
- Question #162
You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago. What is the recommended amount of recovery data needed?
- Question #163
Which type of stored procedures do NOT require a WLM-managed stored procedure address space?
- Question #164
When we use multilevel-security using a security label column, which sentence is true?
- Question #165
Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?
- Question #166
Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?
- Question #167
Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause?
- Question #168
The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE). Where can this be ve...
- Question #169
Given this statement: RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH Which statement is FALSE?
- Question #170
What is the least disruptive way of externalizing real-time statistics for table space DB1TS1 ?
- Question #171
Which statement is true for data in columns defined with data type XML?
- Question #172
Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
- Question #173
When performing several inserts into a table defined with an identity column, which attribute could be ALTERed to help with the performance?
- Question #174
Which DB2 Client command can be used to identify the Client's version?
- Question #175
What is the minimum buffer pool page size for a compressed index?
- Question #176
What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?
- Question #177
Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections?
- Question #178
As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalize...
- Question #179
Prefetch l/Os are executed under a service request block in which address space?
- Question #180
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, a...
- Question #181
If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints: BIND QUERY LOOKUP (YES) what is the result of t...
- Question #182
What is necessary in order to enable optimization hints?
- Question #183
Which command populates the EXPLAIN tables but does not create a package?
- Question #184
The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?
- Question #185
Which global variables statement is true?
- Question #186
Which DB2 subsystem parameter limits the number of concurrent active TSO requests?
- Question #187
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
- Question #188
An Audit report shows that data on the CUSTOMER table was successfully updated by an unknown USERID. What other DB2 supplied information could be reviewed to learn more about the u...
- Question #189
You want to create a table space without actually creating the underlying data sets until rows are inserted into the corresponding table. Which CREATE TABLESPACE statement option a...
- Question #190
Which component is NOT shared between DB2 data sharing members?
- Question #191
You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB. How would you find this info...
- Question #192
When would DB2 NOT use list prefetch?
- Question #193
Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the...
- Question #194
What is required before you begin your installation of DB2 11 ?
- Question #195
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 ro...
- Question #196
When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2'. What is the result of executing the DDL statement?
- Question #197
Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?
- Question #198
You want to determine which objects of your database DB1 are in LPL. What command should be used?
- Question #199
An application receives an 00C90110 reason code. See the following manual explanation of the code. " 00C90110Explanation:The data manager detected an inconsistent data condition. T...
- Question #200
Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?
- Question #201
Which address space should be classified with the highest priority WLM service class?