Siemens

SIEMENS PAPER ON 18th DECEMBER 2007 AT SIEMENS-WORLD

25 qns tech n 25 qns quant. 0.25 negative marking
cut off is 8 and 12 respectively
time limit 35 min.
Round -1
technical
1. A c++ prgm is given n find the output(a static function calls a nonstatic function)
2. what is normalization( choices are all very similar so read the proper defn frm textbook.
3. In UNIX how to delete a file? ans>> 'rm' command
4 In UNIX how to concatenate or see the details of a file ? and is 'cat>>filename' cmd
5. qn related to editors in UNIX ans is' vi editor'
6. in java to ensure that no threads are being updated simultaneously monitors are used and also synchronised keyword is used.
7. sm qn related to oracle window application.
8. what is primary key?
9. oracle is a rdbms

quantitaive
1. qn related to time n work
2. qn related to typing papers (related to time n work) ans is 75 or sm value in 70s.
3. qn related to percentage
4 qn related to profit n loss
5.qn related to simple interst
6. qn related to time, speed n distance where distance is miles per hr and time is in minutes.
7. complete the series
1,4,9,16,? ans is 25
two more such series
8. encryted word(each alphsbet replaced by its next)
two of such ones
9. 4+x^2= x^3? whats x? ans x=2

start quantitaive frm behind as its easy n one can finish it fast.

Round-2
Technical cum HR.

qns asked.
1. what is normalization?
2. what r the types of normal forms no explaination was asked
3. explain all projects done.
rest all qns wer hr

Round-3
Technical cum HR

Qns asked
1. if u delete an entry frm table what can u do?
ans rollback if delete is used and cant rollback if truncate is used they asked me if i knew the concept of recovery but i didnt know as it was not thr in syllabus

2. explain the difference between delete n truncate
ans delte is ddl nad truncate is dml with truncate the structure of database is lost

3. whats a foreign key or wats the referential intergrity constraint?

4 in MS Access wats created first the table or dtabase? its database
REst all wer Hr qns

Round -3
HR
qns asked
1. favourite subject in college.
As I said datawarehousing next qn was difference between datbase n datawarehouse
2. rest all wer hr qns





SIEMENS PAPER ON 12th SEPTEMBER 2007


1)which of following operator can't be overloaded.
a)== b)++ c)?! d)<= 2)#include main() { printf("Hello World"); } the program prints Hello World without changing main() the o/p should be intialisation Hello World Desruct the changes should be a)iostream operator<<(iostream os, char*s) os<<'intialisation'<<(Hello World)<>
a) b) c) d)
4) term stickily bit is related to a)kernel
b)undeletable file
c) d)none
5)semaphore variable is different from ordinary variable by
6)swap(int x,y)
{
int temp;
temp=x;
x=y;
y=temp;
}
main()
{
int x=2;y=3;
swap(x,y);
}
after calling swap ,what are yhe values x&y?

7) static variable will be visible in
a)fn. in which they are defined
b)module " " " "
c)all the program
d)none
8)unix system is
a)multi processing
b)multi processing ,multiuser
c)multi processing ,multiuser,multitasking
d)multiuser,multitasking
9)x.25 protocol encapsulates the follwing layers
a)network
b)datalink
c)physical
d)all of the above
e)none of the above
10)TCP/IP can work on
a)ethernet
b)tokenring
c)a&b
d)none
11)a node has the ip address 138.50.10.7 and 138.50.10.9.But it is
transmitting data from node1 to node2only. The reason may be
a)a node cannot have more than one address
b)class A should have second octet different
c)classB " " " " "
d)a,b,c
12) the OSI layer from bottom to top
13)for an application which exceeds 64k the memory model should be
a)medium
b)huge
c)large
d)none
14)the condition required for dead lock in unix sustem is
15)set-user-id is related to (in unix)
16) bourne shell has
a)history record
b)
c)
d)
17)wrong statement about c++
a)code removably
b)encapsulation of data and code
c)program easy maintenance
d)program runs faster
18)struct base {int a,b;
base();

int virtual function1();
}
struct derv1:base{
int b,c,d;
derv1()
int virtual function1();
}
struct derv2 : base
{int a,e;
}
base::base()
{
a=2;b=3;
}
derv1::derv1(){
b=5;
c=10;d=11;}
base::function1()
{return(100);
}
derv1::function1()
{
return(200);
}
main()
base ba;
derv1 d1,d2;
printf("%d %d",d1.a,d1.b)
o/p is
a)a=2;b=3;
b)a=3; b=2;
c)a=5; b=10;
d)none
19) for the above program answer the following q's
main()
base da;
derv1 d1;
derv2 d2;
printf("%d %d %d",da.function1(),d1.function1(),d2.function1());
o/p is
a)100,200,200;
b)200,100,200;
c)200,200,100;
d)none
20)struct {
int x;
int y;

abc;
you can not access x by the following
1)abc-->x;
2)abc[0]-->x;
abc.x;
(abc)-->x;
a)1,2,3
b)2&3
c)1&2
d)1,3,4
21) automatic variables are destroyed after fn. ends because
a)stored in swap
b)stored in stack and poped out after fn. returns
c)stored in data area
d)stored in disk
22) relation between x-application and x-server (x-win)
23)UIL(user interface language) (x-win)
24)which is right in ms-windows
a)application has single qvalue system has multiple qvalue
b) " multiple " " single "
c)" " " multiple "
d)none
25)widget in x-windows is
26)gadget in x_windows is
27)variable DESTDIR in make program is accessed as
a)$(DESTDIR)
b)${DESTDIR}
c)DESTDIR
d)DESTDIR
28)the keystroke mouse entrie are interpreted in ms windows as
a)interrupt
b)message
c)event
d)none of the above
29)link between program and out side world (ms -win)
a)device driver and hardware disk
b)application and device driver
c)application and hardware device
d)none
30)ms -windows is
a)multitasking
b) c) d)
31)dynimic scoping is
32) after logout the process still runs in the background by giving
the command
a)nohop
b)


33)process dies out but still waita
a)exit
b)wakeup
c)zombie
d)steep
34)in dynamic memory allocation we use
a)doubly linked list
b)circularly linked
c)B trees
d)L trees
e)none
35)to find the key of search the data structure is
a)hask key
b)trees
c)linked lists
d)records
36)data base

employ_code salary employ_code leave

from to

1236 1500 1238 --- ---
1237 2000 1238 --- ---
1238 2500 1237 ---
-----
1237 --- ---
1237 --- ---
1237 --- ---

select employ_code,employ_data ,leave
the number of rows in the o/p
a)18
b)6
c)7
d)3
37)DBMS
38)read about SQL,db
39)which is true
a)bridge connects dissimiler LANand protocol insensitive
b)router " " " " "
c)gateway " " " " "
d)none of the above
40)read types of tree traversals