IBM Certification problems
- 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
Correct Answer: TIME
- 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 Also asked in: Software Architect, Project Manager, IT Trainer
Correct Answer: root user
- 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 Also asked in: Analyst, IT Trainer
Correct Answer: ACID
Explanation:
ACID means (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc.
In the context of databases, a sequence of database operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data, is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.
- 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
Correct Answer: Filter Requests
- 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
Correct Answer: DB2 Spatial Extender
- 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
Correct Answer: hash joins may require more resources to run.
- 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
Correct Answer: in the logical log buffer
- 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
Correct Answer: Estimate the AIX load and add to CP3000 results.
- 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
Correct Answer: FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
- 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
Correct Answer: ALTER TABLE customer MODIFY NEXT SIZE 300
Programming
Copyright ©CuriousTab. All rights reserved.