Informatica Placement paper 2011

Thursday, November 24, 2011
Informatica Placement paper 2011

we had a placement test of informatica on 24-11-2011.
we have been informed that 2 written tests, 3 to 4 tr rounds, 1 hr round.

two tests have been conducted
1.Objective test: Duration-45min Questions:45

sections:
 Section1:database-20q
 Sections2:operating systems-15q
 Section3:progamming:5q
 Section4:aptitude-5q

negative mark of 0.5 for each wrong answer

section1:

1.pl/sql abbrevation
2.create table as select * from
where "some condition"?
   a.creates a with the rows selected from the

   b.creates a   from
with the empty rows
   c.wrong syntax
3.select dept_no,count(emp_no) from emp GROUPBY dept_no HAVING (emp_no>0)
    a.returns empty rows
    b.returns rows with the dept having atleast 1 employee
    c.query evaluates if the having clause is before groupby
   d.none
4.

section2:
1.'chown' command in UNIX is used to change ........?
2. a directory has files like File1.txt,fIle1.txt,file1.txt,FILE1.txt . Now tha command returns?
  ls -l 'pipe operator' grep -i file*.txt
 a.file1.txt,fIle1.txt
 b.file1.txt
 c.none

3. what does telnet command do?
4.755 permissions to the file indicate user,group,others?
  a. read-write-execute, read-write, read-write
  b. read-write-execute,read-execute,read-execute
  c.none
section3:
 1. what is the output if fn(7) is called?
     fn(int v)
      {
        if(v==1||v==0)
        return 1;
       elseif(v%2==0)
       return fn(v/2)+5;
     else
    return fn(v-1)+3;
     }

2.

section 4:
  1. how many zeroes will be in the product of 1 t0 100 (i.e.,1*2*3*.....*99*100) like in 100  there 2 zeroes?
  a.11
b.17
c.23
d.24
 ans:c
 2. there is some meeting of delegates of some nations.
  they shook hand with each other, except the indian and pakisthani dint shook hands each  other. there are 90 handshakes, then how many delegates are present in the meenting?
a.13
b.14
c.12
d.15
ans: b
3. what is the angle between the minute ahnd nad hour hand when the tym is 3:15 in an  analog clock?



2.subjective test: Questions: 10
   no negative mark
  1. what is the inline function in c++? can we write recursive functions in inline? if we write  recursive functions will the code be compiled without errors?
  2. select * from EMp;
      emp_no           off_no        empname
   -------------------------------------------------------
    312                       12                    james,joe
    312                       12                   jack,hillary
    405                         5                    sunny,michel
    312                       11                    jill,edward


  2.i.   write query to display the duplicate rows?
  2.ii.  write a query to delete ALL tha duplicate rows? (no single row of duplicate row shd b  present)
  2.iii. write a query to delete the duplicate rows leaving one row of duplicate?
  3. write an efficient code to display the unique elemants in the sorted array?
   eg: (1,3,3,3,5,5,5,9,9,9,9)-->(1,3,5,9)
  4. question on Unix command
 5 question on Unix command