Idea Usher Intern Interview Questions and Answers

Basic questions divided in 4 sections of 20 min each

2-3 case study was given and asked to give answer based on that

Basic aptitude , c programming, digital design

Q1. Puzzels,digital design, programming
Add your answer
Q2. Implement flip flop using mux
Ans. 
Flip flop can be implemented using a multiplexer by selecting the input based on the control signal.
• Use a 2:1 multiplexer to select between the current state and the next state

• Connect the output of the multiplexer to the input of the flip flop

• Control signal determines which input is passed through the multiplexer
Answered by AI
Add your answer

Q1. Project discussion
Add your answer
Q2. Technical Project discussion
Add your answer

Q1. Questions on DSA were asked by the interviewer at first.
Add your answer
Q2. Some theoretical questions from DBMS and oops and also asked to write some SQL queries.
Add your answer

Q1. This round was also similar to the first technical round at first given a DSA question.
Add your answer
Q2. After that I was asked to write some SQL queries and also questions from resume were asked.
Add your answer

Q1. This was managerial round which was was offline in person interview. At first he asked sone basic DBMS and oops questions.
Add your answer
Q2. Then gave me a question and asked me to write a complex SQL query.
Add your answer

Round duration - 120 Minutes
Round difficulty - Medium

Q1. DBMS Question
Write a query to create an employee table with (employee_id, name, dept) with employee_id as its primary key
Ans. 
A query to create an employee table with employee_id, name, and dept columns, with employee_id as the primary key.
• Use the CREATE TABLE statement to create the employee table.

• Specify the data types and constraints for each column.

• Set the employee_id column as the primary key using the PRIMARY KEY constraint.
Answered by AI
View 1 more answer
Q2. Inorder Traversal
You have been given a Binary Tree of 'N' nodes, where the nodes have integer values. Your task is to find the In-Order traversal of the given binary tree.
For example :
For the ...read more
Ans. 
The task is to find the in-order traversal of a given binary tree.
• Implement a recursive function to perform in-order traversal of the binary tree

• Start from the left subtree, then visit the root node, and finally visit the right subtree

• Use an array to store the values of the nodes in the in-order traversal
Answered by AI
View 4 more answers

Round duration - 50 minutes
Round difficulty - Medium

Interview on google meet

Q1. DBMS Question
Given two tables, return a inner join on a common column (key)
Ans. 
The inner join operation combines rows from two tables based on a common column (key).
• Use the JOIN keyword in the SQL query to perform an inner join.

• Specify the common column (key) in the ON clause of the join.

• The result will contain only the matching rows from both tables.
Answered by AI
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

Q1. Search In A Row Wise And Column Wise Sorted Matrix
You are given an N * N matrix of integers where each row and each column is sorted in increasing order. You are given a target integer 'X'. Find t...read more
Ans. 
Given a sorted matrix, find the position of a target integer in the matrix.
• Iterate through each row and column of the matrix

• Compare the target integer with the current element

• If the target integer is found, return the position

• If the target integer is not found, return {-1, -1}
Answered by AI
View 4 more answers

Machine coding round

Q1. About projects, like the what stack used
Add your answer
Q2. Hr question about why to join browserstack
Add your answer

Basic questions divided in 4 sections of 20 min each

2-3 case study was given and asked to give answer based on that