Discussion
Home ‣ Certification ‣ IBM Certification Comments
- Question
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
- Correct Answer
- FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
IBM Certification problems
Search Results
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: Filter Requests
Correct Answer: ALTER TABLE customer MODIFY NEXT SIZE 300
Correct Answer: GDPS
Correct Answer: /var/log/messages
Correct Answer: higher availability
Correct Answer: Define a dependent table where TAB1 is the parent.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.