Filter interviews by
Procedures in SQL are reusable blocks of code that perform a specific task.
Procedures are stored in the database and can be called multiple times.
They can accept input parameters and return output parameters.
Procedures can contain SQL statements, control-of-flow statements, and error handling.
Example: CREATE PROCEDURE GetEmployeeDetails AS SELECT * FROM Employees;
Example: EXEC GetEmployeeDetails;
== is used for comparing reference equality, while .equals is used for comparing object equality in Java.
== compares memory addresses of objects
.equals compares the actual content of objects
== is used for comparing primitive data types
.equals is used for comparing objects in Java
Quick sort is a sorting algorithm that uses divide and conquer approach to sort an array efficiently.
Divide the array into two sub-arrays based on a pivot element
Recursively sort the sub-arrays
Combine the sorted sub-arrays to get the final sorted array
Example: [3, 6, 8, 10, 1, 2, 1] -> [1, 1, 2, 3, 6, 8, 10]
Print a pyramid star pattern using nested loops.
Use nested loops to print spaces and stars in each row
Increment the number of stars in each row to form a pyramid shape
SQL joins are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables in a single query.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Selection sort is a simple sorting algorithm that repeatedly selects the minimum element from an unsorted portion of the array and swaps it with the first unsorted element.
Iterate through the array to find the smallest element.
Swap the smallest element with the first unsorted element.
Repeat the process for the remaining unsorted portion of the array.
Time complexity is O(n^2) and space complexity is O(1).
I applied via Walk-in and was interviewed before Oct 2022. There were 2 interview rounds.
Selection sort is a simple sorting algorithm that repeatedly selects the minimum element from an unsorted portion of the array and swaps it with the first unsorted element.
Iterate through the array to find the smallest element.
Swap the smallest element with the first unsorted element.
Repeat the process for the remaining unsorted portion of the array.
Time complexity is O(n^2) and space complexity is O(1).
SQL joins are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables in a single query.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Procedures in SQL are reusable blocks of code that perform a specific task.
Procedures are stored in the database and can be called multiple times.
They can accept input parameters and return output parameters.
Procedures can contain SQL statements, control-of-flow statements, and error handling.
Example: CREATE PROCEDURE GetEmployeeDetails AS SELECT * FROM Employees;
Example: EXEC GetEmployeeDetails;
Print a pyramid star pattern using nested loops.
Use nested loops to print spaces and stars in each row
Increment the number of stars in each row to form a pyramid shape
== is used for comparing reference equality, while .equals is used for comparing object equality in Java.
== compares memory addresses of objects
.equals compares the actual content of objects
== is used for comparing primitive data types
.equals is used for comparing objects in Java
Quick sort is a sorting algorithm that uses divide and conquer approach to sort an array efficiently.
Divide the array into two sub-arrays based on a pivot element
Recursively sort the sub-arrays
Combine the sorted sub-arrays to get the final sorted array
Example: [3, 6, 8, 10, 1, 2, 1] -> [1, 1, 2, 3, 6, 8, 10]
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.
Several sql question
Array question reverse
Top trending discussions
I appeared for an interview before Jul 2020.
Yes, Infosys is listed on the Indian stock exchanges as well as on the NYSE.
Infosys is listed on the Bombay Stock Exchange (BSE) and National Stock Exchange of India (NSE)
It is also listed on the New York Stock Exchange (NYSE)
Infosys has a market capitalization of over $80 billion as of 2021
I applied via Job Fair and was interviewed before Feb 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Nov 2019. There were 3 interview rounds.
I'm seeking new challenges and opportunities for growth that align with my career goals and aspirations.
Desire for professional growth: I'm looking to expand my skill set and take on more leadership responsibilities.
Seeking a better cultural fit: My current company has a different work culture than what I thrive in; I value collaboration and innovation.
Interest in new technologies: I'm excited about working with cuttin...
I applied via Company Website and was interviewed before Mar 2021. There were 2 interview rounds.
Online aptitude test with English grammar and math skills
I come from a close-knit family that values education, hard work, and support for one another in all endeavors.
Supportive Environment: My parents always encouraged my siblings and me to pursue our passions, whether in academics or sports.
Diverse Background: My family has roots in different cultures, which has enriched our perspectives and fostered open-mindedness.
Strong Work Ethic: Both my parents worked hard to provid...
Experienced Senior Associate with a strong background in project management and team leadership, dedicated to driving results and innovation.
Over 7 years of experience in project management, successfully leading cross-functional teams to deliver projects on time and within budget.
Proficient in data analysis and strategic planning, having implemented a new reporting system that improved efficiency by 30%.
Strong communic...
I have studied various subjects including finance, economics, and data analysis, focusing on their applications in business strategy.
Finance: I studied corporate finance, learning about capital budgeting and financial analysis to make informed investment decisions.
Economics: My coursework included micro and macroeconomics, helping me understand market dynamics and economic indicators.
Data Analysis: I gained skills in d...
I applied via Approached by Company and was interviewed before May 2018. There were 6 interview rounds.
I am a dedicated and hardworking individual with a passion for learning and growth.
I have a Bachelor's degree in Business Administration from XYZ University.
I have 3 years of experience working in marketing and sales roles.
I am proficient in Microsoft Office Suite and have strong communication skills.
I am a team player and enjoy collaborating with others to achieve common goals.
My career objectives focus on continuous growth, contributing to team success, and making a positive impact in my field.
Aim to develop expertise in my field, such as becoming a certified project manager.
Seek leadership opportunities to guide and mentor junior team members.
Aspire to work on innovative projects that challenge my skills and creativity.
Desire to contribute to a company's mission, like improving customer sa...
TCS is a global leader in IT services with a strong reputation for innovation and client satisfaction.
TCS has a proven track record of delivering high-quality services to clients worldwide.
TCS offers a wide range of opportunities for career growth and development.
TCS values diversity and inclusion, creating a supportive work environment for employees.
TCS invests in cutting-edge technologies and training programs to kee...
I applied via Company Website and was interviewed before Feb 2020. There was 1 interview round.
I applied via Company Website and was interviewed before Jun 2020. There were 3 interview rounds.
Yes, I am comfortable with night shifts and have experience working during those hours.
I have worked night shifts in my previous job and have adapted to the schedule
I am a night owl and prefer working during those hours
I understand the importance of being alert and focused during night shifts
I am willing to adjust my sleep schedule to accommodate night shifts
based on 2 interview experiences
Difficulty level
Duration
based on 11 reviews
Rating in categories
Software Developer
16
salaries
| ₹3 L/yr - ₹7 L/yr |
React Native Developer
7
salaries
| ₹3 L/yr - ₹6 L/yr |
Junior Software Developer
4
salaries
| ₹3.5 L/yr - ₹4.2 L/yr |
Assistant Manager Operations
4
salaries
| ₹3 L/yr - ₹3.4 L/yr |
Mobile Application Developer
4
salaries
| ₹3 L/yr - ₹6 L/yr |
TCS
Accenture
Wipro
Cognizant