Denodo Technologies Interview Questions and Answers

It was a mcq + coding round with computer fundamentals and aptitude + easy-medium level dsa questions.

It was an offline aptitute test with 30 questions for 30 minutes.

Q1. Detect a loop in the linked list
Ans. 
Detect a loop in a linked list by using Floyd's Cycle Detection Algorithm
• Use two pointers, slow and fast, to traverse the linked list

• If there is a loop, the fast pointer will eventually meet the slow pointer

• Initialize slow and fast pointers at the head of the linked list

• Move slow pointer by one step and fast pointer by two steps in each iteration

• If the fast pointer reaches the end of the list or meets the slow pointer,
Answered by AI
Add your answer
Q2. Find the unique element in an array
Ans. 
Find the unique element in an array of strings
• Iterate through the array and use a hashmap to store the frequency of each element

• After iterating, check the hashmap for elements with frequency 1 to find the unique element
Answered by AI
Add your answer
Q3. Tell about your projects
Ans. 
I have worked on various projects including a web application for a local business and a mobile app for tracking daily habits.
• Developed a web application using HTML, CSS, and JavaScript for a local business to manage their inventory and sales.

• Created a mobile app using React Native to track daily habits and provide reminders for healthy routines.

• Collaborated with a team to implement new features and fix bugs in existin...read more
Answered by AI
Add your answer
Q4. Write a MySQL query for selecting the id of second highest salary from employee table
Ans. 
MySQL query to select the id of second highest salary from employee table
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to select the second row

• Use a subquery to avoid duplicates if multiple employees have the same salary
Answered by AI
Add your answer

Q1. SQL Questions - Constraints- how to optimize long SQL query without changing the output
Add your answer

Q1. Introduce Yourself
Add your answer
Q2. What is current designation
Add your answer

Q1. What is your design process.
Add your answer
Q2. How do you work with developer push-back?
Add your answer
Q3. How do you overcome personal bias in user research?
Add your answer

Make a autobiography app

Q1. Share your working experience
Add your answer
Q2. Why are you leaving current firm?
Add your answer
Q3. How do you percieve the design systems
Add your answer

It was Machine test, i had to make a project and connect it to Database and submit details in database table from form.

Q1. Technical verbal Interview, question were related to JavaScript, Json, JQuery, and how to perform click and other event on click, on change etc, and how to get text content entered in text box, mostly rel...read more
Add your answer
Q2. What is Collection Framework?
Ans. 
Collection Framework is a unified architecture for representing and manipulating collections of objects in Java.
• It provides interfaces (List, Set, Queue, etc.) and classes (ArrayList, HashSet, PriorityQueue, etc.) to store and manipulate groups of objects.

• Collections can be easily sorted, searched, and iterated using methods provided by the Collection Framework.

• Example: ArrayList is a class that implements the List int...read more
Answered by AI
Add your answer
Q3. What is RestApi?
Ans. 
RestApi is a set of rules and conventions for building and interacting with web services using HTTP methods.
• RestApi stands for Representational State Transfer Application Programming Interface.

• It allows communication between different software systems over the internet.

• RestApi uses standard HTTP methods like GET, POST, PUT, DELETE for data manipulation.

• JSON or XML formats are commonly used for data exchange in RestApi.

• ...read more
Answered by AI
Add your answer
Q4. How to add one ArrayList object to another, which method is used to achieve this. Ans:- By using addAll() Method

Ans. 

The addAll() method is used to add all elements of one ArrayList to another.

• Use the addAll() method to add all elements of one ArrayList to another

• Syntax: list1.addAll(list2);

• Example: ArrayList list1 = new ArrayList<>(); list1.addAll(Arrays.asList(1, 2, 3));

Add your answer