Hai Chetanaites, I am RAHIL WAHEED, IT From VSCE, KHAMMAM, AP.

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.
2. DBMS
3. SQL Queries.
4. C Concepts and Programs
5. OOPS Concepts and C++ Programs
6. Computer Networks
7. Data Structure Concepts
8. Software Engg.
9. HTML
10. .Net Basic Concepts, as I have done Project on this Platform.
http://www.ChetanaSinterview.com
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
7. HTTP,IP,MAC
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
3. CMMI
4. Process Models..
    Waterfall model
    Incremental Model
    RAD Model
    Prototyping
    Spiral Model
    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...
    Unit Testing
    Integration Testing
    Smoke Testing
    Validating Testing
    System Testing
10. Testing Tactics......
    White Box Testing
    Black Box Testing
    Refer their differences, Advantages, Drawbacks
11. Debugging.
    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.
2. Objects
3. Classes
4. Data Abstraction and Encapsulation
5. Inheritance
6. Polymorphism
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
17. Templates

The Important Interview C Concepts are as follows......
1. Static Variable http://www.ChetanaS.org
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
6. Preprocessor..Directives..
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
         Loops, conditions.

Also Prepare  all the Important C PROGRAMS...such as ....
1. Factorial
2. Factors of gn No.
3. Prime No.
4. Sum of the Factors
5. Armstrong
6. Polendrium
7. Reverse
8. Amicable
9. Recursion
10. Fibanacci Series
11. Searching and Sorting
12. Matrix Multiplication

The Important Interview DBMS Concepts are as follows......
1. Data, DataBase, Properties http://www.ChetanaS.org
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.
9. NORMALIZATION
10. Normal Forms..1st, 2nd, 3rd, 4th, BCNF...
11. Entity,Attributes,RelationShip
12. Transaction Processing
13. ER Model
14. RDDMS
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
    FCFS
    SJF
    Priority
    Round Robin
4. Threads definition , basic concept
5. Schedulers
    Long term
    Short term....
6. Memory Mgmt
7. Swapping
8. Fragmentation
9. Paging
10. Segmentation
11. Binary Semaphore
12. Thrashing
13. Virtual Memory
14. Demand Paging
15. Dead Locks C hetan aS
16. DL prevention, DL Avoidance
17. Bankers Algorithm
18. Process Synchronization
19. Critical Section problem
20. Semaphores
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......
1. Definition
2. Applications of DS
3. Stacks Queues
    Definitions
    Algorithms
    Applications
4. Prefix Postfix Forms
5. Linked List
    Definitions
    Types ..Single and Double
    Algorithms
    Applications
6. Sorting Techniques
    Quick Sort
    Insertion Sort
    Merge Sort
    Heap Sort
7. Trees
    Definitions
    Binary Tree
    Important Terminologies
    Tree Traversals
8. Graphs
    Graph Traversal
    Breadth First Search
    Depth First Search    
9. Minimal Spanning Tree Algorithms
10. Hashing

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
3. Constraints
4. Referencial Intergrity
5. SQL operators
6. Joins...Equi, Self,Outer,..
7. Cursor Management
8. Triggers
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