Interview Questions

An IP address (internet protocol address) is a numerical representation that uniquely identifies a specific interface on the network. Addresses in IPv4 are 32-bits long. This allows for a maximum of 4,294,967,296 (2^32) unique addresses. Addresses in IPv6 are 128-bits, which allows for 3.4 x 1038 (2^128) unique addresses.

IP addresses available to the internet are classified as Public.

#include<stdio.h>
int main(){

  int s,temp,i,j,a[20];

  printf("Enter total numbers of elements: ");
  scanf("%d",&s);

  printf("Enter %d elements: ",s);
  for(i=0;i<s;i++)
      scanf("%d",&a[i]);

  //Bubble sorting algorithm
  for(i=s-2;i>=0;i--){
      for(j=0;j<=i;j++){
           if(a[j]>a[j+1]){
               temp=a[j];
              a[j]=a[j+1];
              a[j+1]=temp;
           }
      }
  }

  printf("After sorting: ");
  for(i=0;i<s;i++)
      printf(" %d",a[i]);

  return 0;
}

EVALUATE can be used in place of the nested IF THEN ELSE statements.

A Customer Master Record is a permanent record that contains key information about a business partner or a material. This information must be entered into the system before any transactions can take place involving the business partner [customer] or a material. Entering all the information about a customer or a material into the system before making transactions insures that subsequent transactions or inquiries will have consistent data and reports and analyses can be done in an orderly way. Master Records can be edited or changed when necessary. Changing master records is frequently called "Maintaining" in SAP

i.) Const - This variable means that if the memory is initialised once, it should not be altered by a program. 

ii.) Volatile - This variable means that the value in the memory location can be altered even though nothing in the program code modifies the contents. 

iii.) Mutable - This variable means that a particular member of a structure or class can be altered even if a particular structure variable, class, or class member function is constant.

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.

To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.

A certificate of deposit (CD) is a savings certificate with a fixed maturity date, specified fixed interest rate and can be issued in any denomination aside from minimum investment requirements.

CD's are generally issued by commercial banks

Time periods you define to age your debit items. Aging buckets are used in the Aging reports to see both current and outstanding debit items. For example you can define an aging bucket that includes all debit items that are 1 to 30 days past due.

Normal table used for this Report is < 30 days 30-60 days 60-90 days 90-180 days and >180 days