Sawaal
  • Home/
  • Searching for CH

 Searching for "CH"

Q:

 Which of the following is required for the DB2 optimizer to consider a hash join strategy?

A) Optimization level 1 or above B) Equijion predicates
C) Registry variable DB_ANTIJOIN=YES D) SORTHEAP large enough to contain the tables being joined
 
Answer & Explanation Answer: B) Equijion predicates

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

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?

A) GDPS B) TAM
C) DR D) WASS
 
Answer & Explanation Answer: A) GDPS

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

 Which isolation level does a database without logging default to?

A) committed read B) dirty read
C) mode ANSI D) repeatable read
 
Answer & Explanation Answer: B) dirty read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following tools can be used to identify inefficient SQL statements without executing them?

A) QMF B) Task Center
C) Visual Explain D) Development Center
 
Answer & Explanation Answer: C) Visual Explain

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

What is a chunk when using raw devices?

A) a dynamic unit of disk space B) a location in shared memory
C) a contiguous unit of disk space D) a data table
 
Answer & Explanation Answer: C) a contiguous unit of disk space

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Suppose a customer is planning to create a non-hosted Linux partition on an i825. Linux will have only direct-attach devices. What is the Linux console option?

A) Use OS/400 VNC support. B) Telnet to the virtual console.
C) Share the primary partitions console. D) Allocate a console IOA to the Linux partition.
 
Answer & Explanation Answer: B) Telnet to the virtual console.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?

A) Journal B) License Center
C) Replication Center D) Development Center
 
Answer & Explanation Answer: C) Replication Center

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?

A) on same disk in different modules B) on disks in other modules
C) on different disks in the same module D) on same disk, in same module, and in different modules
 
Answer & Explanation Answer: B) on disks in other modules

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification