Filter interviews by
I applied via Company Website and was interviewed in Feb 2023. There were 2 interview rounds.
OOPs is a programming paradigm that uses objects to represent real-world entities and provides encapsulation, inheritance, and polymorphism.
Encapsulation: Hides the implementation details of an object from the outside world
Inheritance: Allows creating a new class from an existing class
Polymorphism: Allows objects of different classes to be treated as if they are of the same class
Advantages: Reusability, Modularity, Fle...
Different types of joins are Inner Join, Left Join, Right Join, and Full Outer Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables, including non-matching rows.
WHERE clause filters rows before grouping, HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition
HAVING clause is used to filter groups based on a condition
WHERE clause is used before GROUP BY clause
HAVING clause is used after GROUP BY clause
WHERE clause cannot contain aggregate functions
HAVING clause can contain aggregate functions
Example: SELECT department, AVG(salary) FR...
Query to fetch details of employees in the same department
Use SELECT statement to fetch employee details
Use JOIN to join employee and department tables
Use WHERE clause to filter employees in the same department
I applied via Approached by Company and was interviewed before Aug 2022. There were 3 interview rounds.
Delete command removes rows one by one while truncate command removes all rows at once.
Delete is a DML command while truncate is a DDL command.
Delete can be rolled back while truncate cannot be rolled back.
Delete command fires triggers for each row deleted, while truncate does not.
Delete command is slower as it maintains logs for each row deleted, while truncate is faster as it does not maintain logs.
Delete command can...
To join two tables with inner join, use the JOIN keyword along with the ON clause to specify the join condition.
Use the JOIN keyword to combine rows from two tables based on a related column between them
Specify the join condition using the ON keyword followed by the columns to join on
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Use SQL query with GROUP BY and HAVING clause to delete duplicate records in a table.
Identify the columns that define a duplicate record
Write a SQL query to select the duplicate records using GROUP BY and HAVING clause
Delete the duplicate records using DELETE statement with the identified criteria
posted on 27 Aug 2015
posted on 23 Mar 2015
During my summer training, I learned various programming languages, software development methodologies, and practical application of theoretical concepts.
Learned programming languages such as Java, Python, and SQL
Gained knowledge of software development methodologies like Agile and Waterfall
Applied theoretical concepts in real-world projects, enhancing problem-solving skills
posted on 13 Oct 2017
I appeared for an interview in Mar 2017.
Developed a web-based inventory management system for a retail company
Used HTML, CSS, and JavaScript for the frontend
Implemented a backend using PHP and MySQL for data storage
Designed a user-friendly interface for adding, updating, and deleting products
Implemented features like barcode scanning and real-time stock tracking
Conducted testing and debugging to ensure system functionality
As a mechanical engineering graduate, I see myself in an IT firm leveraging my problem-solving skills and technical knowledge to contribute to software development and innovation.
Applying my analytical and logical thinking skills to develop efficient software solutions
Utilizing my understanding of engineering principles to design and optimize software systems
Collaborating with cross-functional teams to integrate mechan...
My favorite subject is computer science.
I enjoy studying algorithms and data structures.
I find programming languages fascinating.
I am interested in software engineering principles and practices.
My daily routine involves a mix of coding, collaborating with team members, and continuous learning.
Start the day by checking emails and responding to any urgent messages
Attend daily stand-up meetings to discuss progress and plan the day's tasks
Work on coding tasks assigned by the team lead or project manager
Collaborate with team members to troubleshoot issues and brainstorm solutions
Participate in code reviews to ensu...
I plan to be an efficient employee by continuously improving my skills, being proactive, and collaborating effectively with my team.
Continuously improving my skills through self-learning and professional development opportunities
Being proactive in identifying and solving problems before they escalate
Collaborating effectively with my team by actively participating in meetings, sharing knowledge, and seeking feedback
Prio...
My smartphone is the most important gadget in my life.
My smartphone helps me stay connected with family and friends
I use it for work-related communication and tasks
It serves as a source of entertainment during leisure time
I can access important information and services through it
It also serves as a camera for capturing memories
Examples: iPhone, Samsung Galaxy, Google Pixel
posted on 6 Sep 2017
I appeared for an interview before Sep 2016.
I am a recent graduate with a degree in Computer Science and a passion for software development.
Recent graduate with a degree in Computer Science
Passionate about software development
Experience with programming languages like Java and Python
posted on 7 May 2017
I appeared for an interview before May 2016.
In 5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.
Continuing to enhance my technical skills through ongoing learning and certifications
Taking on more leadership responsibilities within the team
Contributing to the company's growth and success through my expertise
Mentoring junior team members to help them grow in their careers
posted on 17 Mar 2015
I appeared for an interview before May 2016.
posted on 7 Apr 2016
based on 2 interviews
Interview experience
based on 11 reviews
Rating in categories
Data Engineer
5
salaries
| ₹4.5 L/yr - ₹10 L/yr |
Associate Software Engineer
4
salaries
| ₹4.5 L/yr - ₹9 L/yr |
Assistant Manager
4
salaries
| ₹5 L/yr - ₹15.5 L/yr |
Business Development Executive
4
salaries
| ₹3 L/yr - ₹4.8 L/yr |
US IT Recruiter
4
salaries
| ₹2.4 L/yr - ₹8 L/yr |
TCS
Infosys
Wipro
HCLTech