36.
Which of the following is used to create and debug user-defined functions?
- A.SQL Assist
- B.Control Center
- C.Command Editor
- D.Developer Workbench
- Answer
- Report
Answer : [D]
37.
Which of the following tools can be used to catalog a database?
- A.Visual Explain
- B.Alert Center
- C.Journal
- D.Configuration Assistant
- Answer
- Report
Answer : [A]
38.
What is the SQL Performance Monitor used for?
- A.To examine the health of a DB2 Database Manager instance
- B.To visually construct complex DML statements and examine the results of their execution
- C.To schedule tasks, run tasks, and send notifications about completed tasks to other users
- D.To analyze database operations performed against a DB2 for i5/OS database "Pass Any
- Answer
- Report
Answer : [D]
39.
Which two of the following allow you to perform administrative tasks against database objects?
- A.Control Center
- B.Journal
- C.Command Line Processor
- D.Task Center
- E.Health Center
- Answer
- Report
Answer : [A,C]
40.
Which of the following tasks can NOT be performed using the Developer Workbench?
- A.Develop and debug an SQL stored procedure
- B.Develop and debug a user-defined data type
- C.Develop and debug a user-defined function
- D.Develop and run XML queries
- Answer
- Report
Answer : [B]
|
|
||||||||||||||||||||||||||||
