Manish Kumar Agarwal & Co Interview Questions and Answers

Research analysis involves interpreting data to draw conclusions and make recommendations.

• Research analysis involves examining data to identify trends and patterns.

• It includes interpreting findings to draw conclusions and make recommendations.

• Examples of research analysis tools include SPSS, Excel, and Tableau.

Program to swap two integers without using a temporary variable.

• Use bitwise XOR operation to swap the integers.

• XORing a number with itself results in 0.

• XORing a number with 0 results in the same number.

Program to check if given string is palindrome

• Create a function that takes a string as input

• Convert the string to lowercase to ignore case sensitivity

• Remove all non-alphanumeric characters from the string

• Reverse the string and compare it with the original string

• If they are the same, return true, else return false

Stored procedures are used to perform a set of actions, while stored functions return a single value.

• Stored procedures can perform multiple actions and can return multiple result sets.

• Stored functions are used to return a single value and cannot perform DML operations.

• Stored functions can be used in SELECT statements, while stored procedures cannot be used in SELECT statements.