Discussion
Home ‣ Certification ‣ IBM Certification Comments
- Question
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
- Correct Answer
- Estimate the AIX load and add to CP3000 results.
- 1. 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
- 2. 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
- 3. 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
- 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 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 Discuss
- 6. 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
- 7. 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
- 8. Suppose a System z customer has a new CIO. The CIO is concerned about continuing operations and recovery following a catastrophe.Which of the following addresses this issue?
Options- A. GDPS
- B. TAM
- C. DR
- D. WASS Discuss
- 9. Suppose a customer is attempting to determine what failed during the last boot sequence of the Linux partition. Which of the following can be used to determine the error condition?
Options- A. /var/log/messages
- B. /proc/startup
- C. /usr/sbin/log
- D. /etc/boot Discuss
- 10. What are the advantages of fragmentation?
Options- A. reduced disk space requirements
- B. higher availability
- C. finer granularity of archives and resources
- D. parallel scans are possible with PDQ Discuss
IBM Certification problems
Search Results
Correct Answer: in the logical log buffer
Correct Answer: hash joins may require more resources to run.
Correct Answer: DB2 Spatial Extender
Correct Answer: Filter Requests
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.
Correct Answer: FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
Correct Answer: ALTER TABLE customer MODIFY NEXT SIZE 300
Correct Answer: GDPS
Correct Answer: /var/log/messages
Correct Answer: higher availability
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.