Filter interviews by
To find the second highest value in a table, we can use the ORDER BY and LIMIT clauses in SQL.
Write a SQL query to select all values from the table in descending order
Use the LIMIT clause to select the second row
Retrieve the value from the column containing the values
A cursor is a database object used to manipulate data in a result set.
A cursor allows you to iterate through a result set one row at a time.
It can be used to update or delete specific rows in a result set.
There are two types of cursors: static and dynamic.
Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;
Example: OPEN cursor_name; FETCH NEXT FROM cursor_name INTO variable_name;
Joins are used to combine data from two or more tables based on a related column between them.
Types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer jo...
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language.
It is used to communicate with and manipulate databases.
SQL can be used to create, modify, and retrieve data from databases.
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.
SQL is widely used in web development and data analysis.
What people are saying about Exela Technologies
SQL is a programming language used to manage and manipulate relational databases.
DDL stands for Data Definition Language and is used to define the structure of a database.
DML stands for Data Manipulation Language and is used to manipulate data within a database.
Examples of DDL commands include CREATE, ALTER, and DROP.
Examples of DML commands include SELECT, INSERT, UPDATE, and DELETE.
SQL is a programming language used to manage and manipulate relational databases.
SQL stands for Structured Query Language.
It is used to create, modify, and query databases.
DDL (Data Definition Language) is a subset of SQL used to define the structure of a database.
DDL commands include CREATE, ALTER, and DROP.
I should be hired because of my experience and skills in SQL programming and database management.
I applied via Recruitment Consulltant and was interviewed in Apr 2022. There were 2 interview rounds.
SQL is a programming language used to manage and manipulate relational databases.
DDL stands for Data Definition Language and is used to define the structure of a database.
DML stands for Data Manipulation Language and is used to manipulate data within a database.
Examples of DDL commands include CREATE, ALTER, and DROP.
Examples of DML commands include SELECT, INSERT, UPDATE, and DELETE.
SQL is a programming language used to manage and manipulate relational databases.
SQL stands for Structured Query Language.
It is used to create, modify, and query databases.
DDL (Data Definition Language) is a subset of SQL used to define the structure of a database.
DDL commands include CREATE, ALTER, and DROP.
I should be hired because of my experience and skills in SQL programming and database management.
I applied via Referral and was interviewed before Jun 2020. There were 5 interview rounds.
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language.
It is used to communicate with and manipulate databases.
SQL can be used to create, modify, and retrieve data from databases.
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.
SQL is widely used in web development and data analysis.
Joins are used to combine data from two or more tables based on a related column between them.
Types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer join re...
A cursor is a database object used to manipulate data in a result set.
A cursor allows you to iterate through a result set one row at a time.
It can be used to update or delete specific rows in a result set.
There are two types of cursors: static and dynamic.
Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;
Example: OPEN cursor_name; FETCH NEXT FROM cursor_name INTO variable_name;
To find the second highest value in a table, we can use the ORDER BY and LIMIT clauses in SQL.
Write a SQL query to select all values from the table in descending order
Use the LIMIT clause to select the second row
Retrieve the value from the column containing the values
I applied via Naukri.com and was interviewed before Jan 2021. There was 1 interview round.
Stock split is a corporate action where a company increases the number of its outstanding shares by dividing each share into multiple shares.
Stock split is done to make shares more affordable for investors and increase liquidity.
There are different types of stock splits such as 2-for-1, 3-for-1, etc.
Other types of corporate actions include mergers, acquisitions, spin-offs, and dividend payments.
Corporate actions can af...
I applied via Walk-in and was interviewed before Aug 2021. There were 3 interview rounds.
What people are saying about Exela Technologies
I applied via Naukri.com and was interviewed in Mar 2021. There were 4 interview rounds.
DBMS stands for Database Management System. It is used to manage and organize data in a structured manner.
DBMS is used in various industries such as healthcare, finance, education, and more.
It helps in creating, modifying, and deleting data in a database.
DBMS provides security features to protect data from unauthorized access.
Examples of DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.
An object is a self-contained entity that contains data and behavior.
Objects are instances of classes
They have attributes (data) and methods (behavior)
Objects can interact with each other through method calls
Example: A car object has attributes like color, make, and model, and methods like start and stop
Sorting is the process of arranging data in a particular order.
Sorting can be done in ascending or descending order.
Common sorting algorithms include bubble sort, insertion sort, and quicksort.
Sorting can be done on various data types, including strings, numbers, and objects.
Sorting can be done using built-in functions in programming languages such as sort() in JavaScript.
Sorting can be optimized for performance by cho...
C is a procedural programming language while C++ is an object-oriented programming language.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance than C.
C++ has a larger standard library than C.
C++ allows function overloading while C does not.
C++ supports exception handling while C does not.
Yes, my family is supportive of my career and relocation decisions.
My family understands the importance of career growth and is supportive of my decisions.
We have discussed the possibility of relocation and they are willing to make the necessary adjustments.
They trust my judgment and believe that this move will be beneficial for my career.
We have also considered the quality of life in Hyderabad and believe that it will...
I appeared for an interview in Jun 2017.
I applied via LinkedIn and was interviewed before Jun 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
based on 29 reviews
Rating in categories
Processor
433
salaries
| ₹1 L/yr - ₹3 L/yr |
Software Engineer
426
salaries
| ₹3.5 L/yr - ₹8 L/yr |
Data Entry Operator
413
salaries
| ₹1 L/yr - ₹3.2 L/yr |
Test Analyst
212
salaries
| ₹3.8 L/yr - ₹7.8 L/yr |
Senior Software Engineer
180
salaries
| ₹7.7 L/yr - ₹13.7 L/yr |
Synechron
Movate
Sopra Steria
NCR Corporation