Technology Questions

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;

1. Have two indexes pointing to two ends of array, say i and j.

2. Approach towards each other with a check condition that they dont cross each other.

3. Each iteration of while loop, swap the numbers pointed by two indexes when num[i] index number is not equal to 1.

void sort()

{

     int a[]={1,0,0,0,1,1,0,1,0,1,0,0,1,0};

     int i=0;

     int j=13;

     int temp;

      while(j>i)

     {

          if(a[i]==1)

                 i++;

          if(a[j]==0)

                 j--;

          if(a[i]==0)

         {

                 temp=a[i];

                a[i]=a[j];

                a[j]=temp;

         }

     } 

     for(i=0;i<14;i++)

             Console.Write(a[i]+", ");

}

Output: 1,1,1,1,1,1,0,0,0,0,0,0,0

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.

The object need to be serialized when it’s sent over a network and when it’s state is saved. Exceptions which occur during serialization are:

a. transient fields

b. when the base class is serialized then only base class fields are handled.

c. static fields are ignored because they are not part of any state.

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

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

bcoz the static method does not contains the 'this' reference.