9
Q:

Proxy servers have two main purposes :

1. Improve Performance  (and)

2.  is  ______ ?

A) Transmit Request B) Decrease Requests
C) Increase Requests D) Filter Requests

Answer:   D) Filter Requests



Explanation:
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

1 2184
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

5 3757
Q:

If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?

A) committed read B) repeatable read
C) share read D) indexed read
 
Answer & Explanation Answer: B) repeatable read

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2494
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

1 2230
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

1 2668
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

4 3268
Q:

Where is fragment information stored?

A) in the physical logs B) in the reserved pages
C) in the system catalog tables D) in the first page of the database tblspace
 
Answer & Explanation Answer: C) in the system catalog tables

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2227
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

1 2335