Filter interviews by
I applied via LinkedIn and was interviewed before Nov 2023. There was 1 interview round.
Stored procedures and functions are precompiled SQL queries that can be stored and executed on the database server.
Stored procedures are a set of SQL statements that are stored on the database server and can be called by applications.
Functions are similar to stored procedures but return a value.
Stored procedures can accept input parameters and return multiple result sets, while functions can only return a single value.
...
Trigger is a special type of stored procedure that automatically executes when an event occurs in a database. Index is a data structure that improves the speed of data retrieval operations on a database table.
Trigger is used to maintain the integrity of the database by enforcing business rules or cascading changes.
Indexes are used to quickly locate data without having to search every row in a database table.
Examples: A...
Commit and Rollback are database transactions used to save or discard changes made to the database.
Commit is used to save the changes made in a transaction to the database permanently.
Rollback is used to discard the changes made in a transaction and revert the database to its previous state.
Commit makes the changes permanent while Rollback cancels the changes.
Example: If a transaction involves updating multiple records...
Join is used to combine rows from two or more tables based on a related column between them.
Types of Joins: Inner Join, Left Join, Right Join, Full Join, Cross Join
Inner Join: Returns rows when there is at least one match in both tables
Left Join: Returns all rows from the left table and the matched rows from the right table
Right Join: Returns all rows from the right table and the matched rows from the left table
Full Jo...
Union and Intersection are set operations in mathematics. Union combines all elements from two sets, while Intersection finds common elements.
Union combines all elements from two sets into a single set
Intersection finds common elements between two sets
Example: Set A = {1, 2, 3} and Set B = {3, 4, 5}. Union of A and B is {1, 2, 3, 4, 5}. Intersection of A and B is {3}
The new row will start from 1 after truncating a table.
Truncating a table removes all rows from the table, resetting the row count to 1.
The next row inserted after truncation will have an ID of 1.
Truncating a table does not reset the auto-increment value of the primary key column.
I have the skills, experience, and passion to excel in this role.
I have a strong background in software development, with experience in multiple programming languages and frameworks.
I am a quick learner and enjoy tackling new challenges.
I am a team player and enjoy collaborating with others to achieve common goals.
I am passionate about software engineering and am always looking for ways to improve my skills and knowled...
I chose your company because of its reputation for innovation and its commitment to employee growth.
Your company has a strong reputation for innovation in the industry.
I was impressed by the emphasis on employee growth and development.
I believe that your company's values align with my own personal values.
I was excited about the opportunity to work with a talented team of engineers.
Your company's mission and vision reso
I appeared for an interview before Sep 2016.
I applied via Recruitment Consultant and was interviewed before Sep 2018. There were 4 interview rounds.
I appeared for an interview in Jul 2017.
I am a software engineer with experience in developing and maintaining software applications.
I have a strong background in programming languages such as Java, C++, and Python.
I have worked on various projects, including developing web applications and implementing software solutions.
I am skilled in problem-solving and debugging, ensuring efficient and effective software development.
I have experience in collaborating wi...
I learned valuable teamwork and problem-solving skills during my summer internship.
Developed strong collaboration skills by working with a team of software engineers to complete projects
Gained experience in troubleshooting and debugging software issues
Learned to effectively communicate and present technical concepts to both technical and non-technical stakeholders
Improved problem-solving abilities by identifying and re...
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Jr. Data Scientist
7
salaries
| ₹3.2 L/yr - ₹9 L/yr |
Software Developer
5
salaries
| ₹3.2 L/yr - ₹9 L/yr |
Data Analyst
5
salaries
| ₹2 L/yr - ₹7.2 L/yr |
Mobile Developer
4
salaries
| ₹4 L/yr - ₹5.4 L/yr |
Business Operations Associate
3
salaries
| ₹2.5 L/yr - ₹2.5 L/yr |
Infosys
TCS
Wipro
HCLTech