Associate Professional

10+ Associate Professional Interview Questions and Answers for Freshers

Updated 19 Mar 2022

Popular Companies

Q1. Reverse the string

You are given a string 'STR'. The string contains [a-z] [A-Z] [0-9] [special characters]. You have to find the reverse of the string.

For example:

 If the given string is: STR = "abcde". You h...read more

Q2. Maximum Number

You are given an array of N elements. This array represents the digits of a number. In an operation, you can swap the value at any two indices. Your task is to find the maximum number by using ope...read more

Q3. DBMS Questions

Write a query for inner join and explain it and also take any tables to perfom inner join on it and why do we use it.

Q4. Check why the program is giving wrong output

Are these interview questions helpful?

Q5. What is the difference between Abstraction and Interface?

Ans.

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

Q6. What is perform? Mention its different types.

Ans.

Perform refers to carrying out a task or activity. Its types include job performance, academic performance, and athletic performance.

Perform refers to the execution of a task or activity.
Job performance refers to how well an employee performs their job duties.
Academic performance refers to a student's success in their studies.
Athletic performance refers to an athlete's ability to perform in their sport.
Other types of performance include musical performance, theatrical perform...read more

Share interview questions and help millions of jobseekers 🌟

Q7. What is the difference between a table and a view?

Ans.

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

Q8. What are the layers of the OSI model?

Ans.

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

View 1 answer

Associate Professional Jobs

Associate Professional, IT Channel Sales • 0-2 years

Ingram Micro (I) Pvt Ltd

•

3.9

Thiruvananthapuram

View all Associate Professional jobs

Q9. What do you know about DXC?

Ans.

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

Q10. Technical Question

Python and Java Programing language Which will be more powerful in future

Q11. What is Polymorphism?

Ans.

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

Frequently asked in

Q12. What is SQL Error 911?

Ans.

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

Q13. Handle the Exception that is occurring.

Q14. What are four pillars of oops

Ans.

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.

View 1 answer

Q15. What is data encapsulation

Ans.

Data encapsulation is the process of hiding implementation details and exposing only necessary information.

It is a fundamental concept in object-oriented programming.
It helps in achieving data abstraction and information hiding.
It allows for better control over data and prevents unauthorized access.
Example: A class in Java that has private variables and public methods to access them.
Example: A capsule that contains medicine and only allows access through a small opening.

View 1 answer