Curioustab

Home » Certification » IBM Certification

Which statement correctly changes the next extent size?

ALTER TABLE customer MODIFY NEXT SIZE 300
ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300
ALTER TABLE customer MODIFY EXTENT SIZE 300
ALTER TABLE customer NEXT SIZE 300

Correct Answer: ALTER TABLE customer MODIFY NEXT SIZE 300

← Previous Question Next Question→

More Questions from IBM Certification

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?
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?
What are the advantages of fragmentation?
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?
What help ensure that the XIV Systems cache does not become a bottleneck?
Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?
Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?
What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?
A VM/VSE customer wants to implement a WAS on an existing zSeries server. On which of the following operating environments would WAS best be implemented?
How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion