Technology Questions

Both these are used to combine the results of different SELECT statements.

    UNION       - Selects only distinct values 

    UNION ALL - Selects duplicate values also

Syntax:

    SELECT column_name(s) FROM table1

    UNION / UNION ALL

    SELECT column_name(s) FROM table2;

Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.

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

1) List down usecases (taken from business cases) from function specs. For each use case write a test case and categorize them into sanity tests, functionality, GUI, performance etc. Then for each test case, write its workflow. 

2) For a GUI application - make a list of all GUI controls. For each control start writing test cases for testing of the control UI, functionality (impact on the whole application), negative testing (for incorrect inputs), performance etc.  

End of file  (10)

Duplicate key (22)

Record not found (23)

VSAM logic error  (90)

Open problem  (92)

Space problem (93)

If exception is generated  in try and if that exception is not catch by any catch then finally is executed.

If exception is generated in try and if that exception is caught by one of catch statements then also finally is executed.

if no exception is generated then also finally is executed.

“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.”

Windows services, previously known as NT services, are applications that are installed on the system as system services. In other words, Windows services are applications that run in the background with the Windows operating system. The primary use of Windows services is to reduce the consumption of memory required for performing backend operations. Let's take an example to understand this easily. Suppose you want to perform a variety of functions, such as monitor the performance of your computer or application, check the status of an application, and manage various devices, such as printers.

In such a case, you can use Windows services to reduce memory consumption. In addition, Windows services can run on your system even if you have not logged on to your computer. In addition, these services do not have any user interface.