Add office photos
Exela Technologies logo
Employer?
Claim Account for FREE

Exela Technologies

3.3
based on 1.4k Reviews
Video summary
Filter interviews by
Programmer Analyst
Fresher
Clear (1)

Exela Technologies Programmer Analyst Interview Questions and Answers

Updated 5 Feb 2024

Q1. What is SQL? define ddl? Why should we hire you?

Ans.

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.

View 10 more answers
right arrow

Q2. What is sql ?

Ans.

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.

View 3 more answers
right arrow
Exela Technologies Programmer Analyst Interview Questions and Answers for Freshers
illustration image

Q3. What is SQL? What is ddl? What is dml?

Ans.

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.

Add your answer
right arrow

Q4. Find the second highest value in table

Ans.

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

Add your answer
right arrow
Discover Exela Technologies interview dos and don'ts from real experiences

Q5. What is cursor .?

Ans.

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;

Add your answer
right arrow

Q6. Type of joins .?

Ans.

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 returns all rows from both tables, with NULL values for non-...read more

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Programmer Analyst Interview Questions from Similar Companies

Cognizant Logo
3.7
 • 243 Interview Questions
View all
Recently Viewed
INTERVIEWS
Ocwen Financial Solutions
No Interviews
INTERVIEWS
Integrated Wireless Solutions
No Interviews
SALARIES
Indus Net Technologies
SALARIES
Ocwen Financial Solutions
INTERVIEWS
Indus Net Technologies
No Interviews
INTERVIEWS
Ericsson
No Interviews
SALARIES
Ocwen Financial Solutions
INTERVIEWS
Alepo Technologies
No Interviews
INTERVIEWS
UKG
No Interviews
INTERVIEWS
Exela Technologies
No Interviews
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter