000-610 試験問題を無料オンラインアクセス

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

• A.High Availability Disaster Recovery
• B.DB2 pureScale
• C.DB2 Connect
• D.Workload Manager

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

• A.IBM Administrator
• B.IBM Data Studio
• C.IBM Command Center
• D.IBM Data Manager

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

• A.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.
• 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.Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.
• D.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.

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

• A.Lock promotion
• B.Lock exchange
• C.Lock escalation
• D.Lock conversion

Which statement about a deadlock is true?

• A.The victim will read through the lock.
• B.The victim must wait until the holder releases the lock.
• C.Both victim and holder are rolled back.
• D.The victim will be rolled back.