Aparajitha Corporate Services Interview Questions and Answers

A change request in an application is serviced by the development team through various stages such as business analysis, code analysis, discussion with BA, and requirement freeze.

• The development team starts by analyzing the change request to understand its impact on the application.

• They perform business analysis to determine the feasibility and potential risks of implementing the change.

• Code analysis is conducted to assess the impact on existing code and identify any necessar...read more

Procedure to return a series (99, 96, 93, ...., 6, 3)

• Create a temporary table with a single column

• Use a loop to insert values into the temporary table

• Return the values from the temporary table in descending order

The result sets of all types of joins in SQL

• Inner Join: Returns only the matching rows from both tables

• Left Join: Returns all the rows from the left table and the matching rows from the right table

• Right Join: Returns all the rows from the right table and the matching rows from the left table

• Full Outer Join: Returns all the rows from both tables, including the unmatched rows

• Cross Join: Returns the Cartesian product of both tables

Functions and procedures are both stored database objects used to perform specific tasks in SQL.

• Functions return a value while procedures do not.

• Functions can be used in SQL statements, whereas procedures cannot.

• Functions can have input parameters and return a single value, while procedures can have input and output parameters.

• Functions are typically used for calculations or data manipulation, while procedures are used for executing a series of SQL statements.

• Examples of func...read more

To extract execution plan of a SQL query, use EXPLAIN or SHOW PLAN command.

• Use EXPLAIN or SHOW PLAN command before the SQL query

• EXPLAIN command shows the execution plan in a tabular format

• SHOW PLAN command shows the execution plan in a graphical format

• Execution plan helps in optimizing the query for better performance