6.
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?
- A.Journal
- B.Task Center
- C.Activity Monitor
- D.Command Line Processor
- Answer
- Report
Answer : [B]
7.
Which of the following tools allows a user to create and debug a SQL stored procedure?
- A.Control Center
- B.Development Center
- C.Data Studio
- D.Stored Procedure Builder
- Answer
- Report
Answer : [C]
8.
Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i database?
- A.Visual Explain
- B.Activity Monitor
- C.SQL Performance Monitor
- D.DB2 Performance Monitor
- Answer
- Report
Answer : [C]
9.
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
- A.Task Center
- B.Command Editor
- C.Design Advisor
- D.Command Line Processor
- Answer
- Report
Answer : [B]
10.
Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
- A.Design Advisor
- B.Visual Explain
- C.Performance Advisor
- D.Configuration Assistant
- Answer
- Report
Answer : [A]
|
|
||||||||||||||||||||||||||||
