SIEMENS
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
(1 vote)
All are multiple choice
All are multiple choice questions.60 questions to be answered in 60 mins.
Distribution of questions:
---10 questions from data structures and some general topics.
-----10 questions from Unix and C.
--7Questions from Data base.
----Remaining from Windows(x windows,MS Windows etc..)
The distribution is not exact.Only approximate.
Totally there are six sections as below:
1.General
2.Unix and c
3.RDBMS
4.C++/Object oriented
TCP/IP
6not remembered.
The questions are as follows:
RDBMS-----
1.What is RDBMS...Def
2.Two tables are given.In 1st table 2 columns are there.one
isEmployee no,second is salary.In second table 3 columns are there,one is employee no,second is date,3rd is salary.
Select employee no,from table1,table 2.
How many records it will contain?.(This is somewhat difficult).
3.What is transaction?
TCP/IP:
1.X.25 protocol belongs to which layer.
2,Order all the 7 layers in sequence
3,One node has 2 IP address but data goes through only one link.What is the reason?
4,Router,Bridge,Gateway....Which one of these can not connect
two different Lans and is protocol sensitive.
5,Client sends server---reqest or demand or -----Choices
are given.
Another section...
1.main(argc,argv)
{
if(argc<1)
printf("error");
else
exit(0);
}
If this program is compiled without giving any argument ,what it will print.
2.What are the static variables...def
3.What is Dynamic allocation ?
4.Dead lock condition...What may be the condition for it.
5.Semaphore variable?..def
6.Most of the Windows operating systems are....choices are given like
----a,maltitasking, multiuser, multi processing
b,only.......&......
c,only........&......
like that
7.Properties of object oriented,(just recall the name of the properties like
inheritance,....
8.A program of C++,and two questions were based on the o/p of that program.
.................---------.................
Some more questions are not remembered.
Here I am concatenating another mail from my friend.The number of questions from different areas as mentioned before is not correct.The correct numbers are given below.
Sections...
1, 5Q ...x windows
2, 5Q .....MS Windows
3, 7Q.....Databases
4, 20 Q....General
5, 20Q....UNIX/C
6,5Q ....OOPS
Some questions.....
1,Sticky bit concept
2,Bourne shell.,no hup concept
3,Net work layers
4,Ethernet,Token Ring
5,
Unix...(Ans is Multitasking,Multi user)
6,Windows...(ans is pseudo multitasking)
7,IP Addresses
8,Normalisation(in data basese)
9,SQL Queries
10, semaphores
Post new comment