TCS INTERVIEW - 25 NOV 2006 - HYDERABAD
I am very excited to share my Interview Experience and Preparation Procedure which I followed. By the God's Grace I cleared off the written test, results were out on 23th Oct.
"Hard Work Doesn't Go Unnoticed"
TCS started the Interview Process from 8th Nov, i.e., only on Weekends. So, Luckily I got around 25 days for the Interview preparation. So I felt that it's a very good enough time to prepare each and every academic subjects. I collected all the Interview Questions and experiences from the Internet. I assigned equal days for each and every subject that is must yar!. I even prepare the Hard Copy of Interview Questions so that it gets easy to Refer me on time.
The Academic Subjects which I prepared are as follows........
1. Operating System.
3. SQL Queries.
4. C Concepts and Programs
5. OOPS Concepts and C++ Programs
6. Computer Networks
7. Data Structure Concepts
8. Software Engg.
10. .Net Basic Concepts, as I have done Project on this Platform.
The Important Interview Topics of the Computer Networks are as follows......
1. WAN, LAN Comm. Networks
2. Circuit Switching, Packet Switching
3. Frame Relay, ATM, ISDN
4. TCP/IP Model layers
5. OSI Model
6. Topologies.., Bus, Ring, Tree and Star
Refer the "William Stallings" Book for the Computer Network that is more than enough yar!
The Important Software Engg. Concepts are as follows......
1. Software Characteristics
2. Nature of Software
4. Process Models..
Refer their differences, Advantages, Drawbacks.
5. S/W Engg. Practice i.e., S/W engg. Steps
6. Testing Principles
7. Software Quality Assurance
8. Configuration Mgmt.
9. Testing Strategies...
10. Testing Tactics......
White Box Testing
Black Box Testing
Refer their differences, Advantages, Drawbacks
Refer the "Roger Pressman" Book for the Software Engg. that is more than enough yar!
The Important Interview OOPS Concepts are as follows......
1. Characteristic, features Benefits of OOPs.
4. Data Abstraction and Encapsulation
7. Dynamic Binding
8. Message Passing
9. OOPs Applications
10. Virtual Functions
11. Pure Virtual Functions
12. Function Prototyping
13. Inline Functions
14. Function Overloading
15. Constructors and Destructors
16. Operator Overloading
The Important Interview C Concepts are as follows......
1. Static Variable
2. Pointers..usage, reasons, application, syntax..
3. Structure,Unions...Syntax, programs, advantages,differences..
4. Arrays,,,,,,,,, Syntax, Types, programs, advantages
5. Dynamic Memory allocations..Malloc, Calloc
7. Macro, file, Compiler Directive
8. Variables, Data Types
9. Storage Classes in C
Automatic.. Static.. External.. Register.
10. Files ..Basic idea, Syntax
11. Command line Arguments
12. Bit Fields
13. Control Statements in C
Also Prepare all the Important C PROGRAMS...such as ....
2. Factors of gn No.
3. Prime No.
4. Sum of the Factors
10. Fibanacci Series
11. Searching and Sorting
12. Matrix Multiplication
The Important Interview DBMS Concepts are as follows......
1. Data, DataBase, Properties
2. Advantages of Using the DBMS approach
3. Three Schema Architecture
4. Data Independence
5. Data Model
6. Classification of DBMS
7. Relational Model concepts
8. Super Key, Candidate Key, Primary Key.
10. Normal Forms..1st, 2nd, 3rd, 4th, BCNF...
12. Transaction Processing
13. ER Model
15. Functional Dependences
16. Armstrong Rules.
Refer the "Elmasri Navathe" Book for the Fundamentals of DataBase Systems. That is more than enough yar!
The Important Interview OS Concepts are as follows......
1. OS definition
2. CPU Scheduling
3. Scheduling Algorithms
4. Threads definition , basic concept
6. Memory Mgmt
11. Binary Semaphore
13. Virtual Memory
14. Demand Paging
15. Dead Locks
16. DL prevention, DL Avoidance
17. Bankers Algorithm
18. Process Synchronization
19. Critical Section problem
21. Bound Buffer Problem
22. Readers Writers Problem
23. Dining Philosopher Problem
Refer the "GALVIN & GAGNE" Book for the Operating Systems Concepts. That is more than enough yar!
The Important Interview DS Concepts are as follows......
2. Applications of DS
3. Stacks Queues
4. Prefix Postfix Forms
5. Linked List
Types ..Single and Double
6. Sorting Techniques
Breadth First Search
Depth First Search
9. Minimal Spanning Tree Algorithms
Its good rather better to prepare all the above topics, even if u have time make a hard copy of the important topics, as I did it..."Hard Work Doesn't Go Unnoticed"
Coming to SQL, it is must u to prepare SQL other than DBMS becoz they will ask the Queries, SubQuries. The Important Interview SQL Queries are as follows..
1. Components of SQL
DDL DML TCL DCL...syntax..examples..
2. Datatypes in SQL
4. Referencial Intergrity
5. SQL operators
6. Joins...Equi, Self,Outer,..
7. Cursor Management
Next about the HTML, it is very easy one gather the Important tags..if u know the HTML and placed in ur resume.
And about the .Net ........it depends on the project u have taken in ur academics. TCS interviewers definitely will ask queries on the Academic Project which u have done. So, be good at ur PROJECT DOCUMENTATION yar! Make sure that u have good knowledge on the Platform u opt in ur Project.
Prepare each and every topic which I mentioned above it may be useful to U
U will get Confidence if u go thru all the Topics. If u prepare the Hard Copy it will be Handy to U for the Reference at any time
3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.