logo

CuriousTab

IBM Certification (Certification) Question and Answers-Page first

IBM Certification problems


Share: 
  • 1. Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

  • Options
  • A. CLOB
  • B. TIME
  • C. VARCHAR
  • D. TIMESTAMP

  •           Discuss     

  • 2. A solution developer needs to configure the HTTP listener of an Integration Server on a Linux Server. Which operating system privileges does the developer need to modify Integration node properties and properties of integration node resources?

  • Options
  • A. root user
  • B. mqm
  • C. mqbrks
  • D. mqm and mqbrks

  • Tags: Software Architect, Project Manager, IT Trainer

  •           Discuss     

  • 3. which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?

  • Options
  • A. Buffer Cache
  • B. ACID
  • C. Foreign Key
  • D. None

  • Tags: Analyst, IT Trainer

  •           Discuss     

  • 4. Proxy servers have two main purposes : 1. Improve Performance (and) 2. is ______ ?

  • Options
  • A. Transmit Request
  • B. Decrease Requests
  • C. Increase Requests
  • D. Filter Requests

  •           Discuss     

  • 5. Which of the following extenders allows data to be presented in a three dimensional format?

  • Options
  • A. DB2 AVI Extender
  • B. DB2 XML Extender
  • C. DB2 Text Extender
  • D. DB2 Spatial Extender

  •           Discuss     

  • 6. The DBA can set the registry variable DB2_HASH_JOIN on or off because:

  • Options
  • A. hash joins may require more resources to run.
  • B. hash joins are not used unless outer joins are requested.
  • C. If hash joins are enabled, no other join method can be used.
  • D. Hash joins are only needed when the tables are portioned using hash keys.

  •           Discuss     

  • 7. With database logging, where are transaction records first placed?

  • Options
  • A. in the logical log buffer
  • B. in the primary chunk
  • C. in the physical buffer
  • D. in a temporary database table

  •           Discuss     

  • 8. Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?

  • Options
  • A. AD Tools
  • B. CP3000
  • C. Estimate the AIX load and add to CP3000 results.
  • D. Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ

  •           Discuss     

  • 9. Which statement fragments a table as round robin?

  • Options
  • A. FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2
  • B. FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
  • C. FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2
  • D. FRAGMENT BY ROUND ROBIN

  •           Discuss     

  • 10. Which statement correctly changes the next extent size?

  • Options
  • A. ALTER TABLE customer MODIFY NEXT SIZE 300
  • B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300
  • C. ALTER TABLE customer MODIFY EXTENT SIZE 300
  • D. ALTER TABLE customer NEXT SIZE 300

  •           Discuss     


First 2 3