C2090-610

C2090-610 practice questions, page 3 of 6, with answer review and explanations.

Question 11

What are two valid objects that can be created in DB2? (Choose two.)

  1. Tree
  2. Node
  3. Trigger
  4. Contexts
  5. Sequence

Question 12

Which type of temporal table can be used to store only time-sensitive data?

  1. Bitemporal
  2. Time-period
  3. System-period
  4. Application-period

Question 13

When an index is created for a table, where is the metadata for that index stored?

  1. In the table definition.
  2. In the system catalog.
  3. In the schema that the index resides in.
  4. In the metadata of the table the index was created for.

Question 14

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

  1. pureScale
  2. Workload manager
  3. Data partitioning feature
  4. Self-tuning memory manager

Question 15

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

  1. locator
  2. pointer
  3. address
  4. reference