Placement Papers - TCS

TCS INTERVIEW - 25 NOV 2006 - HYDERABAD

Hai Friends 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.

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
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
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
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