41.
In which situation is shredding XML data recommended?
- A.When the data is naturally tabular
- B.When thenumber of nodes are volatile
- C.When the data by nature has sparse attributes
- D.When the data is of low volume and requires a complex star-schema topology
- Answer
- Report
Answer : [A]
42.
Which of the following tools for DB2 V9 allows a user to create and debug a
SQL stored procedure?
- A.Control Center
- B.Development Center
- C.Developer Workbench
- D.Stored Procedure Builder
- Answer
- Report
Answer : [C]
43.
Which of the following is NOT a valid method of authentication that can be used by DB2 9?
- A.SERVER
- B.SERVER_ENCRYPT
- C.CLIENT
- D.DCS
- Answer
- Report
Answer : [D]
44.
In a client-server environment, which two of the following can be used to verify passwords?
- A.System Catalog
- B.User ID/password file
- C.Client Operating System
- D.Communications layer
- E.Application Server
- Answer
- Report
Answer : [C,E]
45.
Which authority or privilege is granted by the DB2 Database Manager configuration file?
- A.CONNECT
- B.CONTROL
- C.SYSMAINT
- D.EXECUTE
- Answer
- Report
Answer : [C]