Accenture
300+ Diligente Technologies Interview Questions and Answers
Q1. Triplets with Given Sum Problem
Given an array or list ARR
consisting of N
integers, your task is to identify all distinct triplets within the array that sum up to a specified number K
.
Explanation:
A triplet i...read more
The task is to find all distinct triplets in an array that sum up to a specified number.
Iterate through the array and use nested loops to find all possible triplets.
Keep track of the triplets that sum up to the target number.
Handle cases where no triplet exists for a given target sum.
Q2. Kth Smallest and Largest Element Problem Statement
You are provided with an array 'Arr' containing 'N' distinct integers and a positive integer 'K'. Your task is to find the Kth smallest and Kth largest element...read more
Find the Kth smallest and largest elements in an array.
Sort the array and return the Kth element for smallest and (N-K+1)th element for largest.
Ensure K is within the array size to avoid out of bounds error.
Handle multiple test cases efficiently by iterating through each case.
Q3. Chocolate Distribution Problem
You are given an array/list CHOCOLATES
of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M' stude...read more
Distribute chocolates among students to minimize the difference between the largest and smallest number of chocolates.
Sort the array of chocolates packets.
Use sliding window technique to find the minimum difference between the largest and smallest packets distributed to students.
Return the minimum difference as the output.
Q4. Balanced Parentheses Combinations
Given an integer N
representing the number of pairs of parentheses, find all the possible combinations of balanced parentheses using the given number of pairs.
Explanation:
Con...read more
Generate all possible combinations of balanced parentheses given the number of pairs.
Use backtracking to generate all valid combinations of balanced parentheses.
Keep track of the number of open and close parentheses used in each combination.
Recursively build the combinations by adding open parentheses if there are remaining, and then adding close parentheses if the number of open parentheses is greater than the number of close parentheses.
Example: For N = 2, valid combination...read more
Q5. Armstrong Number Problem Statement
You are provided an integer 'NUM'. Determine if 'NUM' is an Armstrong number.
Explanation:
An integer 'NUM' with 'k' digits is an Armstrong number if the sum of its digits, ea...read more
An Armstrong number is a number that is equal to the sum of its own digits raised to the power of the number of digits.
Iterate through each digit of the number and calculate the sum of each digit raised to the power of the total number of digits.
Compare the calculated sum with the original number to determine if it is an Armstrong number.
Return 'YES' if the number is an Armstrong number, 'NO' otherwise.
Q6. One of the questions for Critical Reasoning was:- Two cars A and B cross a flyover in 10 minutes and 30 minutes respectively. Find the speed of Car A. Statements: Car B travels at the 50kmph Train A and B are t...
read moreCar A's speed is 90kmph
Use the formula: Speed = Distance/Time
Assume the distance to be the same for both cars
Calculate Car A's time using the given information
Substitute the values in the formula to get Car A's speed
Q7. Equilibrium Index Problem Statement
Given an array Arr
consisting of N integers, your task is to find the equilibrium index of the array.
An index is considered as an equilibrium index if the sum of elements of...read more
Find the equilibrium index of an array where sum of elements on left equals sum on right.
Iterate through the array and calculate the total sum of all elements.
For each index, calculate the left sum and right sum and check if they are equal.
Return the index if found, otherwise return -1.
Q8. 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:
Each pa...read more
Find pairs of elements in an array that sum up to a given value, sorted in a specific order.
Iterate through the array and use a hashmap to store the difference between the target sum and each element.
Check if the difference exists in the hashmap, if yes, add the pair to the result list.
Sort the result list based on the criteria mentioned in the problem statement.
Return the sorted list of pairs as the final output.
Q9. Tiling Problem Statement
Given a board with 2 rows and N columns, and an infinite supply of 2x1 tiles, determine the number of distinct ways to completely cover the board using these tiles.
You can place each t...read more
The problem involves finding the number of distinct ways to completely cover a 2xN board using 2x1 tiles.
Use dynamic programming to solve the tiling problem efficiently.
Define a recursive function to calculate the number of ways to tile the board.
Consider both horizontal and vertical placements of tiles.
Implement the function to handle large values of N by using modulo arithmetic.
Optimize the solution to avoid redundant calculations.
Q10. Find Middle of Linked List
Given the head node of a singly linked list, your task is to return a pointer pointing to the middle node of the linked list.
When the number of elements is odd, return the middle ele...read more
Return the middle node of a singly linked list, selecting the one farther from the head node in case of even number of elements.
Traverse the linked list using two pointers, one moving twice as fast as the other.
When the fast pointer reaches the end, the slow pointer will be at the middle node.
Return the node pointed by the slow pointer as the middle node.
Q11. Question 2 was, Find the sum of all numbers in range from 1 to m(both inclusive) that are not divisible by n. Return difference between sum of integers not divisible by n with sum of numbers divisible by n.
Find sum of numbers in range 1 to m (both inclusive) not divisible by n. Return difference between sum of non-divisible and divisible numbers.
Iterate through range 1 to m and check if number is divisible by n.
If not divisible, add to sum of non-divisible numbers.
If divisible, add to sum of divisible numbers.
Return difference between sum of non-divisible and divisible numbers.
Q12. 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-insensi...read more
Check if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.
Remove special characters and spaces from the string
Convert the string to lowercase
Check if the modified string is a palindrome by comparing characters from start and end
Q13. Replace Spaces in a String
Given a string STR
consisting of words separated by spaces, your task is to replace all spaces between words with the characters "@40".
Input:
The first line contains an integer ‘T’ d...read more
Replace spaces in a string with '@40'.
Iterate through the string and replace spaces with '@40'.
Return the modified string for each test case.
Handle multiple test cases by iterating through each one.
Q14. Check if Two Trees are Mirror
Given two arbitrary binary trees, your task is to determine whether these two trees are mirrors of each other.
Explanation:
Two trees are considered mirror of each other if:
- The r...read more
Check if two binary trees are mirrors of each other based on specific criteria.
Compare the roots of both trees.
Check if the left subtree of the first tree is the mirror of the right subtree of the second tree.
Verify if the right subtree of the first tree is the mirror of the left subtree of the second tree.
Q15. Ways To Make Coin Change
Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make the c...read more
The task is to determine the total number of ways to make change for a specified value using given denominations.
Create a dynamic programming table to store the number of ways to make change for each value up to the target value.
Iterate through each denomination and update the table accordingly.
The final answer will be the value in the table at the target value.
Consider edge cases such as when the target value is 0 or when there are no denominations available.
Q16. Reverse the String Problem Statement
You are given a string STR
which contains alphabets, numbers, and special characters. Your task is to reverse the string.
Example:
Input:
STR = "abcde"
Output:
"edcba"
Input...read more
Q17. Ninja and Alien Language Order Problem
An alien dropped its dictionary while visiting Earth. The Ninja wants to determine the order of characters used in the alien language, based on the given list of words fro...read more
Determine the order of characters in an alien language based on a list of words from the alien's dictionary.
Create a graph data structure to represent the relationships between characters in the words.
Perform a topological sort on the graph to find the order of characters.
Handle cases where there is no valid order by returning an empty string.
Q18. Find the Second Largest Element
Given an array or list of integers 'ARR', identify the second largest element in 'ARR'.
If a second largest element does not exist, return -1.
Example:
Input:
ARR = [2, 4, 5, 6, ...read more
Find the second largest element in an array of integers.
Iterate through the array to find the largest and second largest elements.
Handle cases where all elements are identical.
Return -1 if a second largest element does not exist.
Q19. Stack using Two Queues Problem Statement
Develop a Stack Data Structure to store integer values using two Queues internally.
Your stack implementation should provide these public functions:
Explanation:
1. Cons...read more
Implement a stack using two queues to store integer values with specified functions.
Use two queues to simulate stack operations efficiently.
Maintain the top element in one of the queues for easy access.
Handle push, pop, top, size, and isEmpty functions as specified.
Ensure proper error handling for empty stack scenarios.
Optimize the implementation to achieve desired time complexity.
Example: Push 42, pop top element (42), push 17, top element is 17.
Q20. Write a code for the length of string without using strlen() function.
Code to find length of string without using strlen() function.
Use a loop to iterate through each character of the string
Increment a counter variable for each character in the string
Stop the loop when the null character '\0' is encountered
Return the counter variable as the length of the string
Q21. Difference between tmap & tjoin Types of connection Difference between truncate delete What is ETL What are triggers Type of join
tmap is used to transform data in Talend, tjoin is used to join data. There are different types of connections, truncate and delete are different ways to remove data from a table. ETL stands for Extract, Transform, Load. Triggers are database objects that are automatically executed in response to certain events. There are different types of joins.
tmap is used for data transformation in Talend
tjoin is used for joining data in Talend
Types of connections include database connect...read more
I managed network calls using RESTful APIs and structured the backend with a MVC architecture.
Utilized RESTful APIs to make network calls between the frontend and backend
Implemented a Model-View-Controller (MVC) architecture to organize backend code
Used frameworks like Spring Boot or Express.js to handle network requests and responses
Q23. Longest Factorial where I have to print the longest factorial .
The longest factorial that can be printed depends on the data type used to store the result.
Factorials grow very quickly, so the data type used to store the result is important.
For example, the largest factorial that can be stored in a 32-bit integer is 12!.
Using a 64-bit integer allows for larger factorials, such as 20!.
Using a floating-point data type allows for even larger factorials, but with reduced precision.
Printing the entire factorial may not be practical, so scienti...read more
Q24. What is your favorite coding language and why?
My favorite coding language is Python because of its simplicity and versatility.
Python has a clean and easy-to-read syntax, making it beginner-friendly.
It has a vast library of modules and frameworks for various applications.
Python is used in various fields such as web development, data science, and artificial intelligence.
It supports multiple programming paradigms such as object-oriented, functional, and procedural programming.
Python has a large and active community, providi...read more
Q25. Write a code for Octal to Decimal Conversion.
Code for Octal to Decimal Conversion
Start from the rightmost digit and move towards the leftmost digit
Multiply each digit with 8 raised to the power of its position
Add all the products obtained in the previous step to get the decimal equivalent
Q26. What are the advantages of OOPS?
OOPS provides modularity, reusability, and extensibility in software development.
Encapsulation ensures data security and prevents unauthorized access.
Inheritance allows for code reuse and reduces redundancy.
Polymorphism enables flexibility and allows for dynamic behavior.
Abstraction simplifies complex systems and hides implementation details.
OOPS promotes better organization and maintenance of code.
Examples: Java, C++, Python, Ruby, etc.
Q27. What is Exceptional Handling in Java?
Exceptional Handling is a mechanism to handle runtime errors in Java programs.
It is done using try-catch blocks.
It prevents the program from crashing due to errors.
It helps in debugging and maintaining the code.
Examples include NullPointerException, ArrayIndexOutOfBoundsException, etc.
Q28. What is a Friend Function in C++?
Friend function is a non-member function that has access to private and protected members of a class.
Declared inside the class but defined outside the class scope
Can access private and protected members of the class
Not a member of the class but has access to its private and protected members
Used to provide access to private or protected members to non-member functions or other classes
Example: friend void display(A);
Example: class A { friend void display(A); };
Q29. Which new technology did you learn recently?
I recently learned about React Native, a framework for building mobile apps using JavaScript.
React Native allows for cross-platform development, reducing the need for separate codebases for iOS and Android.
It uses a similar syntax to React, making it easy for web developers to transition to mobile development.
Some popular apps built with React Native include Facebook, Instagram, and Airbnb.
Q30. Sum of Even & Odd Digits Problem Statement
Create a program that accepts an integer N
and outputs two sums: the sum of all even digits and the sum of all odd digits found in the integer.
Explanation:
Digits ref...read more
Create a program to find the sum of even and odd digits in an integer.
Iterate through each digit of the integer and check if it is even or odd
Keep track of the sum of even digits and odd digits separately
Print the sums of even and odd digits at the end
Q31. Why did you use a CLI library in your project?
CLI library was used for user interaction and ease of use.
CLI library provided a simple and intuitive way for users to interact with the project.
It allowed for easy input and output handling.
Examples include argparse in Python and Commander.js in Node.js.
It also made it easier to automate tasks through scripts.
Overall, it improved the user experience and made the project more accessible.
Q32. Small jumbelled words arranged into meaningful sentences
The question is asking for small jumbled words to be arranged into meaningful sentences.
Read each word carefully and try to identify any patterns or connections between them.
Look for common parts of speech such as nouns, verbs, and adjectives.
Try rearranging the words in different orders to see if any make sense.
Use context clues to help determine the meaning of each word.
Practice with similar exercises to improve your skills.
Q33. What is MultiThreading?
Multithreading is the ability of a CPU to execute multiple threads concurrently.
Multithreading allows for better utilization of CPU resources.
It can improve application performance by allowing multiple tasks to run simultaneously.
Multithreading can be implemented in various programming languages such as Java, C++, and Python.
Examples of multithreaded applications include web servers, video games, and media players.
Q34. Maximum Subarray Sum Problem Statement
Given an array ARR
consisting of N
integers, your goal is to determine the maximum possible sum of a non-empty contiguous subarray within this array.
Example of Subarrays:...read more
Find the maximum sum of a contiguous subarray in an array of integers.
Use Kadane's algorithm to find the maximum subarray sum efficiently.
Initialize two variables: maxEndingHere and maxSoFar.
Iterate through the array and update the variables accordingly.
Return the maxSoFar as the result.
Q35. Difference between polymorphism and abstraction.
Polymorphism is the ability of an object to take on many forms. Abstraction is the process of hiding implementation details.
Polymorphism allows objects of different classes to be treated as if they are of the same class.
Abstraction allows us to focus on the essential features of an object rather than its implementation details.
Polymorphism is achieved through method overriding and method overloading.
Abstraction is achieved through abstract classes and interfaces.
Example of po...read more
Q36. Remember small stories and recite and rephrase accordingly.
Recalling small stories and rephrasing them
Practice active listening to remember stories accurately
Use your own words to rephrase the story
Try to capture the main idea and important details
Use visualization techniques to help remember the story
Practice recalling stories with friends or family
Q37. What are the technicalities related to the project(s).
The project involves developing a web-based application for managing inventory and sales.
The application will be built using Java and Spring framework.
It will have a user-friendly interface for adding, updating and deleting products.
The application will also generate reports on sales and inventory levels.
The database used will be MySQL.
The project will follow Agile methodology for development.
Seating arrangement questions involve arranging people in a specific order based on given conditions.
Identify the total number of people to be seated
Understand the given conditions for seating arrangement
Use logic and elimination to determine the final seating arrangement
Q39. What are OOPS Concept?
OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.
OOPS is based on four main concepts: Encapsulation, Inheritance, Polymorphism, and Abstraction.
Encapsulation is the process of hiding the implementation details of an object from the outside world.
Inheritance allows a class to inherit properties and methods from another class.
Polymorphism allows objects of different classes to be treated as if they were of the same...read more
Q40. What is AI how you implement AI in your project
AI stands for Artificial Intelligence, which involves creating intelligent machines that can simulate human behavior and thinking.
AI is implemented in projects through machine learning algorithms like neural networks, decision trees, and support vector machines.
Natural language processing and computer vision are common AI techniques used in projects.
AI can be used in recommendation systems, chatbots, autonomous vehicles, and more.
Example: Implementing a chatbot using natural ...read more
Q41. What is your favorite programming language?
My favorite programming language is Python.
Python is a versatile and easy-to-learn language.
It has a simple and readable syntax, making it great for beginners.
Python has a large and active community, providing extensive libraries and frameworks.
It is widely used in various domains like web development, data analysis, and machine learning.
Python's extensive documentation and support make it a developer-friendly language.
Q42. Ninja and Candies Problem
Ninja, a boy from Ninjaland, receives 1 coin every morning from his mother. He wants to purchase exactly 'N' candies. Each candy usually costs 2 coins, but it is available for 1 coin i...read more
Calculate the earliest day on which Ninja can buy all candies with special offers.
Iterate through each day and check if any special offer is available for candies Ninja wants to buy
Keep track of the minimum day on which Ninja can buy all candies
Consider both regular price and sale price of candies
Q43. Why did you switch from Mechanical to Software?
I switched from Mechanical to Software because I discovered my passion for coding and problem-solving.
Discovered passion for coding and problem-solving
Enjoyed programming courses and projects
Realized software development offered more opportunities for growth and innovation
Q44. Repeating sentences after an audio command.
Repeating sentences after an audio command
This is a common feature in voice assistants like Siri or Alexa
The device listens for a trigger word or phrase, then repeats the command back to the user
This can be useful for confirming that the device understood the command correctly
Q45. Print Permutations - String Problem Statement
Given an input string 'S', you are tasked with finding and returning all possible permutations of the input string.
Input:
The first and only line of input contains...read more
Return all possible permutations of a given input string.
Use recursion to generate all possible permutations of the input string.
Swap characters at different positions to generate different permutations.
Handle duplicate characters by skipping swapping if the characters are the same.
Return the list of permutations as an array of strings.
Q46. What is sorting in data structures
Sorting in data structures is the process of arranging data in a particular order, usually in ascending or descending order.
Sorting helps in organizing data for efficient searching and retrieval.
Common sorting algorithms include Bubble Sort, Selection Sort, Insertion Sort, Merge Sort, Quick Sort, etc.
Example: Sorting an array of numbers in ascending order - [5, 2, 8, 1, 3] becomes [1, 2, 3, 5, 8].
Q47. Postfix Expression Evaluation Problem Statement
Given a postfix expression, your task is to evaluate the expression. The operator will appear in the expression after the operands. The output for each expression...read more
Evaluate postfix expressions by applying operators after operands. Return result modulo (10^9+7).
Read the postfix expression from input
Use a stack to store operands and apply operators
Perform modular division when necessary
Output the final result for each test case
Q48. What is foriegn Key and Primary key? What is normalisation? What is abstraction, polymorphism?
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables. Normalization is the process of organizing data in a database to reduce redundancy. Abstraction is hiding the implementation details, and polymorphism allows objects to be treated as instances of their parent class.
Primary key uniquely identifies each record in a table
Foreign key establishes a link between two tables
Normalization reduces redundancy in database desi...read more
Q49. Replace Character Problem Statement
Given an input string S
and two characters 'c1' and 'c2', your task is to replace every occurrence of the character 'c1' with the character 'c2' in the given string.
Input:
L...read more
Replace every occurrence of a character in a string with another character.
Iterate through the input string and replace 'c1' with 'c2' using string manipulation functions.
Return the updated string as the output.
Q50. Machine Learning,Types and Real life examples
Machine learning is a subset of artificial intelligence that involves the development of algorithms and statistical models to perform specific tasks without explicit instructions.
Types of machine learning include supervised learning, unsupervised learning, and reinforcement learning.
Supervised learning involves training a model on labeled data to make predictions.
Unsupervised learning involves finding patterns in unlabeled data.
Reinforcement learning involves training a model...read more
Q51. Define OOPs Concept
OOPs (Object-Oriented Programming) is a programming paradigm that organizes code into objects with properties and behaviors.
OOPs focuses on creating reusable code by encapsulating data and methods within objects.
It emphasizes the concepts of inheritance, polymorphism, and encapsulation.
Objects are instances of classes, which define their structure and behavior.
Inheritance allows classes to inherit properties and methods from other classes.
Polymorphism enables objects to take ...read more
Q52. What are the indexes you used ? Diff between bitmap and btree index
Indexes used include bitmap and btree. Bitmap index is used for low cardinality columns, while btree index is used for high cardinality columns.
Bitmap index is efficient for low cardinality columns with few distinct values
Btree index is efficient for high cardinality columns with many distinct values
Bitmap index uses bitmaps to represent the presence of a value in a column
Btree index is a balanced tree structure that allows for fast searching and retrieval of data
Q53. String Transformation Problem
Given a string (STR
) of length N
, you are tasked to create a new string through the following method:
Select the smallest character from the first K
characters of STR
, remove it fr...read more
Given a string and an integer K, create a new string by selecting the smallest character from the first K characters of the input string and repeating the process until the input string is empty.
Iterate through the input string, selecting the smallest character from the first K characters each time.
Remove the selected character from the input string and append it to the new string.
Continue this process until the input string is empty.
Return the final new string formed.
Q54. string using loop
To create a string using loop
Declare an empty string variable
Use a loop to concatenate desired strings to the variable
Use the loop condition to control the number of iterations
Q55. Why the Talend is popular?
Talend is popular due to its open-source nature, ease of use, and ability to integrate with various systems.
Talend is open-source, making it accessible to a wide range of users.
It has a user-friendly interface, allowing developers to easily create and manage data integration workflows.
Talend can integrate with various systems, including cloud-based platforms like AWS and Azure.
It offers a wide range of connectors and components, making it versatile and adaptable to different ...read more
Q56. What are job & components in Talend?
Talend is an ETL tool used for data integration. Jobs are workflows created in Talend to perform specific tasks. Components are pre-built functions used in jobs.
Jobs are created in Talend to perform specific tasks such as data extraction, transformation, and loading.
Components are pre-built functions that can be used in jobs to perform specific actions such as reading data from a file or database, transforming data, and writing data to a file or database.
Talend provides a wid...read more
Q57. Arithmetic Expression Evaluation Problem Statement
You are provided with a string expression
consisting of characters '+', '-', '*', '/', '(', ')' and digits '0' to '9', representing an arithmetic expression in...read more
Evaluate arithmetic expressions in infix notation with given operators and precedence rules.
Parse the infix expression to postfix using a stack and then evaluate the postfix expression using another stack
Use a stack to keep track of operators and operands while parsing the expression
Handle operator precedence and associativity rules while converting to postfix and evaluating the expression
Q58. Write a basic code in C++
A basic code in C++
Use the 'int main()' function as the entry point of the program
Declare an array of strings using the syntax 'string arrayName[size]'
Initialize the array with values
Access and manipulate the elements of the array using indexing
Q59. Explain DBMS concept to a four year child
DBMS is like a big box where we keep all our information organized so we can find it easily.
DBMS stands for Database Management System
It helps us store and organize information in a structured way
We can easily search, add, delete or modify information in DBMS
Examples of DBMS are MySQL, Oracle, SQL Server
Q60. Case. There is a housing society “The wasteful society”, you collect all the household garbage and sell it to 5 different businesses. Determine what price you will pay to the society members in Rs/kg, given you...
read moreDetermining the price to pay to a housing society for their garbage collection and sale to 5 different vendors while making a 20% profit.
Calculate the cost of collecting and transporting the garbage
Research the market prices for each type of waste material
Determine the profit margin required
Calculate the selling price to each vendor based on market prices and profit margin
Determine the price to pay to the society members based on the cost and profit margin
Consider negotiating...read more
Q61. What are the differences between a procedure and a function?
Procedures do not return a value, while functions return a value.
Procedures are used to perform an action, while functions are used to calculate and return a value.
Functions must return a value, while procedures do not have a return statement.
Functions can be called from within SQL statements, while procedures cannot.
Example: Procedure - void PrintMessage(string message) { Console.WriteLine(message); }
Example: Function - int AddNumbers(int a, int b) { return a + b; }
Q62. Reverse Number Problem Statement
Ninja is exploring new challenges and desires to reverse a given number. Your task is to assist Ninja in reversing the number provided.
Note:
If a number has trailing zeros, the...read more
Implement a function to reverse a given number, omitting trailing zeros.
Create a function that takes an integer as input and reverses it while omitting trailing zeros
Use string manipulation to reverse the number and remove any trailing zeros
Handle test cases where the number has leading zeros as well
Ensure the reversed number is printed for each test case on a new line
Q63. What is managable unmanagable code. User and customerised control Triggers DI Global.csx Namespace Ado.net Generic and partial class Aspx,asmx,ascx Query optimisation using indexes Dataset and table
Manageable code is well-structured, organized, and easy to maintain, while unmanageable code is messy, hard to understand, and prone to errors.
Manageable code follows best practices and design patterns, making it easier to read and maintain.
Unmanageable code lacks structure, consistency, and documentation, making it difficult to work with.
Examples of manageable code include well-commented classes and methods, consistent naming conventions, and modular architecture.
Examples of...read more
Q64. steps in software development life cycle
Software development life cycle involves planning, designing, coding, testing, and maintenance.
Planning: Define project scope, requirements, and objectives.
Design: Create a detailed plan for the software solution.
Coding: Write the code according to the design.
Testing: Verify that the software meets the requirements and is free of defects.
Maintenance: Make changes to the software to keep it up-to-date and functioning properly.
Q65. Difference between c and cpp
C is a procedural programming language while C++ is an object-oriented programming language.
C is a subset of C++.
C does not support classes and objects, while C++ does.
C++ supports function overloading and operator overloading, which C does not.
C++ has a more extensive standard library compared to C.
C++ allows for both procedural and object-oriented programming paradigms.
Q66. Valid Parentheses Problem Statement
Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.
Input:
The first line contains an integer...read more
The task is to determine if a given string of parentheses is balanced or not.
Iterate through the characters of the string and use a stack to keep track of opening parentheses.
When encountering an opening parenthesis, push it onto the stack. When encountering a closing parenthesis, check if it matches the top of the stack.
If the stack is empty at the end or there are unmatched parentheses, the string is not balanced.
Example: For input '{}[]()', the stack will contain '{', '[',...read more
Q67. Write a query to find 3rd highest salary from each department
Query to find 3rd highest salary from each department
Use window functions like ROW_NUMBER() to rank salaries within each department
Filter the results to only include rows where the rank is 3
Group by department to get the 3rd highest salary for each department
Q68. Reverse an Array
Reverse an array of strings.
Create a new empty array
Loop through the original array in reverse order
Push each element into the new array
Return the new array
Q69. write logic for program to remove duplicates in a string
Program to remove duplicates in a string
Create an empty array to store unique characters
Iterate through each character in the string
Check if the character is already in the array, if not add it
Q70. How to deactivate trigger in proudction?
To deactivate a trigger in production, you can use the ALTER TRIGGER statement to disable the trigger.
Use the ALTER TRIGGER statement with the DISABLE option to deactivate the trigger.
Make sure to test the trigger deactivation in a non-production environment before applying it to production.
Document the trigger deactivation process for future reference and troubleshooting.
Q71. Comparison between Talend & pentaho.
Talend and Pentaho are both open-source data integration tools, but Talend is more user-friendly while Pentaho has better reporting capabilities.
Talend has a drag-and-drop interface and a large library of pre-built components, making it easier for non-technical users to create data integration workflows.
Pentaho has a more robust reporting engine and better visualization capabilities, making it a better choice for business intelligence and analytics.
Both tools support a wide r...read more
Q72. LCA of Three Nodes Problem Statement
You are given a Binary Tree with 'N' nodes where each node contains an integer value. Additionally, you have three integers, 'N1', 'N2', and 'N3'. Your task is to find the L...read more
Find the Lowest Common Ancestor (LCA) of three nodes in a Binary Tree.
Traverse the Binary Tree to find the paths from the root to each of the three nodes.
Compare the paths to find the common ancestor node.
Return the value of the Lowest Common Ancestor node.
Q73. Pronounciation of words
Pronunciation of words is important for effective communication and understanding.
Practice pronouncing difficult words regularly
Use online resources like dictionaries or pronunciation guides
Ask for feedback from native speakers or language teachers
Q74. Tcode for badi and how to find badi
Tcode for BADI is SE18. To find a BADI, use transaction code SE18 and enter the BADI name or filter by application area.
Tcode for BADI is SE18
To find a BADI, use transaction code SE18
Enter the BADI name or filter by application area
Q75. Explain project
The project was a web application for managing inventory and sales for a retail store.
Developed using Java and Spring framework
Implemented CRUD operations for managing products and customers
Integrated with payment gateway for online transactions
Generated reports for sales and inventory management
Deployed on AWS EC2 instance
Q76. Favourite language
My favourite language is Python.
Python is easy to learn and has a simple syntax.
It has a large community and a vast number of libraries.
Python is versatile and can be used for web development, data analysis, machine learning, and more.
Q77. 3. Concepts of OOPS
OOPS stands for Object-Oriented Programming System. It is a programming paradigm based on the concept of objects.
OOPS focuses on creating objects that interact with each other to solve a problem
It emphasizes on encapsulation, inheritance, and polymorphism
Encapsulation is the process of hiding the implementation details of an object from the outside world
Inheritance allows a class to inherit properties and methods from another class
Polymorphism allows objects to take on multip...read more
Q78. A marketing strategy case. Client is a perfume seller in Jaipur. The perfumes he sells are not to be found anywhere else in the world. The product has not been tried by people elsewhere apart from the city. Tou...
read moreCreate a digital marketing campaign targeting tourists and potential customers outside Jaipur.
Create a website and social media pages to showcase the unique perfumes and their ingredients.
Partner with local hotels and travel agencies to promote the perfumes to tourists.
Offer discounts or promotions for customers who refer their friends and family.
Create a loyalty program to incentivize repeat customers.
Consider expanding the product line to include other unique scents.
Collect...read more
Q79. Accademic project?
Developed a web-based project management system using Java and MySQL.
Implemented user authentication and authorization using Spring Security.
Utilized Hibernate for database operations and RESTful APIs for communication.
Designed a responsive front-end using HTML, CSS, and JavaScript.
Tested the application using JUnit and Selenium for automated testing.
Q80. What is OOPS concept what is class what is inheritance what is Function what is Map what is sting
OOPS (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
Class is a blueprint for creating objects. It defines the properties and behaviors of objects.
Inheritance allows a class to inherit properties and methods from another class. It promotes code reusability.
Function is a block of code that performs a specific task. It can be called multiple times.
Map is a collection of key-value pairs where each key is un...read more
Q81. How can solve the problem? When employees have their different solution
To solve the problem of employees having different solutions, it is important to encourage open communication, facilitate collaboration, and consider all perspectives.
Encourage open communication among employees to understand their different solutions
Facilitate collaboration by organizing team meetings or brainstorming sessions
Consider all perspectives and evaluate the pros and cons of each solution
Seek consensus or compromise to find a solution that satisfies everyone
Impleme...read more
Q82. A link layer switch is involved in_____layers of the TCP/IP protocol suite. a.2 b.3 c.4 d.5
A link layer switch is involved in which layers of the TCP/IP protocol suite?
A link layer switch operates at the data link layer (layer 2) of the TCP/IP protocol suite.
It is responsible for forwarding data packets between devices on the same network segment.
It does not operate at the network, transport, or application layers.
Q83. how you will create a branch
To create a branch, use version control system commands like git branch.
Use 'git branch' command to create a new branch in Git.
Specify the branch name after the command, e.g. 'git branch new-feature'.
To switch to the newly created branch, use 'git checkout new-feature'.
Q84. Product Of Array Except Self Problem Statement
You are provided with an integer array ARR
of size N
. You need to return an array PRODUCT
such that PRODUCT[i]
equals the product of all the elements of ARR
except...read more
The problem requires returning an array where each element is the product of all elements in the input array except itself.
Iterate through the array twice to calculate the product of all elements to the left and right of each element.
Use two arrays to store the products of elements to the left and right of each element.
Multiply the corresponding elements from the left and right arrays to get the final product array.
Handle integer overflow by taking modulo MOD = 10^9 + 7.
To so...read more
Q85. Program to check if string is palindrome or not.
A program to check if a given string is a palindrome or not.
Remove all non-alphanumeric characters from the string
Convert the string to lowercase
Reverse the string and compare it with the original string
If they are the same, the string is a palindrome
Q86. Jumbled Sentence
The jumbled sentence is a set of words that are not in the correct order. The task is to rearrange the words to form a meaningful sentence.
Identify the subject, verb, and object in the sentence.
Look for connecting words like conjunctions or prepositions to help determine the correct order.
Consider the context or topic of the sentence to make logical sense of the words.
Rearrange the words in a way that makes grammatical sense and forms a coherent sentence.
Q87. Hierarchy in Talend.
Hierarchy in Talend refers to the organization of data flow components in a job.
Hierarchy is important for understanding the flow of data in a job.
Components can be organized into subjobs and routines for better organization.
Hierarchy can be viewed and edited in the Talend Studio interface.
Example: A job may have a parent job with multiple child subjobs for different tasks.
Q88. Difference between props and refs
Props are used to pass data from parent to child components, while refs are used to reference a DOM element or a class component instance.
Props are read-only and cannot be modified by the child component.
Refs are used to access the DOM nodes or class component instances in React.
Props are passed down through the component tree, while refs are typically used within a single component.
Example:
for props, and for refs.
Q89. Prime Numbers Identification
Given a positive integer N
, your task is to identify all prime numbers less than or equal to N
.
Explanation:
A prime number is a natural number greater than 1 that has no positive d...read more
Q90. coding question - find the duplicate elements present in a given array
Find duplicate elements in an array
Iterate through the array and compare each element with all other elements
If a match is found, add it to a separate array
Return the array of duplicate elements
Sum At Kth Level
Given the root of a binary tree, calculate the sum of all nodes located at the Kth level from the top. Consider the root node as level 1, and each level beneath it sequentially increases by 1.
Calculate the sum of nodes at the Kth level of a binary tree given the root.
Traverse the binary tree level by level using BFS.
Keep track of the current level while traversing.
Sum the nodes at the Kth level and return the result.
Q92. BFS Traversal in a Graph
Given an undirected and disconnected graph G(V, E) where V vertices are numbered from 0 to V-1, and E represents edges, your task is to output the BFS traversal starting from the 0th ve...read more
BFS traversal in a disconnected graph starting from vertex 0.
Implement BFS algorithm to traverse the graph starting from vertex 0.
Explore neighbor nodes first before moving to the next level neighbors.
Consider undirected and disconnected graph where not all pairs of vertices have paths connecting them.
Output the BFS traversal sequence for each test case in a separate line.
Ensure the BFS path starts from vertex 0 and print connected nodes in numerical sort order.
Q93. Which is the oldest programming language?
Fortran is the oldest programming language.
Fortran was developed in the 1950s by IBM.
It stands for Formula Translation.
It was primarily used for scientific and engineering calculations.
Other old programming languages include COBOL and Lisp.
Q94. Subarray With Given Sum Problem Statement
Given an array ARR
of N integers and an integer S, determine if there exists a contiguous subarray within the array with a sum equal to S. If such a subarray exists, re...read more
Q95. Alien Dictionary Problem Statement
You are provided with a sorted dictionary (by lexical order) in an alien language. Your task is to determine the character order of the alien language from this dictionary. Th...read more
Given a sorted alien dictionary in an array of strings, determine the character order of the alien language.
Iterate through the words in the dictionary to find the order of characters.
Create a graph of characters based on the order of appearance in the words.
Perform a topological sort on the graph to get the character order of the alien language.
Q96. delete vs truncate
Delete removes rows from a table, while truncate removes all rows and resets identity seed.
Delete is a DML command, while truncate is a DDL command.
Delete can be rolled back, while truncate cannot be rolled back.
Delete fires triggers, while truncate does not fire triggers.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of data pages.
Q97. Explain me what is Encapsulation
Encapsulation is the process of hiding implementation details and restricting access to an object's properties and methods.
Encapsulation helps in achieving data abstraction and security.
It allows for better control over the data and prevents unauthorized access.
Encapsulation is implemented using access modifiers such as public, private, and protected.
For example, a bank account class may have private variables for account number and balance, and public methods for deposit and...read more
Q98. Type of search help
Search help is a feature in SAP that provides users with a list of possible values to choose from when entering data in a field.
Search help can be defined at the field level in the data dictionary
Different types of search helps include elementary search helps, collective search helps, and collective search helps with check table
Examples of search helps include F4 help in SAP GUI and value helps in WebDynpro applications
Q99. How the operating system will work?
An operating system manages computer hardware and software resources and provides common services for computer programs.
The OS manages memory, CPU, and input/output devices.
It provides a user interface for interaction with the computer.
It manages file systems and provides security features.
Examples include Windows, macOS, and Linux.
The OS kernel is the core component that interacts with hardware.
The OS can be single-tasking or multi-tasking.
Virtualization allows multiple OS i...read more
Q100. Explain the difference between Array and a linked list.
Array is a fixed-size data structure with elements stored sequentially, while linked list is a dynamic data structure with elements stored non-sequentially.
Arrays have fixed size, while linked lists can grow dynamically.
Accessing elements in an array is faster (O(1)), while in a linked list it is slower (O(n)).
Inserting or deleting elements in an array can be inefficient, as it may require shifting elements, while in a linked list it is efficient.
Example: Array - ['apple', 'b...read more
More about working at Accenture
Top HR Questions asked in Diligente Technologies
Interview Process at Diligente Technologies
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month