Sawaal
  • Home/
  • Searching for %

 Searching for "%"

Q:

Which statement correctly changes the next extent size?

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
 
Answer & Explanation Answer: A) ALTER TABLE customer MODIFY NEXT SIZE 300

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?

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
 
Answer & Explanation Answer: D) Virtual I/O Server (VIOS) V2.1.1

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

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?

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)
 
Answer & Explanation Answer: B) The Linux command cpio

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?

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.
 
Answer & Explanation Answer: C) Stored procedure processes after they are run.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which statement fragments a table as round robin?

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
 
Answer & Explanation Answer: B) FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

What help ensure that the XIV Systems cache does not become a bottleneck?

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
 
Answer & Explanation Answer: C) each module is responsible for caching the data in that module

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

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?

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.
 
Answer & Explanation Answer: D) Define a dependent table where TAB1 is the parent.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

 What are the advantages of fragmentation?

A) reduced disk space requirements B) higher availability
C) finer granularity of archives and resources D) parallel scans are possible with PDQ
 
Answer & Explanation Answer: B) higher availability

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification