SQL Star  Placement Paper   Whole Testpaper   Not Specified-20 Jul 2007

SQL Star  Placement Paper   Whole Testpaper   Not Specified-20 Jul 2007


  • Posted by  FreshersWorld 
    7 Jan, 2012

    SQL STAR PAPER ON 20TH JULY 2007

    Duration: 90 Mins

    Max.Marks: 75 

    PART - I
    Aptitude

    Directions: Study the following mathematical problems. Encircle the right answer. 

    1.A 100 m train crosses a bridge in 25 seconds and crosses a platform twice as long as the bridge in 40 seconds. What is the time taken by the train to cross a
    platform of length 360 m, in seconds?
     
    (a) 28                           (b) 46                           (c) 54                           (d) 63 
    2.The number of science graduates to the number of commerce graduates in a class is in the ratio 4:5. If the ratio of the science teachers to science graduates is 1:8
    and the ratio of commerce teachers to commerce graduates is 1:6 and if the total number of graduates is 324, find the total number of teachers.

    (a) 42                           (b) 48                           (c) 54                           (d) 63 
    3.Timothy spent all of his money at five stores. At each store, he spent Rs.10 more than half of the amount he had while entering the store. How much money did he
    have when he entered the first store?

    (a) Rs.360                     (b) Rs.480                     (c) Rs.540                     (d) Rs.620 

    4.Train A leaves the station travelling at 30 kmph. Two hours later train B leaves the same station travelling in the same direction at 40 kmph. How long does it take for train B to catch up with train A?
     
    (a) 4.5 hours                 (b) 6 hours                      (c) 7.5 hours                
    (d) None of these 

    5.Pankaj with the help of Rohit can finish weeding the garden in 21 days and with the help of Qasar can weed it in 28 days. Pankaj, Qasar and Rohit start working together. After four days, Qasar quits and after another three days, Pankaj also quits. Rohit completes the remaining work in 16 days. In how many days would Pankaj alone weed the entire garden?

    (a) 35                           (b) 49                           (c) 63                           (d) 84 

    6.Archana and Swetha start walking together towards their school. If Swetha walks at her usual speed, she reaches school 15 min after Archana. If Swetha walks at twice her speed, she reaches the school 9 min earlier than Archana. What is the ratio of the speeds of Swetha and Archana?

    (a) 5:7                           (b) 9:11             (c) 12:17                       (d) 11:16 

    7.In a college, for every two people who take up biology, three take mathematics and for every 5 people who take commerce, seven take biology. If the total number of students in the college is 405, then the number of students who enrolled in mathematics is greater than those who enrolled in commerce by

    (a) 66                           (b) 77                           (c) 99                           (d) 121 

    8.Ramesh bought two dozen pencils and gave 25% of them to Geetha. Of the remaining, he gave one third to Vrinda. If he decides to give half of the remaining to Minchu, then what is the number of pencils left with him?

    (a) 4                             (b) 6                             (c) 7                             (d) 9 

    9.One fourth of 20% of a number is 16. What would be the value of 125% of the same number?

    (a) 240                          (b) 320                          (c) 400                          (d) 540 

    10.Twice the number of marbles Ananth has is equal to thrice the number of marbles Arun has. If  Ananth gives seven marbles to Arun, then the number of marbles with Arun and Ananth would be the same. What is the original number of marbles with Arun?

    (a) 28                           (b) 35                           (c) 42                           (d) 56 

    11.Sudha sold a radio at Rs.345 making a profit of 25(5/11)% had she bought it for Rs.25 more but sold at it at the same price, what would have been her profit percent?

    (a) 15                           (b) 18(1/50                    (c) 21                           (d) 23(1/2) 

    12.Shailaja told her children that if they help her with watering the garden she would give Rs.30. Her daughter Ritu can water the entire garden in 20 min and her son Ritesh can do the same in 30 min. Ritu's friend Payal helps them in watering the garden and all the three together finish gardening the entire garden in 8 min. What part of Rs.30 should Payal get?

    (a) Rs.12                      (b) Rs.10                      (c) Rs.8                                    (d) Rs.11 

    13.A cyclist cycling at a speed of 15 kmph is cycling to a place 40 km away. The cyclist takes a break of 5 min after every 30 min. If he starts at 6:00 a.m., then when does he reach his destination?

    (a) 8:45 a.m.                 (b) 8:55 a.m.                 (c) 9:05 a.m.                 (d) 9:10 a.m. 

    14.A trader bought 30 dozen bangles at Rs. 20 per dozen and 40 dozens at Rs. 24 per dozen.  Find the price at which he should sell the 70 dozens of bangles so as to make a profit of 40%.

    (a) Rs. 31.20                 (b) Rs. 22                     (c) Rs. 26.50                 (d) Rs. 33.60 

    15.S earns Rs. 6,900 per month. She spends Rs. 2,200 on food, Rs. 920 on petrol, and 10% of her salary on other incidentals. Find her savings in a year.

    (a) Rs. 41,400               (b) Rs. 2,090                 (c) Rs. 37,080               (d) Rs. 45,720 

    16.In a city, the auto tariff increases at 60 paise and the taxi tariff increases at 35 paise per year. If in 1986, the auto tariff is Rs. 4.40 and taxi tariff is Rs. 6.50, then find the year in which the auto tariff would be 70 paise more than the taxi tariff?
    (a) 1998                        (b) 1996                        (c) 1997                        (d) 1990 

    17.There are eight balls numbered 1 through 8 kept in a bag.  Murali removes all these balls one?by one at random and arranges them from left to right to form an eight digit number.  What is the probability that the number so formed would be a multiple of 9?

    (a) 0                              (b) 1/9                            (c) 8/9                       (d) None of these 

    18.The cost of labour in manufacturing cars has come down by 30% and cost of material has come down by 45%. If originally, the material accounted for twice as much of the manufacturing cost as labour and if it is assumed that total cost consists of only labour and material, what is the percentage decrease in the total cost?
    (a) 35 %                       (b) 40 %                       (c) 37.5 %                    (d) 42.5 % 

    19.A bus leaves city A at 7 a.m. for city B. Another bus leaves city B for city A at    4 p.m.  Each bus takes 12 hours to complete the journey. At what time will they meet?

    (a) 6 p.m.                      (b) 5 p.m.                      (c) 5.30 p.m.                 (d) 4.30 p.m. 

    20.In a school 4/7 of the students are boys and the rest are girls. On a particular day, 3/4 of the boys and 2/3 of the girls were present. How many more girls were absent than the boys if the total number of boys is 60 more than that of the girls?

    (a) 60                          (b) 30                             (c) 45                           (d) None of these 

    21.A and B travelled a certain distance at 10 kmph and 15 kmph respectively.  If A took twenty minutes more than B, then the distance travelled by them was

    (a) 10 km                      (b) 15 km                      (c) 30 km                      (d) 40 km 

    22.A man can row 9 km upstream and 15.6 km downstream taking 3 hours each time.  The speed of the water current is
    (a) 4.1 kmph                 (b) 1.4 kmph                 (c) 1.2 kmph                 (d) 1.1 kmph 

    23.The time taken by a train 120 m long running at 108 kmph to cross a platform 90 m long is

    (a) 7 sec                       (b) 10 sec                     (c) 4 sec                       (d) 9 sec 

    24.Subash purchased an article for Rs. x.  If he sold the same article for Rs. 56 and gained x%, then x=

    (a) 30                           (b) 42                           (c) 48                           (d) 40 

    25.A sum of money borrowed at CI becomes thrice itself in 4 years.  Then in how many years will it be 27 times  itself?

    (a) 8                             (b) 20                           (c) 16                           (d) 12 

    26.The simple interest on Rs. 6600 for 7 months at 10% per annum is

    (a) Rs. 355                    (b) Rs. 385                    (c) Rs. 475                    (d) Rs. 375 

    27.Swapna can do a job in 18 days.  Surekha is twice as efficient as Swapna.  Then the total time taken by them to complete the job (in days) is

    (a) 12                           (b) 10                           (c) 6                             (d) 8 

    28.A dishonest trader professes to sell his goods at the cost price, but uses a weight of  840 gms for a kilogram weight.  His approximate gain is

    (a) 21%                                    (b) 19%                                    (c) 17%                                    (d) 18% 

    29.Raju can copy 108 pages in 18 hours.  Raju and Ramesh can copy 207 pages in 23 hours.  Then time taken by Ramesh to copy 57 pages is (in hours)

    (a) 19                           (b) 23                           (c) 21                           (d) 17 

    30.On compound interest, a sum of money becomes Rs. 1870 in 2 years and Rs. 2057 in  3 years.  Then the rate of interest p.a is

    (a) 10%                                    (b) 12%                                    (c) 8%                          (d) 15% 

    31.The profit obtained when an article is sold for Rs. 427 is the same as the loss obtained when it is sold for Rs. 373.  At what price must the article be sold to get neither gain nor loss?

    (a) Rs. 400                    (b) Rs. 500                    (c) Rs. 415                    (d) Rs. 430 

    32.A person deposited Rs. 1000 in a bank. At the end of one year, the interest was added to his initial deposit and he deposited another sum of Rs. 1000. After one more year he collects a total amount of Rs. 2121.60. What is the rate of interest that the bank pays?
    (a) 2%                          (b) 4%                          (c) 6%                          (d) 8%

    33.Between 6:15 p.m. and 7:45 p.m. what is the angle of the arc described by the minute hand of a standard clock?

    (a) 90                           (b) 180                          (c) 540                          (d) 910  

    34.20 litres of a chemical X is added to 80 litres of a mixture that has 10% of X and 90% of Y. What is the percentage of X in the resulting mixture?

    (a) 15%                                    (b) 28%                                    (c) 33(1/3)%                 (d) 40% 

    35.A gardener has to plant 120 fruit trees in rows such that the number of trees in each row is the same. Assuming that there is space for any number of rows, in how many ways can he plant the trees?
    (a) 4                             (b) 6                             (c) 8                             (d) 16  

    PART- II

    Technical-C
    1.Predict the output or error(s) for the following:

    #include
    main()
    {
    struct xx
    {
          int x=3;
          char name[]="hello";
     };
    struct xx *s;
    printf("%d",s->x);
    printf("%s",s->name);}


    a) Compiler Error

    b) hello  

    c) hello name

    d)Warning : Structure is not defined properly

    2.Analyze the output

    #include
    main()
    {
    char s[]={'a','b','c','\n','c','\0'};
    char *p,*str,*str1;
    p=&s[3];
    str=p;
    str1=s;
    printf("%d",++*p + ++*str1-32);
    }

     a) 77  

    b) Linker Error

    c) warning : str is assigned value but never used

    d) some garbage value     

    3.#include

    main()
    {
    int a[2][2][2] = { {10,2,3,4}, {5,6,7,8}  };
    int *p,*q;
    p=&a[2][2][2];
    *q=***a;
    printf("%d----%d",*p,*q);
    }
    a) SomeGarbageValue

    b) 10,2,3,4,5,6,7,8

    c) compiler error

    d) no output 

    4.main()

    {
    char *p="hai friends",*p1;
    p1=p;
    while(*p!='\0') ++*p++;
    printf("%s   %s",p,p1);
    }

    a) ibj!gsjfoet

    b) hai friends

    c) compiler Error

    d) data is insufficient  

    5.         main()

    {

     static char names[5][20]={"pascal","ada","cobol","fortran","perl"};
     int i;
    char *t;
    t=names[3];
    names[3]=names[4];
    names[4]=t;
    for (i=0;i<=4;i++)
    printf("%s",names[i]);
    }

    a)         Compiler error: Lvalue required in function main

    b)                  pascal, ada, cobol ,fortran,perl

    c)                  garbage value

    d)                  pascal,ada,cobal,fortran. 

    6.         void main()
    {
                int  const * p=5;
                printf("%d",++(*p));
    }

     a) 5

    b) 6     

    c) 2546

    d) Compiler error: Cannot modify a constant value. 

    7.         #include

    #define clrscr() 100
    main()
    {
    clrscr();
    printf("%d\n",clrscr());
    }

     a) 100

     b) clrscr()

     c) output screen will be cleared

    d) in valid declaration in line number 2 

    8.Predict the output or error(s) for the following:

    #include

    main()

    {

    int i,j;
                for(i=0;i<=10;i++)
                {
                j+=5;
                assert(i<5);
                }


    a)      Runtime error: Abnormal program termination.
    b)      Linker Error

    c)      Warning: Function should return a value

    d)      Executes without any error

    9.         main()
                {
                int i=-1;
                +i;
                printf("i = %d, +i = %d \n",i,+i);
                }


    a) Compilation Error in line no 5

    b) Compilation Error in line no 4

    c) garbage value

    d) i = -1, +i = -1                                                                             

     
    10.       main()
                {
                char *cptr,c;
                void *vptr,v;
                c=10;  v=0;
                cptr=&c; vptr=&v;
                printf("%c%v",c,v);
                }

               a) ASCII equivalent value of c, 0

    b) 10,0

    c) Compiler error (at line number 4)

    d) 48, 0 

    11.       char c;

             c="a";  

             printf("%c", c);        

            a) The program will give Error status it cannot convert convert from char[2] to char.

            b) It will print  a

            c)It will print c

            d) none of the above       

    12.    main()

           {

              char var='B';

              char *ptr=&var;

              --*ptr;

              printf("%c", *ptr);

           }

    a)      *A

    b)      B

    c)      C

    d)      A

    13.what will be the value contained in Str1, if the given set of  statements are executed?

          char str1[5], str2[7];

          strcpy(str1,"Hell");

          strcpy(str2,"Yellow");

          strcat(str1, str2); 

    a)      Hell Yell

    b)      Yell

    c)      HellYell

    d)      Yellow

    e)      Hell

    14.       main()

                {

                 int ptr[5][5]={

                                     { 3,4,6,8,10},

                                      {11,2,9,7,1},

                                      {25,22,12,19,16},

                                      {13,26,23,20,21},

                                      {24,27,28,14,15}

                                     };

            printf("%d", *(*(ptr +1)+2));        

           }

        What will be the output?


    a)      9

    b)      22

    c)      2

    d)      12

    15.       main()

                {

                 int i;

                char ans;

               do

                 {

                  printf("Enter a number \n");

                  scanf("%d", &i);

                  if(i == 1)

                  break;

                  printf("1 \n");

                  printf("Do you wish to continue? Y/N \n");

                  ans=getchar();

                  }

    while(ans=='Y');

                 printf("Number was 1");

            }  

    What will be the output once the user enter the number 1?

    a) The program does not display any message   
    b) "Number was 1" gets displayed

    c) The above code generates an error

    d) "Do you wish to continue Y/N" get displayed   

    16.       main()

         {

          int i=2;

          recur(i);

         }

                     recur(int i)

         {

          if(i<5)

                {

                   i++;

                  recur(i);

                             printf("%d", i);

                            }

                            return i;

                            }  

                 predict the output 

       a) 5

       b) Infinite loop

       c) 2345

       d) 543

    17.       main()

       {

        int var=5;

        while(var=6)

                 {

         printf("100 \n");

         break;

                            }

                    return 0;

                   } 

     what is the output

     a) The program on execution does not display any value

     b) The program on execution display the number 100

     c) The program generates an error during compilation

     d) The program on execution displays the number 6 

    18.       main()

      {

       int ivar1=105;

       do

    {

          printf("%d",ivar1++);

                }

          while (ivar1<105);

                }

    a) 105
    b)105 106

    c)106

    d) will not code the loop because condition is   false 

    19.       main()

        {

         char cvar;

         cvar='B';

         char *cptr;

         cptr=&cvar;

         - -*cptr;

         printf("%c", *cptr);

        }

    a)      B

    b)      A

    c)      C        

    d)      *B 

    20        If you enter 'C' as the value for the variable what is the output of the following code.

      main()

    .  {

       char calpha;

       printf("\n Enter an alphabet in upper code");

       scanf("%c", &calpha);

       fflush(stdin);

      if ( calpha<='z' || calpha>='a')

       {

    printf("the character you have entered is correct');

      }

      else

                            {

    printf("\nthe character you entered is incorrect");

      }

    }


    a) The program will give a syntactical error

    b) The character you have entered is correct

    c) The program will give a compilation error

    d) The character you have entered is incorrect 

    21.       main()

                {

     int ivar, *iptr;

    ivar=5;

    iptr=&ivar;

    pritnf("%d \n", ivar);

    *iptr=*iptr+1;

    printf("%d \n",ivar);

    }

      what is the output

     

    a)      5 1      

    b)      5 0

    c)      5 6

    d)      5 5 

    22.       main()

       {

         FILE *fp;

         char acc_no[5];

         fp=fopen("FILE.DAT","r");

         fgets(acc_no,5,fp);

         fseek(fp, -4L, 2);

        }

     Which of the following Statements is True about the above Code?

    a)The file pointer will move 4 bytes ahead from the current position of the file by the fseek statement
    b)The file pointer will move 4bytes back from the current position of the file by the fseek statement
    c)The file pointer will move 6 bytes from the beginning of the fgets statement
    d)The file pointer will move 4 bytes back from end position of the file by the fseek statement.    

    23. What is the mimimum value of a signed int data type that is 8 bits in size?

    a)-128
    b)-127
    c)- 256
    d)-257 

    24. Identify the conversion specification used to print a character with printf() function
    a) %c
    b) %s
    c)%char
    d)&lc
     
    25. Identify the valid expressions in the declaration int y[5]={1,2,3,4,5};
    1. y[2]   2. *(y+2)    3. 2[y]
    a)option1
    b)option2
    c)options 1 and 2
    d)options 1,2 and 3
     
    26. The following declaration represents int (*(*a[3])())[5];
    a) array of pointers to a function returning an array of pointers to int
    b) array of pointers to a function returning a pointer to an array of int
    c) array of pointers to an array of pointers to function
    d) array of pointers to a function returning a pointer to a function 

    27. How to access the field regno given the following declaration?

     typedef struct stud
                   {
                    int regno;
                    char name[30];
                    }STUDENT;
                STUDENT *sp=malloc(sizeof(STUDENT));

    a) *sp.regno
    b) sp->regno
    c) (*sp).regno
    d) options b and c 

    28.  What is the output of the following code?
    int y=0; for(;;){if(y++ == 5)break;} 
    printf("%d\n",y);
    a) 0
    b) 5
    c) 6
    d) 7
    29.What is the value of a after execution of the expression a=b-=c*=5 given b=110 and c=20?
    a) 450
    b) 10
    c) 110
    d) -10 
    30.Identify the correct argument for the function call fflush() in ANSI  C.
    a)std out
    b)std in
    c)undefined
    d)invalid

    Technical-Operating System

    1.For Instruction decoding ______ register is used
    a)PC
    b) PSW
    c)IR
    d)SP 
    2.I/O techniques preferred is
    a)Polling
    b)Interrupt
    c)DMA
    d)PCI 

    3.Interrupt and Signals both are same. ( T/F   ) 

    4.To avoid RACE condition _______________is used.
    a)Mutual exclusion
    b)Thrashing
    c)Threading
    d)Memory Management 

    5.  _________________ is a memory _management  scheme that permits the page size and frame size to be same. 

    6.  ______________ can not create another process.
    a) fork()
    b) thread
    c) process
    d) program 
    7.Internal fragmentation is solved by
    a)Segmentation
    b)Paging
    c)Thrashing
    d)Multithreading 

    8.    _____________ keeps track of a proceses state   as well as the cpu state during process execution. 

    9.    ______________does not required to complete a critical task within a guaranteed amount of time 

    10    In Interrupt mode the kernel checks each I/O device if  it generated an interrupt or not. True/False?
































































2009-2016 downloadmela.com. All rights reserved.