Technology Questions

End of file  (10)

Duplicate key (22)

Record not found (23)

VSAM logic error  (90)

Open problem  (92)

Space problem (93)

The mail() function of PHP is quite robust for sending bulk emails. A SMTP server can also be directly used from the script. PHPmailer class can be used for sending emails.

PL/SQL tables are scalar arrays that can be referenced by a binary digit. They can be used to store values for later queries and calculations.

“In software testing, a test harness or automated test framework is a collection of software and test data configured to test a program unit by running it under varying conditions and monitor its behavior and outputs. It has two main parts: the test execution engine and the test script repository.”

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

LINQ stands for " Language Integrated Query " and it is pronounced as "LINK".
LINQ was introduced in with .NET framework 3.5 including VS2008. It enables you to query the data from various data source like SQL, XML document, ADO .NET data source, web services and any other objects such as Collection, Generics etc...

Star schema: A highly de-normalized technique. A star schema has one fact table and is associated with numerous dimensions table and depicts a star.

Snow flake schema: The normalized principles applied star schema is known as Snow flake schema. Every dimension table is associated with sub dimension table.

Differences:

- A dimension table will not have parent table in star schema, whereas snow flake schemas have one or more parent tables.

- The dimensional table itself consists of hierarchies of dimensions in star schema, where as hierarchies are split into different tables in snow flake schema. The drilling down data from top most hierarchies to the lowermost hierarchies can be done.