Home
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]
Report
Name Email  
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]
Report
Name Email  
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]
Report
Name Email  
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]
Report
Name Email  
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]
Report
Name Email