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.

 

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.

204 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.

          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

  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

Leave a Reply

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