Interview Questions

Kano analysis is a systems analysis tool used to identify its impact on customer’s satisfaction based on 3 key areas: unexpected delighters, performance attributes and must have attributes.

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.

Overridden methods must have the same name, argument list, and return type (i.e., they must have the exact signature of the method we are going to override, including return type.)

The overriding method cannot be less visible than the method it overrides( i.e., a public method cannot be override to private).

The overriding method may not throw any exceptions that may not be thrown by the overridden method

Following are the 3 core directives of AngularJS.

1. ng-app : This directive defines and links an AngularJS application to HTML.


2. ng-model : This directive binds the values of AngularJS application data to HTML input controls.


3. ng-bind : This directive binds the AngularJS Application data to HTML tags.

Hub is device to connect two devices, switch is a network bridge which processes and routes data approirately over network layer of OSI Reference model

The Asynchronous Transfer Mode or ATM is a connection technology that works by transmitting data into organized 53 bytes (small) packages through a physical environment with a high efficiency. Packing data into small cells reduces transportation delay so the speeds reached by this technology are very high; it can reach even 10 Gb per second.

Use SELECT DISTINCT ..... in DB2 query

The DISTINCT keyword can be used to return only distinct (different) values.

Syntax:

     SELECT DISTINCT column1,column2

      FROM table_name;