Technology Questions

Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions.

Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns.

Direct method,

 Subtraction method,

 Modulo-Division method,

 Digit-Extraction method,

 Mid-Square method,

 Folding method,

Pseudo-random method

Open for INPUT, OUTPUT, I-O, EXTEND.

1.INPUT : for read only purpose

2.OUTPUT : for write only purpose

3.EXTEND : for appending records

4.I-O : for read and write(using EXTEND) purpose

Access specifiers in C++ determines the scope of the class members.

Public: If a class member is public, it can be used anywhere without the access restrictions.

Private: if a class member is private, it can be used only by the members and friends of class.

Protected: If a class member is protected, it can be used only by the members and friends of class and the members and friends of classes derived from class.

The Big-O notation simply describes how well an algorithm scales or performs in the worst case scenario as the number of elements in a data structure increases. The Big-O notation can also be used to describe other behavior such as memory consumption. Since the collection classes are actually data structures, we usually use the Big-O notation to chose the best implementation to use, based on time, memory and performance. Big-O notation can give a good indication about performance for large amounts of data.

A DB2 bind is a process that builds an access path to DB2 tables.