Siemens Information Systems Limited Placement Paper
Company: Siemens Information Systems Limited
I attended the test n got selected
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 Ch etan aS
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-4 : HR
qns asked
1. favourite subject in college.
As I said datawarehousing next qn was difference between database n datawarehouse
2. rest all wer HR qns
Finally I was selected and placed in the SAP dept.
Hope all this helps.
ALL D BEST.
Siemens Information Systems Limited Placement Paper