TCS Assistant System Analyst Interview Questions, Process, and Tips

It was an off-campus MBA drive, and the questions were related to quantitative and qualitative analysis, English, and business topics.

Q1. Introduce yourself.
Ans. 
I am a dedicated Assistant System Analyst with a passion for optimizing systems and enhancing user experiences through technology.
• Educational Background: Bachelor's degree in Computer Science, focusing on systems analysis and design.

• Professional Experience: Over 3 years of experience in analyzing user requirements and translating them into technical specifications.

• Technical Skills: Proficient in SQL, Python, and variou...read more
Answered by AI
Add your answer
Q2. What is the difference between a primary key and a foreign key?
Ans. 
A primary key uniquely identifies a record in a table, while a foreign key links records between tables.
• A primary key must contain unique values and cannot be NULL.

• Example: In a 'Users' table, 'UserID' can be a primary key.

• A foreign key is a field in one table that links to the primary key of another table.

• Example: In an 'Orders' table, 'UserID' can be a foreign key referencing 'Users'.

• Primary keys ensure entity integr...read more
Answered by AI
Add your answer
Q3. What are Joins in SQL?
Ans. 
Joins in SQL combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the le...read more
Answered by AI
Add your answer
Q4. What do you know about generative AI?
Add your answer
Q5. What are the 4 P's of marketing?
Ans. 
The 4 P's of marketing are Product, Price, Place, and Promotion, essential for effective marketing strategies.
• Product: The item or service offered, e.g., a smartphone with unique features.

• Price: The cost consumers pay, e.g., premium pricing for luxury brands.

• Place: Distribution channels, e.g., selling online vs. in retail stores.

• Promotion: Marketing communications, e.g., social media advertising or TV commercials.
Answered by AI
Add your answer
Q6. Why did you do MBA and what you've learnt during your MBA?
Ans. 
I pursued an MBA to enhance my business acumen and leadership skills, gaining valuable insights into management and strategy.
• Developed strong analytical skills through case studies, enabling me to assess business situations critically.

• Learned about strategic management, which taught me how to align business goals with operational capabilities.

• Gained experience in team collaboration during group projects, enhancing my l...read more
Answered by AI
Add your answer

Basic logical reasoning and Quantitative Aptitude

Normal Aptitude test consisting of time, age, profit loss and integrals - 60 minutes

3 coding questions 1 easy 1 medium and 1 difficult

Q1. Asked me about DBMS and project related
Add your answer
Q2. Basic HR question too
Add your answer
Q3. Are you willing to relocate
Add your answer
Q4. Curd rules in database
Ans. 
Curd rules are constraints that ensure data integrity in a database.
• Curd rules are used to enforce data consistency and accuracy.

• They prevent invalid data from being entered into the database.

• Examples of curd rules include unique constraints, foreign key constraints, and check constraints.
Answered by AI
Add your answer
Q5. Normalizations - 1nf, 2nf, 3nf
Add your answer