Enquero Oracle Technical Consultant Interview Questions and Answers

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions on CSS and Jquery mainly.

Q1. What is the CSS box model?
Ans. 
The CSS box model is a design and layout concept that defines the structure and sizing of elements on a web page.
• It consists of content, padding, border, and margin around an element.

• Content area is where text and images are displayed.

• Padding is the space between the content and the border.

• Border is the line that goes around the padding and content.

• Margin is the space outside the border.

• Example: div { width: 200px; pad...read more
Answered by AI
Add your answer
Q2. How do you select all div elements using jQuery?
Ans. 
To select all div elements using jQuery, use the selector $('div').
• Use the jQuery selector $('div') to select all div elements on the page.

• You can also use the find() method to select div elements within a specific parent element.

• To perform actions on the selected div elements, use jQuery methods like css(), text(), or addClass().
Answered by AI
Add your answer
Q3. How can you change the background color of all items in JavaScript?
Ans. 
You can change the background color of all items in JavaScript by selecting all elements and setting their background color property.
• Select all elements using document.querySelectorAll()

• Loop through the selected elements and set their style.backgroundColor property

• Example: document.querySelectorAll('.item').forEach(item => item.style.backgroundColor = 'blue');
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions on Java mainly.

Q1. What are the uses of the final keyword in Java?
Ans. 
The final keyword in Java is used to define constants, prevent method overriding, and make a class immutable.
• Final variables cannot be reassigned once initialized

• Final methods cannot be overridden in subclasses

• Final classes cannot be extended
Answered by AI
Add your answer
Q2. What is the Front Controller in Spring MVC?
Ans. 
Front Controller in Spring MVC is a design pattern that handles all requests and acts as a central point of control.
• Front Controller is a servlet in Spring MVC that receives all requests and then dispatches them to the appropriate handlers.

• It helps in centralizing request handling logic, improving code organization and reducing duplication.

• Front Controller can perform tasks like authentication, logging, exception handl...read more
Answered by AI
Add your answer
Q3. What is the annotation for request mapping in Java?
Ans. 
The annotation for request mapping in Java is @RequestMapping.
• @RequestMapping annotation is used to map web requests to specific handler methods in Spring MVC.

• It can be applied at class level or method level to specify the URL path that the controller will handle.

• You can also specify HTTP request methods, headers, parameters, and more using @RequestMapping.
Answered by AI
Add your answer
Q4. What is the annotation used for a controller in Java?
Ans. 
The annotation used for a controller in Java is @RestController.
• Used to define a class as a controller in Spring MVC

• Automatically serializes return objects into JSON/XML responses

• Equivalent to @Controller + @ResponseBody annotations
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a typical HR round.

Q1. Don’t remember the questions
Add your answer

Q1. Don’t remember the questions
Add your answer

Q1. Don’t remember the questions
Add your answer

Q1. Don’t remember the questions
Add your answer

Online coding test with Sql and python questions

Q1. Details about project and experience
Add your answer
Q2. Pyspark and databricks questions
Add your answer
Q3. What is Spark context
Ans. 
Spark context is the main entry point for Spark functionality and represents the connection to a Spark cluster.
• Main entry point for Spark functionality

• Represents connection to a Spark cluster

• Used to create RDDs, broadcast variables, and accumulators
Answered by AI
Add your answer
Q4. What is inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
• Allows for code reusability by creating a new class based on an existing class

• Derived class inherits properties and behaviors of the base class

• Supports the concept of polymorphism and encapsulation

• Example: Class 'Car' can inherit from class 'Vehicle' and inherit its attributes like 'color' and met
Answered by AI
Add your answer
Q5. What is sparkconfig
Ans. 
SparkConfig is a configuration object used in Apache Spark to set various parameters for Spark applications.
• SparkConfig is used to set properties like application name, master URL, and other Spark settings.

• It is typically created using SparkConf class in Spark applications.

• Example: val sparkConf = new SparkConf().setAppName("MyApp").setMaster("local")
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

The round was scheduled in afternoon time.
HackerEarth test link was shared beforehand
All the instructions were provided in the welcome page of test link.
It was proctored test

Q1. 
Palindrome String Validation
Determine if a given string 'S' is a palindrome, considering only alphanumeric characters and ignoring spaces and symbols.
Note:
The string 'S' should be evaluated in a case...read more
Ans. 
Validate if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.
• Remove special characters and spaces from the input string

• Convert the string to lowercase

• Check if the modified string is equal to its reverse to determine if it's a palindrome
Answered by AI
Add your answer
Q2. 
Find First Repeated Character in a String
Given a string 'STR' composed of lowercase English letters, identify the character that repeats first in terms of its initial occurrence.
Example:
Input:
STR =...read more
Ans. 
Find the first repeated character in a given string of lowercase English letters.
• Iterate through the string and keep track of characters seen so far

• Return the first character that repeats, if none, return '%'

• Use a hash set or array to store characters seen
Answered by AI
Add your answer

Round duration - 35 minutes
Round difficulty - Medium

It was in afternoon 3pm.
Interview platform was Microsoft teams.
Interview link was shared a day before.
Interviewer was professional.

Q1. 
Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
...read more
Ans. 
Given an array and a target sum, find pairs of elements that add up to the target sum.
• Iterate through the array and for each element, check if the complement (target sum - current element) is present in a hash set.

• If the complement is found, add the pair to the result list.

• Sort the pairs based on the first element, and if the first elements are equal, sort based on the second element.
Answered by AI
Add your answer

Round duration - 25 Minutes
Round difficulty - Medium

It was held around 4pm.
Scheduled on MS teams.
Interview link shared one day before.
The interviewer was pretty chill and made me comfortable.

Q1. How would you handle a situation where a company approaches you during a pandemic and states that demand is high but supply is low?
Add your answer
Q2. Why do you want to join this company?
Add your answer

In Mu Sigma APT round is divided into 3 sections Quant, Logical and verbal