Filter interviews by
Different types of joins in SQL
Inner join: returns only the matching rows from both tables
Left join: returns all rows from the left table and the matching rows from the right table
Right join: returns all rows from the right table and the matching rows from the left table
Full outer join: returns all rows from both tables, including non-matching rows
Cross join: returns the Cartesian product of both tables
Top trending discussions
posted on 14 Oct 2024
I applied via Campus Placement and was interviewed in Sep 2024. There were 2 interview rounds.
To reverse two numbers without using a temp variable, use bitwise XOR operation.
Use bitwise XOR operation to swap two numbers without using a temp variable.
Example: a = 5, b = 7. a = a XOR b, b = a XOR b, a = a XOR b. After this, a = 7, b = 5.
I want to join Thermo Fisher because of their reputation for innovation and impact in the scientific community.
Thermo Fisher is a leader in the scientific research and healthcare industry
I am impressed by their commitment to innovation and cutting-edge technology
I believe working at Thermo Fisher will provide me with opportunities for professional growth and development
posted on 29 Feb 2024
Core java , string, thread , sql, mvc, spring boot
posted on 13 Apr 2024
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
posted on 3 May 2022
I applied via Approached by Company and was interviewed in Nov 2021. There were 4 interview rounds.
To become a technical leader in software engineering, contributing to innovative projects and mentoring junior engineers.
To continuously enhance my technical skills and stay updated with the latest technologies.
To lead and deliver complex software projects successfully.
To mentor and guide junior engineers, fostering their growth and development.
To contribute to the development of innovative and impactful software solut...
Secure cloud deployments can be implemented through various measures such as encryption, access control, and regular security audits.
Implement encryption for data at rest and in transit
Use access control mechanisms to restrict unauthorized access
Regularly conduct security audits to identify and address vulnerabilities
Implement multi-factor authentication for added security
Ensure compliance with industry standards and r...
Check server logs, review code, test endpoints, and verify database connections.
Check server logs for error messages
Review code for syntax errors or logical mistakes
Test endpoints using tools like Postman or cURL
Verify database connections and credentials
Check for any recent changes or updates
Consider scaling issues or server overload
Consult with team members or experts if necessary
My next career goal is to become a technical lead and mentor junior engineers.
I want to take on more leadership responsibilities and guide a team towards success.
I plan to enhance my skills in project management and communication.
I aim to contribute to the growth and development of the organization.
I aspire to continuously learn and stay updated with the latest technologies and industry trends.
posted on 20 Dec 2024
I applied via campus placement at Amrita Vishwa Vidyapeetham, Amritapuri Campus and was interviewed in Jun 2024. There were 2 interview rounds.
I am a software engineer with experience in developing web applications using Java, Spring Boot, and Angular.
Developed a web application for a retail company using Java and Spring Boot
Implemented RESTful APIs for communication between frontend and backend
Designed and developed user interfaces using Angular framework
Use modular arithmetic to efficiently rotate array n times.
Use modular arithmetic to calculate the effective number of rotations (n % array length)
Reverse the entire array
Reverse the first n elements
Reverse the remaining elements
The company is a leading software development firm specializing in creating innovative solutions for various industries.
Specializes in creating innovative software solutions
Works with clients from various industries
Known for high-quality and reliable products
Has a strong team of software engineers and developers
I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 4 interview rounds.
Algorithms and data structures questions similar to leetcode
posted on 13 Apr 2024
posted on 14 Oct 2024
I applied via Campus Placement and was interviewed in Sep 2024. There were 2 interview rounds.
To reverse two numbers without using a temp variable, use bitwise XOR operation.
Use bitwise XOR operation to swap two numbers without using a temp variable.
Example: a = 5, b = 7. a = a XOR b, b = a XOR b, a = a XOR b. After this, a = 7, b = 5.
I want to join Thermo Fisher because of their reputation for innovation and impact in the scientific community.
Thermo Fisher is a leader in the scientific research and healthcare industry
I am impressed by their commitment to innovation and cutting-edge technology
I believe working at Thermo Fisher will provide me with opportunities for professional growth and development
Lupin
Zydus Lifesciences
Standard Chartered
Intas Pharmaceuticals