Sawaal
  • Home/
  • Searching for Which

 Searching for "Which"

Q:

Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

A) CLOB B) TIME
C) VARCHAR D) TIMESTAMP
 
Answer & Explanation Answer: B) TIME

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Which of the following extenders allows data to be presented in a three dimensional format?

A) DB2 AVI Extender B) DB2 XML Extender
C) DB2 Text Extender D) DB2 Spatial Extender
 
Answer & Explanation Answer: D) DB2 Spatial Extender

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

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?

A) /var/log/messages B) /proc/startup
C) /usr/sbin/log D) /etc/boot
 
Answer & Explanation Answer: A) /var/log/messages

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

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:

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