Perceptive Solution Designer Interview Questions and Answers

Q1. Singleton in java code. multithreading, spring boot questions.
Add your answer
Q2. SQL queries for finding highest salary
Ans. 
SQL queries to find highest salary
• Use the MAX() function to find the highest salary

• Combine with the SELECT statement to retrieve the corresponding employee details

• Use the ORDER BY clause to sort the results in descending order

• Use the LIMIT clause to limit the number of results returned
Answered by AI
View 1 more answer

It was an aptitude test

Q1. It was technical test
Add your answer
Q2. Sort an array with numbers
Ans. 
Use a sorting algorithm like quicksort or mergesort to rearrange the numbers in ascending or descending order.
• Implement a sorting algorithm like quicksort, mergesort, or bubblesort to rearrange the numbers in the array.

• Ensure the algorithm is efficient and handles edge cases like empty arrays or arrays with duplicate numbers.

• Test the sorting function with different arrays to verify its correctness.

• Example: [5, 2, 9, 1,
Answered by AI
Add your answer

Complexity level - moderate. Basic concepts.

Q1. Questions to assess how independently a candidate can work.
Add your answer
Q2. - Can you work independently? - Can you work under pressure in a dynamic environment?
Ans. 
Yes, I have experience working independently and thrive in dynamic environments.
• I have successfully completed multiple projects on my own, demonstrating my ability to work independently.

• I am comfortable making decisions and solving problems without constant supervision.

• I have experience working in fast-paced environments where I had to adapt quickly to changing priorities and deadlines.
Answered by AI
Add your answer

Q1. Self and other tools
Add your answer
Q2. Jenkins Linux Ansible git AWS
Add your answer

Q1. SQL interview question
Add your answer
Q2. Stored Procedure and function differences
Ans. 
Stored procedures are precompiled and stored in the database, while functions are compiled and stored in memory.
• Stored procedures are precompiled and stored in the database for reuse.

• Functions are compiled and stored in memory for faster execution.

• Stored procedures can return multiple values, while functions return a single value.

• Functions can be called from within a stored procedure, but stored procedures cannot be ca
Answered by AI
Add your answer
Q3. SQL query flow and window function they will ask
Add your answer

Q1. Expected salary
Add your answer

Q1. Expertise details asked
Ans. Any medical emergency can be handled
Answered Anonymously
Add your answer
Q2. About Govt guidelines for pollution control
Add your answer