10+ Associate Professional Interview Questions and Answers for Freshers

Reverse a given string containing alphabets, numbers, and special characters.

• Iterate through the string from the end to the beginning and append each character to a new string.

• Use built-in functions like reverse() or slicing to reverse the string.

• Handle special characters and numbers while reversing the string.

• Ensure to consider the constraints on the length of the string and the number of test cases.

Given an array of digits, swap two elements to get the maximum number possible.

• Iterate through the array to find the maximum digit.

• Swap the maximum digit with the leftmost occurrence of that digit.

• If the maximum digit is already at the leftmost position, swap it with the second largest digit.

An inner join combines rows from two tables based on a related column between them.

• An inner join returns rows when there is at least one match in both tables based on the join condition.

• It is commonly used to retrieve data from multiple tables that have a relationship.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Abstraction is hiding implementation details while Interface is a contract for implementing classes.

• Abstraction is achieved through abstract classes and methods.

• Interface defines a set of methods that a class must implement.

• Abstraction focuses on hiding complexity and providing a simpler interface.

• Interface focuses on defining a standard for communication between classes.

• Abstraction is a way to achieve modularity and maintainability.

• Interface is a way to achieve polymorphism ...read more

A table is a physical storage structure while a view is a virtual table created from a query.

• A table stores data in a structured manner while a view is a virtual table created from a query.

• A table can have indexes and constraints while a view cannot.

• A table can be updated, inserted or deleted while a view cannot be directly modified.

• A view can be used to simplify complex queries or restrict access to certain columns of a table.

• Example: A table named 'employees' can have a vie...read more

The OSI model has 7 layers that define how data is transmitted over a network.

• The layers are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

• Each layer has a specific function and communicates with the layers above and below it.

• For example, the Physical layer deals with the physical transmission of data, while the Application layer deals with user interfaces and applications.

• The OSI model is a conceptual model and is used to help understand ho...read more

DXC is a global IT services company that provides end-to-end solutions for clients in various industries.

• DXC was formed in 2017 through the merger of CSC and the Enterprise Services business of Hewlett Packard Enterprise.

• They offer services in areas such as cloud computing, cybersecurity, analytics, and digital transformation.

• DXC has clients in industries such as healthcare, finance, manufacturing, and government.

• They have a global workforce of over 130,000 employees.

• DXC is h...read more

Polymorphism is the ability of an object to take on many forms.

• It allows objects of different classes to be treated as if they were objects of the same class.

• It is achieved through method overriding and method overloading.

• Example: A shape class can have different subclasses like circle, square, and triangle, each with their own implementation of the draw method.

• Example: A method can take in different types of objects as parameters, and the appropriate method will be called ba...read more

SQL Error 911 is a database connection error that occurs when the maximum number of concurrent connections has been reached.

• Occurs when the maximum number of concurrent connections has been reached

• Can be resolved by increasing the maximum number of connections allowed

• May also be caused by insufficient memory or disk space

• Commonly seen in IBM DB2 databases

Four pillars of OOPs are Abstraction, Encapsulation, Inheritance, and Polymorphism.

• Abstraction: Hiding implementation details and showing only necessary information.

• Encapsulation: Binding data and functions together and restricting access to data.

• Inheritance: Creating new classes from existing ones, inheriting properties and methods.

• Polymorphism: Ability of objects to take on multiple forms or behaviors.