Production Support Interview Questions and Answers

I have used various Linux commands on a daily basis.

• ls - to list files and directories

• cd - to change directories

• grep - to search for specific text in files

• tail - to view the end of a file

• ps - to view running processes

• kill - to terminate a process

• chmod - to change file permissions

• ssh - to connect to remote servers

• scp - to transfer files between servers

• tar - to archive and compress files

SQL functions are used to perform calculations on data and return the result.

• Aggregate functions like SUM, AVG, COUNT, MAX, MIN

• String functions like CONCAT, SUBSTRING, LENGTH

• Date functions like DATEADD, DATEDIFF, GETDATE

• Mathematical functions like ABS, CEILING, FLOOR

• Conversion functions like CAST, CONVERT

• Logical functions like CASE, IIF

Platform independence refers to the ability of software or systems to run on different platforms or operating systems.

• Platform independent software can be executed on multiple operating systems without any modifications.

• It allows users to switch between different platforms without affecting the functionality of the software.

• Platform independence is achieved through the use of programming languages, frameworks, or virtual machines that abstract the underlying hardware and oper...read more

Oops concept refers to Object-Oriented Programming concepts that help in organizing and structuring code.

• Encapsulation: Bundling data and methods together in a class.

• Inheritance: Creating new classes from existing classes.

• Polymorphism: Ability of an object to take on many forms.

• Abstraction: Hiding unnecessary details and exposing only essential features.

A class is a blueprint or template for creating objects in object-oriented programming.

• A class defines the properties and behaviors that an object will have.

• An object is an instance of a class.

• Classes and objects are fundamental concepts in object-oriented programming.

• Classes can have attributes (variables) and methods (functions).

• Objects can interact with each other by invoking methods on other objects.

Use SQL query with ORDER BY and LIMIT to find last 5 rows

• Use ORDER BY clause to sort the rows in descending order based on a column

• Use LIMIT 5 to retrieve only the last 5 rows