Technology Questions

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

Ping

Netstat

Whenever there is local- variable/parameter inside the method with same name as data member.

Ex:

Class Sample {

 int a;

  void show() {

   int a=5;

   system.out.println(a); // 5

   system.out.println(this.a);//23

  }

}

class MainApp {

  Public static void main(String[] args) {

  Sample s = new Sample();

   s.a = 23;

   s.show();

   }

}

The QA testing process that was followed in my last company where I worked was like this: First of all the Business Requirement Document was prepared as per the client’s requirement (with the muck-up screen shots). Then on the basis of the requirement document, Test Strategy, Test Plans and Test Cases were written in sequential order. Once the Build is made and deployed to the different testing environments where different types of testing were performed to check whether there are any defects.

Use document.forms[0].submit();

(0 refers to the index of the form – if you have more than one form in a page, then the first one has the index 0, second has index 1 and so on).

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.

Following functions are aggregate functions. 

AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

Internet Service Provider (ISP) is a company offering access to internet. They offer various services:

1. Internet Access

2. Domain name registration

3. Dial-up access

4. Leased line access

There exist several ways to connect to the internet. Following are these connection types available:

* Dial-up Connection

* ISDN

* DSL

* Cable TV Internet connections

* Satellite Internet connections

* Wireless Internet Connections

mysql_fetch_array:
Fetch a result row as an associative array and a numeric array.

mysql_fetch_object:
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead. Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.

mysql_fetch_row():
Fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.