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

Which object may be used during query optimization to improve the performance for a subset of SELECT queries?

• A.Trigger
• B.MQT
• C.Read Only Cursor
• D.Stored Procedure

Which of the following DB2 tools allows a user to set DB2 registry parameters?

• A.Configuration Assistant
• B.Visual Explain
• C.Satellite Administration Center
• D.Task Center

Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, what will happen when Application B attempts to acquire a compatible lock on the same row?

• A.Application B will be rolled back if Application A still holds its lock after 20 seconds have elapsed
• B.Application B will acquire the lock it needs
• C.Both applications will be rolled back if Application A still holds its lock after 20 seconds have elapsed
• D.Application A will be rolled back if it still holds its lock after 20 seconds have elapsed

Which of the following DB2 data types does NOT have a fixed length?

• A.DOUBLE
• B.XML
• C.CHAR
• D.INT

Which of the following provides a logical grouping of database objects?

• A.Table
• B.Schema
• C.Buffer pool
• D.View