Naukri Production Engineer Interview Questions and Answers

• Are you responsible for your own life?

Q1. What is ACID in DBs ?
Ans. 
ACID stands for Atomicity, Consistency, Isolation, and Durability in databases.
• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that multiple transactions can be executed concurrently without affecting each other.

• Durability ensures that once a transaction...read more
Answered by AI
Add your answer
Q2. What is the difference in checked and unchecked exceptions ?
Ans. 
Checked exceptions are checked at compile time while unchecked exceptions are not checked at compile time.
• Checked exceptions are subclasses of Exception class except RuntimeException and its subclasses.

• Unchecked exceptions are subclasses of RuntimeException and Error classes.

• Checked exceptions must be caught or declared in the method signature using 'throws' keyword.

• Unchecked exceptions do not need to be caught or decl...read more
Answered by AI
Add your answer
Q3. Find the min difference between any two integers of 2 sorted list
Ans. 
To find the minimum difference between any two integers of 2 sorted lists, iterate through both lists simultaneously and keep track of the minimum difference.
• Iterate through both sorted lists simultaneously

• Keep track of the minimum difference found so far

• Update the minimum difference if a smaller difference is found
Answered by AI
Add your answer

Q1. What is AI ?
Ans. 
AI stands for Artificial Intelligence, which is the simulation of human intelligence processes by machines, especially computer systems.
• AI involves the development of algorithms that can perform tasks that typically require human intelligence.

• Examples of AI include speech recognition, image recognition, natural language processing, and autonomous vehicles.

• AI can be categorized into narrow AI (focused on a specific task...read more
Answered by AI
Add your answer
Q2. Tell me about machine learning
Ans. 
Machine learning is a branch of artificial intelligence that involves developing algorithms and models that can learn from and make predictions or decisions based on data.
• Machine learning uses algorithms to analyze data, learn from it, and make predictions or decisions.

• It is used in various fields such as healthcare, finance, marketing, and more.

• Examples of machine learning applications include recommendation systems, ...read more
Answered by AI
Add your answer

Q1. What is actual rule is using to sale more products in this company
Ans. 
The actual rule for selling more products in this company is to focus on customer needs and provide excellent customer service.
• Focus on customer needs and preferences

• Provide excellent customer service

• Offer promotions and discounts

• Maintain high product quality

• Stay up-to-date with market trends

• Build strong relationships with customers

• Encourage customer feedback and use it to improve

• Train sales staff to be knowledgeable a
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Two coding questions were given in the first round to be solved in 60 minutes.

Q1. 
Rearrange Array Elements Problem Statement
Given an array A containing 'N' integers and an integer m, rearrange the elements of the array such that the differences between the array elements and m are sor...read more
Ans. 
Rearrange array elements based on their differences from a given integer.
• Calculate the differences between each element and the given integer.

• Sort the elements based on their differences while maintaining the original order for elements with the same difference.

• Implement a function to rearrange the array elements as per the given criteria.
Answered by AI
Add your answer
Q2. 
Print Nodes at Distance K from a Given Node
Given an arbitrary binary tree, a node of the tree, and an integer 'K', find all nodes that are at a distance K from the specified node, and return a list of th...read more
Ans. 
The task is to find all nodes in a binary tree that are at a distance K from a given node.
• Traverse the binary tree to find the given node

• From the given node, perform a depth-first search to find all nodes at distance K

• Use a list to store the values of the nodes at distance K

• Return the list of values in any order
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions based on DSA, DBMS, Computer Networking and project based questions.

Q1. 
Triangle of Numbers Pattern
Ninja is tasked with printing a triangle pattern based on a given number 'N' for any test case.
Example:
Input:
N = 4
Output:
   1
  232
 34545
4567654
Explanation:
The pat...read more
Ans. 
Print a triangle pattern of numbers based on a given number 'N'.
• Iterate through each row and print the numbers accordingly

• Use spaces to center-align the numbers in each row

• Increment the numbers in each row as per the pattern
Answered by AI
Add your answer
Q2. What is the difference between a web server and an application server?
Ans. 
Web server serves static content over HTTP, while application server runs dynamic content and business logic.
• Web server handles HTTP requests and responses, serving static content like HTML, images, and CSS.

• Application server executes business logic, runs dynamic content, and interacts with databases.

• Web server examples include Apache, Nginx, while application server examples include Tomcat, JBoss.

• Web server focuses on...read more
Answered by AI
Add your answer
Q3. How does the internet work?
Ans. 
The internet is a global network of interconnected computers that communicate using standardized protocols.
• The internet is made up of a vast number of interconnected networks of computers.

• Data is transmitted over the internet using protocols such as TCP/IP.

• Websites are hosted on servers connected to the internet, and users access them using web browsers.

• Internet Service Providers (ISPs) provide access to the internet f...read more
Answered by AI
Add your answer
Q4. Write a SQL query to find the nth highest salary.
Ans. 
SQL query to find the nth highest salary
• Use the 'SELECT DISTINCT' statement to get unique salary values

• Order the salaries in descending order using 'ORDER BY' clause

• Use 'LIMIT' and 'OFFSET' to get the nth highest salary
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.