IBM Assessment DB2 10.1 Fundamentals Set 3

1.

Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

View Index Trigger Check constraint

2.

Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?

Type-1 connect Type-2 connect Type-3 connect Type-4 connect

3.

Which statement about bitemporal tables is valid?

Bitemporal tables are system tables and can only be queried by the schema owner. Creating a bitemporal table is similar to creating a regular table except users must specify a system timeperiod column. When data in a bitemporal table is updated, a row is added to it's associated history table. Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtainresults for a specific time period.

4.

Which object can a buffer pool be assigned to?

Schema Table space Storage group Stored procedure

5.

What needs to be defined in order to track changes made to a system-period temporal table over time?

Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked. A history table must be created with identical columns to the base table and a unique index must be definedon the transaction-start-id column. A history table must be created as a clone table of the base table after the row-begin, row-end, andtransaction-start-id columns have beendefined. A history table must be created with identical columns to the base table and then the base table altered withthe ADD VERSIONING clause torelate it to the history table.

6.

Which object is used to cache table and index data as it is read from disk?

Database Buffer pool Table space Package cache

7.

Which statement about large object (LOB) locators is true?

A LOB locator is a data type that is used to store LOB data in binary files. A LOB locator is a data type that is used to store LOB data in a database. A LOB locator represents a value for a LOB resource that is stored in a database. A LOB locator represents a value for a LOB resource that is stored in a binary file.

8.

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

DB2 Connect DB2 pureScale Workload Manager High Availability Disaster Recovery

9.

What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?

inline binary internal partitioned

10.

Which product replaced the Control Center used in versions prior to DB2 v10?

IBM Data Studio IBM Administrator IBM Data Manager IBM Command Center

IBM Assessment DB2 10.1 Fundamentals Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Assessment DB2 10.1 Fundamentals Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner