About sql, query optimisation, production support
Application Support Engineer Interview Questions
327 application support engineer interview questions shared by candidates
Q1. Basic Question related to ITIL - difference between Incident & Problem Management Q2. Questions related to sql - difference b/w delete & truncate ,clustered & non clustered indexing in sql ,difference b/w function & procedure ,what are triggers , diff b/w inner join & outer join Q3. Question related to java - diff b/w stack memory & heap memory, what is inheritance , what is interface , can we achieve multilevel inheritance in java Q4. Question related to linux - differ b/w find & grep , how to check that how many process are currently running & how to kill a specific process , how to execute a script in background
Tell me a challenging situation you faced?
In 2nd Round First Part - Critical thinking questions(3) including 2 riddles like 'A ping pong ball tangled in a narrow pipe of half meter long embedded on a concreate. how to get the ball out when a paddle, some chewing gum and water provided' / 'A man and his son were in an car accident. The man died on the way to the hospital, but the boy was rushed into surgery. The surgeon said "I can't operate, that's my son!" How is this possible?' Second Part - Customer centric questions (2 or 3) like 'when a client reported an incident with urgent and you couldn't still look in to it and the client tag you and asking for a update how would you respond ' Third Part - questions from C# code (if condition for an array with a return value function) like what would be the output for a given input , Would this code run if not how could you implement it to make it runnable (have to re-write the code) Fourth Part - SQL/ schema given , query (with a join clause) out put , construct a query joining three tables for a given criteria - use with group by and having clause, optional query to build for a advance scenario.
Are you comfortable working 40% of your time from a satellite office where the take-home pay will be $10000 less than the same pay at HQ?
Tell me one project that you are really proud of doing.
What is a stored procedure?
What do you know about the company?
About html, css and JavaScript
1. Tell me about your self. 2. Troubleshooting and how it's done. 3. Scenarios 4. Linux commands ls and chmod 5. Web services and Services provided by AWS 6. EC2, S3 and EBS 7. Sql queries 8. Java expections ( checked and unchecked exceptions)Null pointer exception 9. Ls command usage 10. PWD command details and results 11. AZ and Regions and count.
Viewing 241 - 250 interview questions