SunTec Business Solutions Interview Questions and Answers

Q1. Write a code to pull-up mass data from one table and load into our rough table ? Written the code efficiently Again asked how to tune this code with performance efficiency. Answered correctly about more ...read more
Ans. 
Code to pull-up mass data from one table and load into another table efficiently
• Use INSERT INTO SELECT statement to pull data from source table and load into target table

• Use WHERE clause to filter data if required

• Use INDEXES on columns used in WHERE clause to improve performance

• Use BULK COLLECT to fetch data in batches to improve performance

• Use PARALLEL hint to execute the query in parallel if the table is large

• Use NOL...read more
Answered by AI
Add your answer

Q1. Normal basic and advanced topic related question and asked some tricky question About PLSQL and performance tunning AwR ,ADDM difference asked gather stats
Add your answer

Q1. General question about my Experience and functional
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer
Q3. What are your salary expectations?
Add your answer
Q4. What is your family background?
Add your answer
Q5. Share details of your previous job.
Add your answer
Q6. Tell me about yourself.
Add your answer

Good communication and aptitude

Sort array in descending order

Q1. Introduction on myself and background
Add your answer

Q1. Basic java api questions
Add your answer

Q1. Write SQL join queries
Ans. 
SQL join queries are used to combine rows from two or more tables based on a related column between them.
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match
Answered by AI
Add your answer