Oracle Associate Consultant Interview Questions and Answers

Q1. Details about project and internship
Add your answer
Q2. Sql questions and oops
Add your answer

Very basic programming

Very easy and basic maths, reasoning questions

Q1. Explain the four pillars of OOPS, their significance and how you leveraged them in your projects?
Ans. 
The four pillars of OOPS are encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in a class.

• Inheritance: Allowing a new class to inherit properties and behavior from an existing class. Example: Creating a subclass that inherits from a superclass.

• Polymorphism: The ability to pre...read more
Answered by AI
Add your answer

Q1. This was HR plus technical man=inly focusing on extra curricular activities but still domain related
Add your answer

4 levels. English comprehension, aptitude, psychometry and finance

Group of 6 in each GD

Case study solving and presentation

Q1. Random topics one can use
Add your answer

Q1. General questions
Add your answer

Q1. 1. Write a program to remove duplicate elements from String and mention the count of duplication.
View 3 more answers
Q2. 2. Write a program to capitalise all the first letter of a word in a sentence.
View 2 more answers
Q3. 3. How map works internally in Java
Add your answer
Q4. 4. When to use list and when to use linked list.
Add your answer
Q5. 5. Difference between primitives and wrapper class in Java.
Ans. 
Primitives are basic data types in Java while wrapper classes are objects that wrap around primitives.
• Primitives are faster and take less memory than wrapper classes.

• Wrapper classes provide additional functionality like conversion to and from strings.

• Primitives are passed by value while wrapper classes are passed by reference.

• Examples of primitives include int, boolean, and double while examples of wrapper classes incl...read more
Answered by AI
Add your answer
Q6. 6. Explain JVM architecture.
Add your answer
Q7. 7. Why String is immutable
Ans. 
String is immutable because it cannot be changed once created.
• Immutable objects are safer to use in multi-threaded environments.

• String pool in Java is possible because of immutability.

• StringBuffer and StringBuilder are mutable alternatives to String.
Answered by AI
Add your answer
Q8. 8. Different Java 8 features.
Ans. 
Java 8 introduced several new features including lambda expressions, streams, and default methods.
• Lambda expressions allow for functional programming and simplify code.

• Streams provide a way to process collections of data in a functional way.

• Default methods allow for adding new methods to interfaces without breaking existing implementations.

• Other features include the Optional class, Date and Time API, and Nashorn JavaSc...read more
Answered by AI
Add your answer
Q9. 9. Types of functional interface.
Ans. 
Functional interfaces are interfaces with only one abstract method. There are four types of functional interfaces.
• Consumer: accepts a single argument and returns no result. Example: Consumer

• Supplier: takes no argument and returns a result. Example: Supplier

• Predicate: takes a single argument and returns a boolean. Example: Predicate

• Function: takes a single argument and returns a result. Example: Functionread more
Answered by AI
Add your answer
Q10. 10. Write a program to separate even and odd numbers using Java 8.
Ans. 
Program to separate even and odd numbers using Java 8.
• Use Java 8 Stream API to filter even and odd numbers

• Create two separate lists for even and odd numbers

• Use lambda expressions to filter the numbers

• Example: List evenNumbers = numbers.stream().filter(n -> n % 2 == 0).collect(Collectors.toList());

• Example: List oddNumbers = numbers.stream().filter(n -> n % 2 != 0).collect(Collectors.toList());
Answered by AI
View 1 more answer
Q11. 11. Different types of spring boot annotations.
Ans. 
Spring Boot annotations are used to simplify the development process. Some common annotations are @SpringBootApplication, @RestController, @Autowired, @GetMapping, @PostMapping, @Service, @Repository, @Component, etc.
• The @SpringBootApplication annotation is used to mark the main class of the application.

• The @RestController annotation is used to mark a class as a RESTful controller.

• The @Autowired annotation is used to i...read more
Answered by AI
Add your answer
Q12. 12. Question related to inner queries in SQL.
Add your answer

Q1. 1. Difference between String and String Buffer.
Ans. 
String is immutable while StringBuffer is mutable.
• String objects are constant and cannot be changed once created.

• StringBuffer objects are mutable and can be modified.

• StringBuffer is thread-safe while String is not.

• StringBuffer has methods to append, insert, and delete while String does not.

• Example: String str = "hello"; StringBuffer sb = new StringBuffer("world");

• str.concat("world"); // returns a new string "helloworld...read more
Answered by AI
Add your answer
Q2. 2. Difference between String Buffer and String Builder
Add your answer
Q3. 3. How to remove sensitive information from serializable interface.
Ans. 
Sensitive information can be removed from serializable interface by implementing custom serialization.
• Create a custom serialization method that excludes sensitive information.

• Use the transient keyword to mark sensitive fields as non-serializable.

• Consider using encryption or hashing to protect sensitive data.

• Test serialization and deserialization to ensure sensitive information is not included.

• Examples: exclude password...read more
Answered by AI
Add your answer
Q4. 4. What is marker interface? Example of marker interface. Why it is used.
Add your answer
Q5. 5. Difference type of HTTP request in Spring Boot.
Ans. 
There are four types of HTTP requests in Spring Boot: GET, POST, PUT, and DELETE.
• GET: used to retrieve data from a server

• POST: used to submit data to a server

• PUT: used to update existing data on a server

• DELETE: used to delete data from a server

• These requests are handled by the @RequestMapping annotation in Spring Boot
Answered by AI
Add your answer
Q6. 6. Spring MVC architecture
Add your answer
Q7. 7. Uses of Factory Design Pattern
Ans. 
Factory Design Pattern is used to create objects without exposing the creation logic to the client.
• It provides a way to delegate the object creation to a factory class.

• It helps in achieving loose coupling between classes.

• It is useful when we have a super class with multiple sub-classes and based on input, we need to return one of the sub-class.

• Examples include: java.util.Calendar, java.text.NumberFormat, java.nio.chars...read more
Answered by AI
Add your answer
Q8. 8. Different type of HTTP response code.
Ans. 
HTTP response codes indicate the status of a web request. There are 5 categories of codes.
• 1xx - Informational

• 2xx - Success

• 3xx - Redirection

• 4xx - Client Error

• 5xx - Server Error
Answered by AI
Add your answer
Q9. 9. Difference between @Service and @Component.
Ans. 
Difference between @Service and @Component
• Both are used for component scanning in Spring

• @Service is used for service layer classes

• @Component is used for general purpose beans

• Service layer classes contain business logic

• Examples of @Service: UserService, ProductService

• Examples of @Component: DAO, Utility classes
Answered by AI
Add your answer
Q10. 10. Remove the duplicate elements in an array.
Add your answer
Q11. 11. SQL queries related to joins.
Add your answer

Q1. 1. What are the different layers of OSI model.
Ans. 
The OSI model has 7 layers that define how data is transmitted over a network.
• Layer 1: Physical layer - deals with the physical aspects of transmitting data

• Layer 2: Data link layer - responsible for error-free transfer of data between nodes

• Layer 3: Network layer - handles routing of data between different networks

• Layer 4: Transport layer - ensures reliable delivery of data between applications

• Layer 5: Session layer - e...read more
Answered by AI
Add your answer
Q2. 2. What are different layers of TCP/IP model.
Ans. 
TCP/IP model has four layers: Application, Transport, Internet, and Network Access.
• Application layer handles high-level protocols like HTTP, FTP, SMTP, etc.

• Transport layer provides end-to-end communication between hosts using TCP or UDP protocols.

• Internet layer handles the routing of data packets between networks using IP protocol.

• Network Access layer deals with the physical transmission of data over the network.

• Exampl...read more
Answered by AI
Add your answer
Q3. 3. Difference between TCP, UDP and TLS protocol.
Add your answer
Q4. 4. Explain SIP signalling.
Ans. 
SIP signalling is a protocol used for initiating, modifying, and terminating real-time sessions that involve video, voice, messaging, and other communications applications.
• SIP stands for Session Initiation Protocol.

• It is used to establish, modify, and terminate multimedia sessions.

• SIP signalling is used in VoIP (Voice over Internet Protocol) and other real-time communication applications.

• It uses a request-response mode...read more
Answered by AI
Add your answer
Q5. 5. Explain the process of data communication using TCP/IP model.
Ans. 
TCP/IP model is a protocol used for data communication. It consists of four layers: application, transport, internet, and network access.
• Data is sent from the application layer to the transport layer where it is divided into segments.

• The internet layer adds IP addresses to the segments and sends them to the network access layer.

• The network access layer adds physical addresses and sends the data over the network.

• The pro...read more
Answered by AI
Add your answer
Q6. 6. Consider an array of String, remove those string from array whose length is less than 3.
View 1 more answer

2 QUESTIONS, 1 OF API

Q1. Sql based 100%. ALso will ask your projects and experience.
Add your answer