Online Access Free C2090-616 Practice Test

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

• A.Sequence
• B.Identity Column
• C.Row Identifier
• D.Insert time clustering table

Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?

• A.DB2 Express-C
• B.DS2 Database Partitioning Feature
• C.DB2 HADR
• D.DB2 pureScale

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

• A.Continuously available dataset solution
• B.Faster response time of long-running or complex queries with I/O spread across many computers
• C.Easy scalability
• D.Increased throughput of many concurrent short running queries
• E.Management of very large data sets

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

• A.Lock escalation
• B.Lock conversion
• C.Lock timeout
• D.Deadlock

Which of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?

• A.BLU acceleration
• B.auto reorg
• C.pureScale
• D.Self tuning memory manager