99 Doselect Interview Questions and Answers | HR, Technical & Aptitude Prep

20 common asked question in every interview

Ques:- Define Join and explain different type of joins?

Right Answer:
A join is a SQL operation that combines rows from two or more tables based on a related column between them. The different types of joins are:

1. **INNER JOIN**: Returns only the rows that have matching values in both tables.
2. **LEFT JOIN (or LEFT OUTER JOIN)**: Returns all rows from the left table and the matched rows from the right table; if there is no match, NULLs are returned for columns from the right table.
3. **RIGHT JOIN (or RIGHT OUTER JOIN)**: Returns all rows from the right table and the matched rows from the left table; if there is no match, NULLs are returned for columns from the left table.
4. **FULL JOIN (or FULL OUTER JOIN)**: Returns all rows when there is a match in either left or right table; unmatched rows will have NULLs in the columns of the table that does not have a match.
5. **CROSS JOIN**: Returns the Cartesian product of

sql

Ques:- Define primary key in Sql Server?

Database Administrator (dba) SQL Server

Ques:- What is database replicaion? What are the different types of replication you can set up in SQL Server?

sql System Engineer

Ques:- List out the differences between Union, Interact and Minus operators?

Right Answer:
- **Union**: Combines the results of two queries and removes duplicates. It returns all unique rows from both queries.

- **Intersect**: Returns only the rows that are common to both queries. It shows the intersection of the two result sets.

- **Minus**: Returns the rows from the first query that are not present in the second query. It shows the difference between the two result sets.

JAVA Jsp Software Developer/ Programmer SQL Server

Ques:- What is difference between UNIQUE and PRIMARY KEY constraints?

Javascript

Ques:- How to write a class

Javascript Project Leader/ Project Manager

Ques:- How to create a function using function constructor?

Javascript Team Lead/ Tech Lead

Ques:- What is WMLScript standard libraries?

Javascript Team Lead/ Tech Lead

Ques:- How to control how long an Ajax request may last?

Javascript Tech Architect

Ques:- Diff b/w javascript and jquery

Problem Solving Regional Manager

Ques:- Give a specific example of a time when you had to address an angry customer. What was the problem and what was the outcome? How would you asses your role in diffusing the situation?

Right Answer:
In my previous role as a Regional Manager, I encountered an angry customer who was upset about a delayed shipment of their order. The customer was frustrated because the delay affected their business operations. I listened actively to their concerns, apologized for the inconvenience, and assured them I would resolve the issue promptly. I contacted the logistics team to expedite the shipment and provided the customer with regular updates. As a result, the shipment arrived two days later, and the customer appreciated the communication and quick resolution. I assess my role as crucial in diffusing the situation by remaining calm, showing empathy, and taking immediate action to resolve the problem.

Problem Solving

Ques:- The year is 1980, your client has invented a new piece of office equipment called a fax machine. They are debating whether or not to invest in manufacturing and marketing this product. What factors should they consider and should the launch it or not launch it and why?

Right Answer:
They should consider market demand for fax machines, competition, production costs, potential pricing, target audience, and technological trends. If there is a significant demand and they can produce it at a competitive price, they should launch it; otherwise, they should hold off.

Problem Solving

Ques:- What factors influence the revenue potential of a new pharmaceutical product?

Right Answer:
The revenue potential of a new pharmaceutical product is influenced by factors such as market demand, pricing strategy, competition, regulatory approval, patent protection, marketing effectiveness, target patient population, distribution channels, and reimbursement policies.

Problem Solving Regional Manager

Ques:- Suppose you are working for a leading manufacturer of electronic equipment for industrial customers. The R&D department has developed a new product — a device that could replace all energy costs (electric, gas, etc.) using solar technology. The estimated price to the customer would be 15 lakh per house, with a payback period of 3 to 5 years. The R&D department says the estimated investment is 600 crore. What is your opinion?

Right Answer:

The investment of 600 crore seems high compared to the potential revenue from selling the product at 15 lakh per house. To assess viability, we need to calculate the break-even point and consider market demand, competition, and potential barriers to adoption. If the market is large enough and the product is competitive, it could be a worthwhile investment; otherwise, it may pose significant financial risks.

Problem Solving

Ques:- We are analyzing a manufactures high-end athletic footwear. The company’s sales are up but profits are flat. What do we need to look at?

Right Answer:
We need to look at the cost of production, pricing strategy, marketing expenses, inventory management, and potential discounts or promotions affecting profit margins.

Logical reasoning Product Manager

Ques:- How would you describe the color green to a blind and deaf person?

Right Answer:
I would describe the color green as the feeling of freshness and renewal, like the coolness of grass under your feet or the scent of nature after rain. It represents growth and harmony, similar to the calmness you feel when surrounded by trees.

Logical reasoning

Ques:- How many fire trucks are sold every year in India?

Right Answer:
The exact number of fire trucks sold every year in India is not publicly available, but estimates suggest it ranges from 1,000 to 2,000 units.

Logical reasoning Senior Consultant

Ques:- How many briefcases you will need in order to carry $10Mn in cash, all $100 bills, in bundles of 1,000 bills each?

Right Answer:
You will need 10 briefcases.

Logical reasoning

Ques:- Tell the no of gas stations are there in the US?

Right Answer:
There are approximately 150,000 gas stations in the US.

Logical reasoning

Ques:- Simulate a chess board using C++ and data structures?

Right Answer:
```cpp
#include <iostream>
#include <vector>

class ChessBoard {
public:
ChessBoard() {
board.resize(8, std::vector<char>(8, '.')); // Initialize an 8x8 board with '.'
}

void display() {
for (const auto& row : board) {
for (const auto& cell : row) {
std::cout << cell << ' ';
}
std::cout << std::endl;
}
}

void placePiece(char piece, int row, int col) {
if (row >= 0 && row < 8 && col >= 0 && col < 8) {
board[row][col] = piece;
}
}

private:
std::vector<std::vector<char>> board; // 2D vector to represent the chess board
};

int main() {
ChessBoard chessBoard;
chessBoard.placePiece('K', 0, 4

Previous Next

DoSelect is a leading provider of innovative talent assessment and hiring solutions designed to help companies identify and hire top talent efficiently. With a focus on leveraging technology to streamline the recruitment process, DoSelect is revolutionizing the way organizations assess and evaluate candidates. At DoSelect, we offer a comprehensive suite of assessment tools and platforms that enable companies to evaluate candidates' skills, competencies, and cultural fit accurately. From coding assessments and technical challenges to behavioral interviews and cultural fit assessments, our solutions cover every aspect of the hiring process. One of the key strengths of DoSelect lies in our commitment to helping companies build high-performing teams. We understand that hiring the right talent is crucial for business success, and we provide the tools and insights companies need to make informed hiring decisions. Our innovative assessment platforms and customizable solutions empower companies to identify candidates who not only possess the right skills but also align with their organization's values and culture. Furthermore, DoSelect is dedicated to providing a seamless and user-friendly experience for both candidates and hiring managers. Our intuitive platforms and user-friendly interfaces make it easy for candidates to showcase their skills and for hiring managers to evaluate candidates efficiently. In conclusion, DoSelect is more than just a talent assessment company – we're a strategic partner for companies looking to build high-performing teams. With our innovative solutions, commitment to customer success, and dedication to enhancing the hiring process, we are revolutionizing the way companies identify and hire top talent.

Find Interview Questions for Doselect

What makes Takluu valuable for interview preparation?

Get Our Mobile App

Programming

Reasoning

Network & Telecom

Management

What makes Takluu valuable for interview preparation?