FIS Production Support Analyst Interview Questions and Answers

24/7 production environment

Q1. What is the difference between PL SQL AND SQL?
Ans. 
PL/SQL is a procedural language extension to SQL used for writing complex queries and programs.
• SQL is used for querying and manipulating data in a database

• PL/SQL is used for writing complex queries and programs

• PL/SQL is a procedural language that extends SQL with programming constructs like loops and conditional statements

• PL/SQL is used to create stored procedures, functions, and triggers in Oracle databases
Answered by AI
Add your answer
Q2. About programming
Add your answer
Q3. Write a query using below data to find out last string from emp table?
Ans. 
Query to find last string from emp table
• Use the ORDER BY clause with DESC keyword to sort the table in descending order

• Use the LIMIT keyword to limit the result to 1 row

• Assuming the last string refers to the last row in the table
Answered by AI
Add your answer
Q4. Write s query to find maximum salary from EMP?
Ans. 
Query to find maximum salary from EMP
• Use the MAX() function to find the maximum salary

• Specify the column name for salary in the SELECT statement

• Specify the table name and column name for salary in the FROM clause
Answered by AI
Add your answer

Hydraulic systems and hydraulic machines.

Q1. What is the difference between BS4 and BS6 emissions standards?
Ans. 
BS6 emissions standards are more stringent than BS4, with lower limits on emissions of pollutants like nitrogen oxides and particulate matter.
• BS6 standards have stricter limits on emissions of pollutants like nitrogen oxides (NOx) and particulate matter (PM) compared to BS4.

• BS6 compliant vehicles are required to have advanced emission control technologies like selective catalytic reduction (SCR) and diesel particulate ...read more
Answered by AI
Add your answer
Q2. What is the difference between an electric motor and an electric generator?
Ans. 
An electric motor converts electrical energy into mechanical energy to produce motion, while an electric generator converts mechanical energy into electrical energy.
• Electric motor converts electrical energy into mechanical energy

• Electric generator converts mechanical energy into electrical energy

• Electric motor is used in appliances like fans, washing machines

• Electric generator is used in power plants to generate electr
Answered by AI
Add your answer
Q3. Difference between four stroke and two stroke engine
Ans. 
Four stroke engines have separate intake, compression, power, and exhaust strokes, while two stroke engines combine intake and compression in one stroke and power and exhaust in another.
• Four stroke engines have a dedicated stroke for each of the four processes: intake, compression, power, and exhaust

• Two stroke engines combine intake and compression in one stroke and power and exhaust in another

• Four stroke engines are m...read more
Answered by AI
Add your answer

Q1. What is a project that you have worked on before?
Ans. 
Developed a web-based inventory management system for a retail company
• Utilized Java for backend development

• Implemented responsive design using HTML, CSS, and JavaScript

• Integrated barcode scanning functionality for efficient inventory tracking
Answered by AI
Add your answer
Q2. What was your role within the team?
Ans. 
I was responsible for providing technical support to end users and troubleshooting application issues within the team.
• Providing technical support to end users

• Troubleshooting application issues

• Collaborating with team members to resolve issues

• Documenting solutions and best practices
Answered by AI
Add your answer
Q3. What SQL-based queries were asked during your interview? like self join , average
Add your answer

Q1. Please ask technical level question?
Add your answer
Q2. Application support engineer question?
Add your answer

Q1. Self introduction
Add your answer
Q2. Work experience
Add your answer
Q3. Which department are u working
Add your answer
Q4. Timings and salary
Add your answer

Q1. Name and experience and quality and checking etc
Add your answer
Q2. How can handle ur problem and team work
Add your answer
Q3. Times and salary
Add your answer

Q1. What is your current role in organization
Add your answer
Q2. What is your salary expeactation
Add your answer

Q1. Exception handler
Add your answer
Q2. Threads in java
Ans. 
Threads in Java allow for concurrent execution of multiple tasks within a single program.
• Threads are instances of the java.lang.Thread class.

• They allow for parallel execution of code segments.

• Threads can be created by extending the Thread class or implementing the Runnable interface.

• Example: Thread t1 = new Thread(new MyRunnable()); t1.start();
Answered by AI
Add your answer