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 applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.
First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.
I applied via Recruitment Consulltant and was interviewed before Jul 2021. There was 1 interview round.
Experienced professional with a strong educational background and clear career ambitions, eager to contribute to the company's success.
I have over 5 years of experience in project management, leading teams to successfully deliver complex projects on time.
I hold a Master's degree in Business Administration from XYZ University, where I specialized in strategic management.
My family has always emphasized the importance of ...
I applied via Naukri.com and was interviewed before Feb 2020. There were 3 interview rounds.
Workflow, trigger, reports, roles, profiles, permission set, and sharing rules are all important features in Salesforce.
Workflow is a series of automated steps that can be used to streamline business processes.
Triggers are used to execute code before or after a record is inserted, updated, or deleted.
Reports are used to display data in a visual format, such as a table or chart.
Roles are used to define the hierarchy of ...
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 Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.
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