20+ Blubirch Interview Questions and Answers

To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

• Use the ORDER BY clause to sort the table in descending order.

• Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

• Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

Infosys is a leading IT company with a strong focus on innovation and customer satisfaction.

• Infosys has a strong reputation for delivering high-quality software solutions

• The company places a strong emphasis on time management and project planning

• Infosys has expertise in a wide range of technologies, including polymorphism, SQL, and OOPs

• The company offers excellent career growth opportunities and a supportive work environment

Recursion is a process of calling a function within itself.

• Recursion is useful for solving problems that can be broken down into smaller sub-problems.

• It involves a base case and a recursive case.

• Examples include factorial, Fibonacci sequence, and binary search.

• Recursion can be memory-intensive and may cause stack overflow errors.

• Tail recursion optimization can be used to optimize recursive functions.

Interfaces in Java define a contract for classes to implement certain methods and provide a way to achieve abstraction.

• Interfaces are declared using the 'interface' keyword in Java.

• All methods in an interface are abstract by default and do not have a method body.

• Classes can implement interfaces using the 'implements' keyword.

• Interfaces can be used to achieve multiple inheritance in Java.

• Example: public interface Shape { double calculateArea(); }

There is no OOP language in C, but C++ is an OOP language that is derived from C.

• C++ is an extension of C that supports OOP concepts like encapsulation, inheritance, and polymorphism.

• C++ allows the creation of classes and objects, which are the building blocks of OOP.

• C++ also supports features like templates, exceptions, and namespaces that make it a powerful language for software development.

Intersection point of 2 linked lists can be found by comparing the lengths and adjusting the starting points.

• Traverse both lists to find their lengths

• Adjust the starting point of the longer list to match the length of the shorter list

• Traverse both lists in parallel until the intersection point is found

I work on a variety of technologies including Java, Python, SQL, and AWS.

• Java

• Python

• SQL

• AWS

To rotate a matrix by 90 degrees, transpose the matrix and then reverse each row.

• Transpose the matrix by swapping matrix[i][j] with matrix[j][i]

• Reverse each row of the transposed matrix

Interface in C# is a reference type that defines a contract for classes to implement certain methods and properties.

• Interfaces cannot have implementation, only method and property signatures

• Classes can implement multiple interfaces

• Interfaces are used for achieving abstraction and multiple inheritance in C#

OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.

• OOPS is a way of organizing and designing code around objects

• Objects have properties (attributes) and methods (functions)

• Encapsulation, inheritance, and polymorphism are key concepts in OOPS

• Examples of OOPS languages include Java, C++, and Python

Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform.

• Authentication confirms the identity of a user through credentials like passwords or biometrics

• Authorization determines the permissions and access levels a user has within a system

• Examples include logging in with a username and password (authentication) and being able to view/edit specific files based on user roles (authorization)

I have used tools like Burp Suite, Nmap, Metasploit, Wireshark, and Nessus for VAPT.

• Burp Suite

• Nmap

• Metasploit

• Wireshark

• Nessus

Addition of two numbers is a basic arithmetic operation that involves combining two numbers to get a total sum.

• Use the + operator to add two numbers in most programming languages.

• Ensure the numbers are in the correct format (integers, floats, etc.) before adding.

• Consider handling edge cases like overflow or underflow when adding large numbers.

Final keyword in Java is used to restrict the user from changing the value of a variable, making it a constant.

• Final keyword can be applied to variables, methods, and classes

• Final variables must be initialized and cannot be reassigned

• Final methods cannot be overridden in subclasses

• Final classes cannot be subclassed

Static keyword in Java is used to create class-level variables and methods that can be accessed without creating an instance of the class.

• Static variables are shared among all instances of a class

• Static methods can be called without creating an object of the class

• Static blocks are used to initialize static variables

Common design patterns are reusable solutions to common problems in software design.

• Creational patterns: Singleton, Factory, Builder

• Structural patterns: Adapter, Decorator, Facade

• Behavioral patterns: Observer, Strategy, Template Method

Rotate array by k positions to the right

• Create a temporary array to store elements that will be rotated

• Shift elements to the right by k positions

• Copy elements from temporary array back to original array

Merge sort is a divide and conquer algorithm that recursively divides the array into halves and merges them in sorted order.

• Divide the array into two halves

• Recursively merge sort each half

• Merge the sorted halves back together

OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.

• OOPs focuses on creating objects that interact with each other to solve a problem

• Key concepts include encapsulation, inheritance, polymorphism, and abstraction

• Encapsulation: bundling data and methods that operate on the data into a single unit

• Inheritance: allows a class to inherit properties and behavior from another class

• Polymorphism: ability for obje...read more