Discussion
Home ‣ Certification ‣ IBM Certification Comments
- Question
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
- Correct Answer
- ALTER TABLE customer MODIFY NEXT SIZE 300
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 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. 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
- 7. 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
- 8. 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
- 9. Explain Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera.Which of the following describes what USERA is allowed to do?
Options- A. Create a read?only view using TAB1.
- B. Alter TAB1 to add a check constraint.
- C. Define a primary key or unique constraint on TAB1.
- D. Define a dependent table where TAB1 is the parent. Discuss
- 10. What help ensure that the XIV Systems cache does not become a bottleneck?
Options- A. central cache locking mechanism
- B. use of industry standard chip technology
- C. each module is responsible for caching the data in that module
- D. having all modules understand what is held cache at all times Discuss
IBM Certification problems
Search Results
Correct Answer: FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
Correct Answer: Estimate the AIX load and add to CP3000 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: GDPS
Correct Answer: /var/log/messages
Correct Answer: higher availability
Correct Answer: Define a dependent table where TAB1 is the parent.
Correct Answer: each module is responsible for caching the data in that module
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.