Interview Questions

There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery :

SELECT MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) FROM Employee );

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.

The SCPCA method can be used to evaluate channel members.

a) Sales (S): How much sales each channel member can give within a cetain time frame

b) Cost(C): How much cost would be incurred for each channel?

c) Profitability(P): Which channel can give better profitability to the company?

d) Control(C): Whether company can have better control over its channel members or not.

e) Adaptability (A): Whether the channel alternatives are flexible enough to any changes or not. The channel meeting the objectives of the company is selected

#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;
}

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