Interview Questions

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.

The Active Directory database is stored on domain controllers and is accessible by network applications. All domains can be domain controllers and keep a copy of the Active Directory database in C:\windows\Ntds\Ntds.dit

We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection. SQL statements that cannot be executed in the solidDB front-end server are passed over to the back end. 

SQLPASSTHROUGH mode can be set as per session or per transaction. The connection between the front end and back end is made with a back-end compatible ODBC driver which is loaded dynamically in solidDB server.

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

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

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.

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

MainMenu component is a component that allows the display of Menus at runtime on a form.

Process of creating Menu using MainMenu Component:

a. Add MainMenu component on Windows Form.

b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.

c. Add functionality to Menu Items as required