DXC Technology Software Engineer Interview Questions and Answers

Q1. Tell me about JOIN queries
Ans. 
JOIN queries combine rows from two or more tables based on related columns, enabling complex data retrieval.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.a_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.a_id;

• RIGHT JOIN: Returns all records from the right ...read more
Answered by AI
Add your answer
Q2. Tell me about your projects
Ans. 
I have worked on various projects, including web applications, mobile apps, and data analysis tools, showcasing my diverse skill set.
• Developed a responsive web application using React and Node.js for an e-commerce platform, improving user engagement by 30%.

• Created a mobile app for tracking fitness activities, utilizing Flutter and Firebase, which gained over 10,000 downloads in the first month.

• Implemented a data analys...read more
Answered by AI
Add your answer

Q1. Can you describe your work experience?
Ans. 
I have over five years of experience in software development, focusing on web applications and cloud-based solutions.
• Developed a scalable e-commerce platform using React and Node.js, improving load times by 30%.

• Led a team of 4 in migrating legacy systems to AWS, resulting in a 40% reduction in operational costs.

• Implemented CI/CD pipelines using Jenkins, which decreased deployment times from hours to minutes.

• Collaborate...read more
Answered by AI
Add your answer
Q2. Can you describe your roles and responsibilities?
Ans. 
As a Software Engineer, I design, develop, and maintain software applications while collaborating with cross-functional teams.
• Developed and maintained web applications using JavaScript and React, improving user experience and performance.

• Collaborated with product managers to gather requirements and translate them into technical specifications.

• Participated in code reviews to ensure code quality and adherence to best pra...read more
Answered by AI
Add your answer

Fibonacci series and program to find the max number in list

Q1. What is oops and explain each of the terms
Add your answer
Q2. What is list, dictionary, set and tuple and difference between them
Ans. 
List, dictionary, set, and tuple are data structures in Python with different characteristics and use cases.
• List: ordered collection of items, mutable (can be changed), represented by square brackets []

• Dictionary: unordered collection of key-value pairs, mutable, represented by curly braces {}

• Set: unordered collection of unique items, mutable, represented by curly braces {}

• Tuple: ordered collection of items, immutable ...read more
Answered by AI
Add your answer

Q1. What is Dns and what are its use
Ans. 
DNS stands for Domain Name System. It is a decentralized naming system for computers, services, or any resource connected to the Internet.
• DNS translates domain names to IP addresses

• It helps in locating resources on the Internet

• DNS servers store domain name records like A, CNAME, MX, etc.

• Examples: www.google.com translates to 172.217.3.196
Answered by AI
Add your answer
Q2. Do you know how to create user
Ans. 
Yes, I know how to create user accounts in software applications.
• Use a user interface to input user information such as username, password, and email.

• Store user information securely in a database.

• Implement authentication and authorization mechanisms to control user access.

• Provide functionality for users to update their profiles and reset passwords.
Answered by AI
Add your answer