Brillio Application Support Engineer Interview Questions and Answers

Q1. Out of two table employee and salary join both and 3rd max salary from salary.
Add your answer
Q2. How is problem management done.
Ans. 
Problem management involves identifying, analyzing, and resolving recurring issues to prevent future incidents.
• Identify the root cause of the problem

• Document the problem and its resolution

• Implement corrective actions to prevent recurrence

• Monitor and track the effectiveness of the solution

• Collaborate with stakeholders to ensure continuous improvement
Answered by AI
Add your answer

Q1. Moderate core java coding questions
Add your answer
Q2. SQL based questions
Add your answer
Q3. Previous project experiences
Add your answer
Q4. Major contribution to project
Ans. 
Led the development of a new software tool that increased efficiency by 30%.
• Managed a team of 5 engineers to design and implement the tool

• Conducted user testing and gathered feedback for iterative improvements

• Presented the final product to stakeholders and received positive feedback
Answered by AI
Add your answer
Q5. What are day to day activities
Ans. 
Day to day activities involve troubleshooting technical issues, providing customer support, testing new applications, and collaborating with other teams.
• Troubleshooting technical issues with software or hardware

• Providing customer support via phone, email, or in person

• Testing new applications or software updates

• Collaborating with sales, marketing, and development teams

• Attending meetings to discuss project progress and r
Answered by AI
Add your answer

Deep coding knowledge required

Q1. Had Technical Interview
Add your answer

Q1. Discussion with manager
Add your answer

Q1. Had HR discussion one to one
Add your answer

Q1. Basic C#, authorization, SSO
Add your answer
Q2. Sql Coding regarding group by , nth highest number
Ans. 
Answering a question on SQL coding for group by and nth highest number.
• Use GROUP BY clause to group the data based on a column

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

• Use LIMIT clause to limit the number of rows returned

• Use OFFSET clause to skip the first n rows

• Example: SELECT column_name FROM table_name GROUP BY column_name ORDER BY column_name DESC LIMIT n OFFSET m
Answered by AI
Add your answer

Q1. Select from employees tables all those who don't work in any department.
Add your answer
Q2. What is a cursor and write a query
Ans. 
A cursor is a database object used to retrieve data from a result set one row at a time.
• A cursor is used to iterate through a result set.

• It can be used to update or delete rows in a table.

• Example query: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;

• Example usage: OPEN cursor_name; FETCH NEXT FROM cursor_name INTO @variable1, @variable2;

• Example usage: CLOSE cursor_name; DEALLOCATE cursor_name;
Answered by AI
Add your answer
Q3. How early you can join
Add your answer

Coding plus aptitude

Code pairing round with one question and an hour to solve

Q1. Oops, dsa, java
Add your answer
Q2. Projesct related
Add your answer

Q1. Cultural fit round was kinda HR but more topics involved
Add your answer