logo

CuriousTab

CuriousTab

Discussion


Home Certification IBM Certification Comments

  • Question
  • 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

  • Correct Answer
  • higher availability 


  • IBM Certification problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?

    • Options
    • A. SQLDAS after their cursor is closed.
    • B. Referential integrity maps after a join.
    • C. Stored procedure processes after they are run.
    • D. Tables after they have been read into the buffer pool.
    • Discuss
    • 9. 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?

    • Options
    • A. The Linux command mt
    • B. The Linux command cpio
    • C. The OS/400 command RST option(*print)
    • D. The OS/400 command DSPTAP option(*savrst)
    • Discuss
    • 10. What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?

    • Options
    • A. XIV firmware V10.0.8
    • B. Host Attachment Kit V1.0.1
    • C. SAN Volume Controller (SVC)V4.2
    • D. Virtual I/O Server (VIOS) V2.1.1
    • Discuss


    Comments

    There are no comments.

Enter a new Comment