Placement Papers - TCS
TCS INTERVIEW - 25 NOV 2006 - HYDERABAD
Posted by :
Shakeer Baig.S
(5)
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
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
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers