Application Support Interview Questions

Application Support Interview Questions for Professionals

Application Support Interview Questions :

In my previous articles I have added many SQL interview questions for helping the people.In this article i will share Application Support Interview Questions with answers.I will focus on SQL as well as unix interview questions which are useful for Technical Support Engineers. The Application Technical support is not only development work but also testing work.It is combination of both work and supporting the client.There are two types of Technical Supports available.I will try to give you Application level Technical support interview questions which includes not only system related questions but also SQL related questions as well.

Question 1 : What is mean by Technical Support in your words? Why you choose career in it?

Answer :

The above questions is more behavioral question rather than the technical question.According to the situation candidate needs to answer that questions. I will give you example for the same.

Answer from user perspective :

I choose to go into technical support because I’ve been fascinated by technology all my life, and I also like working with people. I want to use my technical knowledge to  solve issues customers are having.I also wants to apply my knowledge which is related to unix as well as related to SQL to solve the customer issues.

Question 2 :What is application support?What technologies it includes.( 100 % asked Application Support Interview Questions )

Answer :

The application support is supporting the delivered application to the customer with using different technical skills.The user will require any of the technical skills. The Unix and SQL skills are required to troubleshoot the application related issues.Mainly to work with technical support user needs to know about basics of SQL as well as basics of unix.

The Required technologies for application support are :

  1. Any front End technology (java,.net)
  2. Any back-end technology (Oracle,Mysql)
  3. Unix Commands

Question 3 : Explain one common scenario of application support you have faced.( 100 % asked Application Support Interview Questions )

Answer :

The above question is also more behavioral question you need to answer it technically.According to situation candidate need to answer that.

Answer from user perspective :

I would like to explain the application crash scenario. Application crash is one of the most common scenario technical support engineer facing.The most basic reason of application crash is unhandled exceptions. Due to some unhandled exceptions and different structures of looping in application user will face application crash.

Question 4 : How user can handle application crash issue? Is there any troubleshooting mechanism for the same?

Answer :

The System crash issue mainly occurs due to the unhandled exceptions. There are multiple ways to troubleshoot this issue and following are most common ways to resolve application crash issue .

  1. Just try to check for Unhanded exception. If there are unhandled exceptions user need to add the Error code and Error description for the same.
  2. The Full stack trace of exceptions so that user will check what is happened from application end.
  3. After taking the permission just restart the unix server and check whether application is working or not.

Question 5 : Tell me some important skill to do technical support job?

Answer:

The technical support engineer should know all the technical skills related to that application. I would like to give you most important skills required by technical support engineers .

1.Technical Knowledge of Front End :  User must know about the technologies used in that specific application. Whether it is java,.net or any other technology.

2.Technical Knowledge about back end : User must know about back-end technologies used in that application.

3.SQL Skills : User must know the SQL to troubleshoot the application level issues.

4.Communication skill : User must have good communication skill so that user can understand the exact issue.

5.Knowledge of Tools : There are so many tools for issue tracking and management. The application support engineer must have knowledge of different tools.

Question 6 : What is SQL? How it is used in application support.( 100 % asked Application Support Interview Questions )

Answer :

SQL Stands for Structured Query Language which is specially designed to communicate with databases.SQL pronounced as Sequel is very widely used language in most of the database management systems like Oracle,MySQL,PostgreSQL etc.SQL provides us  a simple and efficient way of reading,writing,executing the data from the system.this is one of the SQL Interview Question ever asked in interviews.

For application support engineers SQL is useful in troubleshooting the issue. There are so many request to check whether that user is active or not active. In such cases the application support engineer checks by firing some queries from back-end.

Question 7 : What is difference between varchar and varchar2 datatype?

Answer:

Varchar can store up to 2000 bytes and varchar2 can store up to 4000 bytes of memory space.Varchar will occupy the space for null values whereas varchar2 can not occupy the space for null values.So varchar2 is good to use not to  face performace related problems.varchar2 is faster than varchar datatype.

Question 8 : How to represent comments in oracle?

Answer:

There are following 2 ways for commenting in oracle:

1.Single Line comment: Two dashes (–) before begining of the line

2. Multi-line comment/Block comment:When user wants to comment multiple line /* */ operators are used.

Question 9 : What is Database?( 60 % asked Application Support Interview Questions )

Answer:

  • It is a collection of Inter-Related data. Records the data in HDD (Permanent Memory).
  • Inter-Related data means relation among data values
  • Objective of DB is to record data & save it for future use.

Question 10 : .What is RDBMS?

Answer:

RDBMS stands for Relational DataBase Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

Question 11 : What are tables and Fields?

Answer:

A table is set of data which is organized in to specific structured manner.Table is made up of combination of columns and rows.A table has specified number of column called fields but can have any number of rows which is called record.

Example:Table

Name(Field 1) Salary(Field 2)
Amit S(Record1) 10000(Record1)

Question 12 : What are different challenges user will face while doing application support duties?

Answer:

The above questions is more behavioral question rather than the technical question.According to the situation candidate needs to answer that questions. I will give you example for the same.

Answer from user perspective :

The most important quality of Technical support engineer is patience as well as calmness.There are so many times the frustrated customers who use abusive language. At such times its important to remain calm and show empathy towards the customer.

Question 13 : How knowledge of Unix helpful in technical support?( 100 % asked Application Support Interview Questions )

Answer:

Unix operating system is one of the most used and secure operating system which is using in development and deployment of lot of applications.Because of the Security of the UNIX operating system this is used in 90 percent of applications as a server operating system.Unix is Multi-user and Multitasking operating system which is used mainly as server in most of the applications.Now a days unix is using as a server operating system to handle so many applications .So if user have good knowledge of unix it will be helpful.

“Unix is simple,stable,multi-user,multitasking operating system which is used for Servers,Desktops and laptops..”

Application Support Interview Questions

Question 14 :If user wants to display current user information which command is useful?

Answer :

Whoami :

This command displays current user information.

Example:

$Whoami

Output : Amit

Question 15.Which command is useful to show present working directory?

Answer:

PWD :

PWD is most commonly used command which is used to show the present working directory of the user.

Example:

$PWD

Output:\home\Amit

Question 16 : How to switch from one user account to other user account in Unix?

Answer:

The SU (Super user command) is used to switch from one user account to another user account.

Example :

$SU Rohit

the  above command switches account named “Amit” to account named “Rohit”.

Question 17 :  Have you done any automation for monitoring the system tasks?

Answer :

The above questions is more behavioral question rather than the technical question.According to the situation candidate needs to answer that questions. I will give you example for the same.

Answer from user perspective :

I had developed Log monitoring system’s scripts to keep track of exceptions. I am also using tool that notifies the stakeholders if any exceptional happen within the system.

Question 18 : Can we delete multiple files at a same time in Unix? How?

Answer:

rm command is used to delete multiple files at a same time.

Example:

$ rm file1 file2 ……File_N

E.g: rm Amit_Emptyfile

Question 19 : What does (.) And (..) means in unix?

Answer:

The current directory (.)

In UNIX, (.) means the current directory, so typing cd .

NOTE: there is a space between cd and the dot

Means stay where you are (the unixstuff directory).

This may not seem very useful at first, but using (.) as the name of the current directory will save a lot of typing.

The parent directory (..)

(..) Means the parent of the current directory, so typing cd .. Will take you one directory up the hierarchy (back to your home directory).

Question 20 : What is the UNIX command to list files/folders in alphabetical order?

Answer:

The ‘ls –l’ command is used to list down files and folders in alphabetical order. When you use ‘ls –lt’ is list down files /folders sorted with modified time.

Question 21: What code would you use in a shell script to determine if a directory exists?

Answer:

The UNIX test command with the -d option can be used to determine if a directory exists.

Example:
The following test command expression would be used to verify the existence of a specified directory, which is stored in the variable $mydir:

if [ -d $mydir ]
then
command(s)
fi

If the value stored in the variable mydir exists and is a directory file, the command(s) located between then and fi will be executed.

You can consult the test command’s man page (“$ man test”) to see what test command options are available for use.

Question 22 : What is the biggest challenge you come across as IT support analyst role and how did you solve the problem ?

Answer :

The support analyst role itself is a challenge. We require to deal with multiple teams and customers as well. I would like to give a simple example about the challenge which i have faced.

In one of the application the high priority incident came. I have access of logs and servers. But there is tier-3 team who has to deal with this code related issue. But The tier-3 team is somehow not available. So by taking permission of client we have updated millions of values on  database. The impact was so high and we have resolved that.

Question 23 :How did you manage the urgent issue when customer request and how did you mange it with time to over the situation to solve the problem ?( 100 % asked Application Support Interview Questions )

Answer :

As “customer is king” we require to manage or plan some time in work day to handle customer related issues. May customer will give you the ad-hoc issues. But in that case i am resolving issue then after that logging that issue in issue management system. It will show my work as well as time spent on customer issue.

Question 24 : How did you manage the difficult customer request and what action took to solve the issue ?

Answer :

The key work of Support analyst is to prioritize the work according to business impact. If some of the difficult customer requests are coming and which has huge business impact we require to give the highest priority to that incidents.

Question 25 : If application down how to troubleshoot the issue?

Answer :

This is the most asked application support interview question. So there are so many causes of the application down. If you require to troubleshoot the issue if application down kindly use the following steps ,

  1. Check whether application server is reachable. Most of the cases the application will down if server is down. If server has issues then tell server team to troubleshoot issue or restart the server.
  2. If any other issue check the deployment architecture of the application side.
  3. Else check application configurations and resolve issue accordingly.

Question 26 : How to resolve P1 issue? If 2 P1 issues come at a same time how to act?

Answer :

The P1 issue is always critical .You should have list ready for contact persons of dependent services. You require to contact those immediately. You need to be calm and check all configurations,databases and troubleshoot issue accordingly.

If two P1 issues come at a time you require to prioritize the issue. You require to inform to your higher management in that case and ask for quick resource allocation if both issues are important.

These are above some important interview questions for application support engineer. Hope you like this article on Application Support Interview Questions.If you like this article on Application Support Interview Questions kindly comment in to comment section.

407 Replies to “Application Support Interview Questions for Professionals”

          1. Hi,

            can you please send application support interviews question and answer to my blow mention mail id.
            msd.3474@gmail,com.

            thanks.

          2. Hello Nitin,

            Joins Interview Questions : http://www.complexsql.com/sql-joins-interview-questions/http://www.complexsql.com/category/this-category-includes-sql-interview-questions/
            http://www.complexsql.com/pl-sql-examples/.http://www.complexsql.com/unix-scripting-interview-questions/
            http://www.complexsql.com/etl-testing-interview-questions/
            http://www.complexsql.com/data-modeling-interview-questions-with-answers-for-professionals/

            Like this page on Facebook for More Updates :
            https://www.facebook.com/Complexsqlcom-1302739539812605/  

            Regards and thanks,
            Amit Shiravadekar

        1. Hi Amit,

          This is Ramesh I am searching for job in Unix production support,so can you please send me the below questions answers asap.

          1.If application down how to troubleshoot the issue?

          2.How to resolve the P1 issue?

          3.If you alone in the shift how to resolve the two P1 issues?

          Can you please send me the answers asap.

          1. Hi Amit, please share interview questions for application support both technical and behavioral at below mentioned email address

  1. Hi Amit,

    This is really helpful.. can u also send few more questions for l2/l3 for 3-5 year experienced. That would be really helpful..

  2. Hi Amit, Please send sql /unix production support interview questions and answers to my mail id and questions related to monitoring tools and ticketing tools Please.

  3. Hi Amit
    Thanks for the article it is quite useful.. Can you pls upload some Java Production Support interview questions too. and pls mail me the question and answers for Unix and SQL production support interviews at email: au2006del10@gmail.com.

  4. Please send me more application support interview questions my interview will on Monday for same position Nd I am fresher

  5. Awesome article thanks Amit … I am looking for more questions can you please mail me all the questions … Thanks so much

  6. Nice and Usefull question selection. Can you please add more questions related to tail, grep, head command of unix.

  7. Got a better idea from these .Could you please mail me this as well some more Q&A . and also send me some SQL Q&A related to production support.

  8. That’s a comprehensive list of important questions. Kindly share some advanced production support questions for 5 years experienced. Thanks.

  9. very good information Amit – Thanks for sharing.
    Can you please share more questions & answers in Java L2/L3 production support real time scenario based questions.

  10. It was a good article..Can you please share me more questions and answer for 3+ exp in application support?

  11. Hi Amit,
    Can you please provide me some troubleshooting scenarios (Issues & Solutions) that i can tell in interview, Troubleshooting related to Desktop, Web application issue.

  12. Hi Amit,

    This is of great help and thanks a lot for the details. Could you be please send me more SQL and UNIX questions for Application/Production support engineer

  13. Can you please share more questions & answers in sql and asp.net L1/L2 Application support real time scenario based questions.
    Troubleshooting related to OS, Desktop, Web application issue(Issues & Solutions).
    Ticketing Tools related .

  14. Hi Amit, Please send sql /.net production support interview questions and answers to my mail id and questions related to monitoring tools and ticketing tools Please.

  15. I need help on senior production support interview questions and answers for Unix SQL PLSQL

    Thank you Amit for your great work for helping candidates

  16. Hi Amit,

    Could you please help me with some SQL,UNIX and application support interview questions for experienced professionals.

    Thanks in advance.

  17. Hi Amit,
    I went through your post questions and it is really helpful.
    It would be great if you could share some more production support interview questions related to SQL and Unix.

  18. Hi Amit,

    Could you please answer these questions as well .

    1.how to troubleshoot application performance issues .

    2.How to check solution for query running for a long time than the usual time..

    Please send me the interview questions for app support , Unix and SQL as well for experienced professionals.
    Thanks,

  19. Hi Amit, many thanks for your valuable inputs in this post. Can you please send me some more production support related interview questions? I have an experience of about 3 years in L3.5 support. My email id is apurvaj1204@gmail.com

  20. Nice article..Can you please mail me questions for application/production support profile(sql and unix ) for experienced people?

  21. Hi sir,
    Can you send me more interview questions on SQL and linux Commands.
    asp.net L1/L2 Application support real time scenario based questions, Web application issue(Issues & Solutions).

  22. Hi amit S,

    i’m following your articles, Please help me with if have any Oracle PLSQL , unix interview quesions for experienced professionals. send me (pvinod0770@gmail.com)

    Thanks in advance.

    1. Nice,
      Can you please share me some more application support interview questions and answers related sql and unix for 3-5 years experienced.

  23. Hi Amit,

    Kindly share the application support / production support interview questions & answers including SQL/ FIX/ Scripting (Perl & Python) on my email police.raj@gmail.com . I have an interview on this Saturday, any help is much appreciated.

  24. Hi Amit,

    Can you please share interview questions for application support role for sql and unix commands.

    Mail id :saikumarstkm@gmail.com

  25. Hi ,

    Can you share some questions and answers of issues which are faced in production support environment apart from Unix , SQL .?

  26. Hi Amit Sir,
    Such a great work and very helpful and valuable guidance.

    Could you please help me with some SQL,UNIX and application support interview questions(L1 & L2) for experienced professionals.
    My email id :- pankajkumar1605@gmail.com

    Thanks in advance.

  27. Hi Amit Sir,
    I have an interview day after tomorrow. I have 1.5 yrs of experience(Legacy support project- JAVA, mybatis, XLA , Struts framework and Sybase based project). kindly provide me with the kind of interview questions that may be asked. My Email Id: krishna99zx@gmail.com
    Thanks in Advance,
    Krishna.

  28. Hi Amit will you please share some good production support interview questions.
    Your above article very help full for me.
    Thanks

    1. Hello Amit,
      Thanks for sharing the article,it is very useful. Can you please share additional interview questions related to application support?
      Thanks in advance.

  29. Hi Amit,
    Could you please mail me with more Unix and Oracle Production Support Engineer interview questions and answers.
    Thanks in advance

  30. Hi Amit,
    Your article is so helpful…. actually I’m looking for L2 Production support interview questions based on “BANKING” Domain and Technology –> ORACLE, SQL, UNIX could you plz share me the questions based on my requirements.

  31. Hi Amit,

    Your article is very helpful and interactive. I’m looking for scenario-based L2 Production support interview questions based on “BANKING” Domain. Technology:- ORACLE, SQL, UNIX could you plz share me the questions.

    Many Thanks

  32. Hello Amit,
    Thanks for sharing the article,it is very useful. Can you please share additional interview questions related to application support?
    Thanks in advance.

  33. Hi Amit,

    You have a great patience in replying each and everyone .
    It would be highly appreciable if you kindly send those all questions related to L1,L2,L3 questions for Production Support.

    Thanks in Advance!

    Regards,
    Subham Siddharth Maharshi

      1. Excellent article. It would be highly appreciable if you kindly send those all questions related to L1,L2,L3 questions for Production Support.

  34. Hi Amit, thanks for your valuable inputs in this post.
    Can you please send me some more SQL production support related interview questions? I have an experience of about 3 years in L2 support. My email id is shivani.vy592@gmail.com

  35. Hi,

    Can you please help me with L2/L1 questions on sql, unix?
    For a developer, how working on support would be different?

  36. Hii Amit, your interview questions are very much helpful in interview point of view.Could you please share some production support related common issues and answer in banking domain.
    And also looking for scenario-based L2 Production support interview questions based on “BANKING” Domain. Technology:- ORACLE, SQL, UNIX could you plz share me the questions.

  37. THANKS SIR….YOU ARE DOING A GREAT JOB SIR… KINDLY SHARE SOME PRODUCTION SUPPORT JOB INTERVIEW QUESTIONS…….

  38. nice article can you mail me specific interview question related SQL & queries, Unix and shell scripting and application issues?

  39. HI..i really liked your questions.
    Can you please share me some more questions related to L2 support in banking domain . Thanks in advance.

  40. Hi Amit ,

    Your question are really help full .

    Could you please share L2 level support question for SQL and Unix releated to banking domain.

    It will be a great help .
    Thanks in advance !

  41. Hi Amit sir …
    Really helpful..please share some Production support interview questions with me
    mail id:-ravigcp7@gmail.com

  42. Muzhe bhi eh batao ki

    1 Application support post ka company me work Kya hota hai aur

    2 muzhe Application support questions answers chahiye

    1. Sure Prashant…

      Application support companies working on different issues and problems happened on application production enviroment.

      sent you questions

  43. Hi Amit,

    Your article is very helpful and life saving. Also it will be so kind of you to provide scenario based L2 L3 Production support interview questions on “BANKING” Domain.
    Technology:- Flexcube, PLSQL, SQL, UNIX
    mailto: jagan2678@gmail.com

    A Thousand Thanks…

  44. Hi sir. will you please send me some interview questions on Application Support with relevant to Technical also to my mail id:arungopavaram@gmail.com, am having interview on January. Please suggest me. Thanks.

  45. Hi Amit,
    Your article is so helpful…. actually I’m looking for L2 Production support interview questions based on “BANKING” Domain and Technology –> ORACLE, SQL, UNIX could you plz share me the questions based on my requirements

  46. I am looking for job change and I need some depth interview questions and answers for production support role can you please help me .

  47. Hi Amit,
    Your article is so helpful thanks for your article …. actually I’m looking for L2 Production support interview questions based on “BANKING” Domain and Technology –> ORACLE, SQL, UNIX could you plz share me the questions based on my requirements

  48. Hello Amit,
    Good interview questions and answers I am looking for job in production support and my domain is banking. Can you please provide me interview questions on banking domain for 3 years experience.

  49. Hi Amit,
    Your article is very short and crispy while reading, actually I’m looking for L2 & L3 Production support interview questions and answers in ORACLE, SQL, UNIX could you please share me the docs based on my requirements

    Email id: vijayvicky8788@gmail.com

  50. Very apt article for the subject. First time attending a support interview. Can you please send me more interview questions?

  51. Hello Amit, It was a nice article and really helpful. Can you pl share the more important questions on Unix/Sql production support.
    Thanks.

  52. Could you please share the interview questions related to production support & L2 Suoopert to me “devsinghh16@gmal.com” much appreciated

  53. Hello Amit,
    Really Appreciate your efforts. Good Article.
    I am trying to learn Application support. But i didn’t find any tutorials online. Can you please suggest me some websites or training institutes where i can learn this course. Please send me if you have documents to learn about this course.

  54. Hi amit,
    Can you please send me application support engineer and technical/production support engineer interview questions to my email: nagushri1994@gmail.com . Highly appreciate your work.

    Thank you so much for your time.

  55. Really nice article.
    Can you please send me Product support real time scenarios and their troubleshooting? I will really appreciate if you can also send to some interview questions and answers. Thanks in advance.

  56. Hi Amit,
    I am preparing for Appliaction support analyst post, and i came through this link of yours great stuff, can you please provide more questions in the email i provide to you? Please and thank you.

  57. Please can you help on below question with answer include STAR example

    What is the biggest challenge you come across as IT support analyst role and how did you solve the problem ?

    How did you manage the urgent issue when customer request and how did you mange it with time to over the situation to solve the problem ?

    How did you manage the difficult customer request and what action took to solve the issue ?

  58. Hi
    This Is upender
    I want Interview equations and answers for Dot net application support engineer as well as IIS (internet information services)
    and by using sql sever trouble shooting commands for support engineer

Leave a Reply

Your email address will not be published. Required fields are marked *