IBM IBM Certified Advanced Database Administrator A2090-610 Questions & Answers

• Question 41:

  Which statement about roll back operations is correct?

  A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

  B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

  C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.

  D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

  Correct Answer: A

• Question 42:

  When a COMMIT statement is executed, what happens?

  A. All locks held on the database are automatically released.

  B. Data stored in global temporary tables is automatically deleted.

  C. Open cursors defined WITH HOLD are closed, but their data is retained.

  D. The current transaction is terminated and a new transaction boundary is started.

  Correct Answer: D

• Question 43:

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

  A. DB2 Connect

  B. DB2 pureScale

  C. Workload Manager

  D. High Availability Disaster Recovery

  Correct Answer: B

• Question 44:

  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?

  A. inline

  B. binary

  C. internal

  D. partitioned

  Correct Answer: A

• Question 45:

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

  A. Database

  B. Buffer pool

  C. Table space

  D. Package cache

  Correct Answer: B

• Question 46:

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

  A. A LOB locator is a data type that is used to store LOB data in binary files.

  B. A LOB locator is a data type that is used to store LOB data in a database.

  C. A LOB locator represents a value for a LOB resource that is stored in a database.

  D. A LOB locator represents a value for a LOB resource that is stored in a binary file.

  Correct Answer: C

• Question 47:

  Which object can a buffer pool be assigned to?

  A. Schema

  B. Table space

  C. Storage group

  D. Stored procedure

  Correct Answer: B

• Question 48:

  Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

  A. View

  B. Table

  C. Sequence

  D. Identity Column

  Correct Answer: C

• Question 49:

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

  A. Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.

  B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column.

  C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined.

  D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history table.

  Correct Answer: D

• Question 50:

  Which statement about bitemporal tables is valid?

  A. Bitemporal tables are system tables and can only be queried by the schema owner.

  B. Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.

  C. When data in a bitemporal table is updated, a row is added to it's associated history table.

  D. Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.

  Correct Answer: C