Protechsoft Technologies SQL Developer Interview Questions and Answers

Q1. Types of Indexes
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered indexes physically reorder the data in the table based on the index key.

• Non-clustered indexes create a separate structure for the index, pointing back to the original table data.

• Unique indexes ensure that no two rows have the same values in the indexed columns.

• Composite indexes are created on multiple columns to improve...read more
Answered by AI
Add your answer
Q2. Sceanrio based question
Add your answer

Q1. Salary discussion
Add your answer
Q2. Joining date and last working date
Add your answer

Profit and loss,percentage

Q1. Why do you this job ?
Add your answer
Q2. How can i believe you are the best to our company?
Add your answer

Learn basics of aptitude

Q1. Learn oops conceps and knowledge of coding in any language
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. All the questions related to my resume
Add your answer
Q2. Questions on my project, my internships earlier
Add your answer
Q3. And my knowledge about Java and basic knowledge of web development
Add your answer

Q1. Basic core java questions, spring boot and spring mvc questions and other project related questions
Add your answer

Q1. Project related questions and infrastructure of application
Add your answer

Q1. Salary negotiation, company policy explanation
Add your answer

Q1. If a application is running slow what process would you follow to find root cause of this? Specify for database , backend api and frontend side.
Ans. 
Process to find root cause of slow application for database, backend api and frontend side.
• Check server logs for errors and warnings

• Use profiling tools to identify bottlenecks

• Optimize database queries and indexes

• Minimize network requests and optimize API responses

• Reduce image and file sizes for faster loading

• Use caching to reduce server load

• Check for memory leaks and optimize memory usage
Answered by AI
Add your answer
Q2. Basic API questions- DI, Ef querying databs Angular basics
Add your answer
Q3. Basic sql queries, joins
Add your answer

Round duration - 90 minutes
Round difficulty - Easy

First Round-It was 90 minutes round and basically contains aptitude question which you need to solve quickly.

Q1. MCQs
Normal aptitude and English and reasoning questions.
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

My interview started and the interviewer asked me to introduce myself. Also he asked me some questions related to my hobbies like the last movie I saw in theatre (these questions are asked to make you comfortable and familiarise you with the interview) .

After this he asked me about my projects.
In which technology did I work. What is my project all about , what are its features and how is it useful in the real world.

After this, since I made my project in native Android using Java he asked me some conceptual questions in Java.He asked me about Collection framework.
After this he asked me about OOPs.What is OOPs, then he asked me about polymorphism and told me to explain it.

Finally, he gave me a question and asked me to code it.
Q. Find the second largest element in the given array (don't use sorting ).
Eg. arr={6,7,8,9,0}
Then, output=8

Interview took around 35-40 min .
At last he asked me if I had any questions for him to which I replied in what technologies do I get to work on if I get selected.

Q1. 
Find the Second Largest Element
Given an array or list of integers 'ARR', identify the second largest element in 'ARR'.
If a second largest element does not exist, return -1.
Example:
Input:
ARR = [2,...read more
Ans. 
first calculate the largest no. then again run the loop for entire array and find the no. just less then that largest no. but greater than other nos.
Answered Anonymously
Add your answer