1. Diff betn case and decode 2. Primary unique keys 3. Diff betn proc and function 4. Query for 2nd highest sal dept wise 5. Query to find sum witbout using aggregate 6. Queries on count distinct 7. Updating 2 tables in a single query

Question

Accepted Answer

Answers to interview questions for Senior Software Engineer

1. CASE is used to provide conditional logic in SQL queries, while DECODE is used to perform conditional value substitution.
2. Primary keys are used to uniquely identify each record in a database table.
3. Procedures and functions are both database objects that encapsulate a series of SQL statements, but functions return a value while procedures do not.
4. SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
5. SELECT col1 + col2 + col3 FROM table_name;
6. SELECT COUNT(DISTINCT column_name) FROM table_name;
7. UPDATE table1, table2 SET table1.column = value1, table2.column = value2 WHERE condition;

1. Diff betn case and decode 2. Primary unique keys 3. Diff betn proc and function 4. Query for 2nd highest sal dept wise 5. Query to find sum witbout using aggregate 6. Queries on count distinct 7. Updating 2 tables in a single query

Top Majesco Senior Software Engineer interview questions & answers

Popular interview questions of Senior Software Engineer

Top HR questions asked in Majesco Senior Software Engineer