Find Interview Questions for Top Companies
Ques:- All about ABB Drive and its PLC
Right Answer:
ABB Drives are variable frequency drives (VFDs) used to control the speed and torque of electric motors, enhancing energy efficiency and performance. They can be integrated with Programmable Logic Controllers (PLCs) for automation, allowing for precise control and monitoring of motor operations in various industrial applications. ABB PLCs, such as the AC500 series, provide the logic and control capabilities to manage processes, including communication with ABB Drives for optimized performance and automation.
Ques:- Operation of Drives & its functionality
Asked In :- TFT, SEAT,
Right Answer:
Drives are devices that control the speed, torque, and direction of electric motors. They convert electrical energy into mechanical energy and can be used in various applications such as conveyor systems, pumps, and fans. The functionality of drives includes starting and stopping the motor, adjusting speed, and providing protection features like overload and short-circuit protection.
Ques:- Difference between DWH and Data mart, Difference between views and materialized views. What is Indexing and which kind of Indexing Technique we use in
Right Answer:
**Difference between DWH and Data Mart:**
- A Data Warehouse (DWH) is a centralized repository that stores large volumes of data from multiple sources for analysis and reporting. A Data Mart is a subset of a Data Warehouse, focused on a specific business area or department.

**Difference between Views and Materialized Views:**
- A View is a virtual table that provides a way to present data from one or more tables without storing it physically. A Materialized View, on the other hand, stores the result of a query physically, allowing for faster access at the cost of needing to refresh the data periodically.

**Indexing:**
- Indexing is a database optimization technique that improves the speed of data retrieval operations on a database table. Common indexing techniques include B-tree indexing, hash indexing, and bitmap indexing.
Ques:- Full Life cycle of project, How to collect requirement and its Different phases and challenges.
Asked In :-
Right Answer:
The full life cycle of a project includes the following phases:

1. **Initiation**: Define the project, identify stakeholders, and develop a project charter.
2. **Planning**: Gather requirements through interviews, surveys, and workshops; create a project plan outlining scope, schedule, resources, and budget.
3. **Execution**: Implement the project plan, coordinate resources, and manage teams to deliver project outputs.
4. **Monitoring and Controlling**: Track progress, measure performance, and make adjustments as needed to stay on track.
5. **Closure**: Finalize all activities, obtain stakeholder acceptance, and conduct a post-project evaluation.

Challenges include unclear requirements, scope creep, resource constraints, and stakeholder communication issues.
Ques:- Difference between ETL and data mining, Types of Fact Table according to dimensional value, What is Factless Fact Table, Types of Dimension.
Right Answer:
**Difference between ETL and Data Mining:**
ETL (Extract, Transform, Load) is the process of collecting data from various sources, transforming it into a suitable format, and loading it into a data warehouse. Data mining, on the other hand, involves analyzing large datasets to discover patterns, trends, and insights.

**Types of Fact Table according to Dimensional Value:**
1. Transaction Fact Table
2. Periodic Snapshot Fact Table
3. Accumulating Snapshot Fact Table

**What is a Factless Fact Table:**
A Factless Fact Table is a fact table that does not contain any measurable facts or numeric data but captures events or conditions, often used to track many-to-many relationships or specific occurrences.

**Types of Dimension:**
1. Conformed Dimension
2. Slowly Changing Dimension (SCD)
3. Junk Dimension
4. Role-Playing Dimension
5. Degenerate Dimension
Ques:- What is BI, Which kind of modeling suitable for OLAP Reporting and WHY, Steps to create a Database,
Right Answer:
BI stands for Business Intelligence, which involves analyzing data to help make informed business decisions. For OLAP (Online Analytical Processing) reporting, a star schema or snowflake schema is suitable because they optimize query performance and simplify data retrieval.

Steps to create a database:
1. Define the purpose and requirements.
2. Design the schema (tables, relationships).
3. Choose a database management system (DBMS).
4. Create the database and tables using SQL.
5. Populate the database with data.
6. Implement indexing for performance.
7. Test the database for functionality and performance.
Ques:- What is CDC TECHNIQUE?, What is confirmed Dimension tell the scenario where u face, What is role playing Dimension, Types of Hierarchy
Right Answer:
CDC (Change Data Capture) technique is a method used to identify and capture changes made to data in a database, allowing for efficient data synchronization and updates in data warehousing.

A confirmed dimension is a dimension that is shared across multiple fact tables, ensuring consistency in reporting. For example, a "Customer" dimension can be confirmed across sales and returns fact tables.

A role-playing dimension is a dimension that can be used in multiple contexts within the same data model. For instance, a "Date" dimension can represent different roles like "Order Date," "Ship Date," and "Delivery Date."

Types of hierarchy include:
1. **Parent-Child Hierarchy**: A hierarchy where each member can have multiple children and a single parent.
2. **Level-Based Hierarchy**: A hierarchy where members are organized into levels, such as Year > Quarter > Month > Day.
Ques:- Roles and Responsibilities in current role
Asked In :-
Right Answer:
In my current role, my responsibilities include planning and executing projects, managing team members, ensuring timely delivery of project milestones, communicating with stakeholders, and monitoring project progress to meet objectives and budgets.
Ques:- Challenges faced and how you have handled
Asked In :-
Right Answer:
One challenge I faced was managing a project with a tight deadline and limited resources. To handle this, I prioritized tasks, delegated responsibilities effectively, and maintained open communication with the team. I also set up regular check-ins to monitor progress and adjust plans as needed, which helped us meet the deadline successfully.
Ques:- Achievement so far in career
Asked In :-
Right Answer:
One of my key achievements in my career has been successfully leading a cross-functional team to complete a major project ahead of schedule and under budget, resulting in a 20% increase in client satisfaction and a 15% boost in revenue for the company.
Ques:- My requirement is like this :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM
Asked In :- knapp ag, bloomreach, caas,
Right Answer:
To implement the required codification for your files, you should name them as follows:

- For sale header files: `SALE_HEADER_XXXXX_YYYYMMDD.PSV`
- For sale line files: `SALE_LINE_XXXXX_YYYYMMDD.PSV`

Where `XXXXX` is the LVM sequence for uniqueness and continuity, and `YYYYMMDD` represents the date in the format of year, month, and day.
Ques:- The system runs at Intranet environment and it has a security system. The security system's architecture designed on User and Role system. There are only one system Role and that is System Amdin Role and user can also create as many role as he needs.
Right Answer:
The security system allows for a single predefined role (System Admin) while enabling users to create multiple custom roles as needed for their specific requirements.
Ques:- How to test a application in flash?
Right Answer:
To test a Flash application, follow these steps:

1. **Set Up Testing Environment**: Ensure you have the necessary tools like Adobe Flash Player and a testing framework (e.g., Selenium, TestComplete).

2. **Functional Testing**: Verify that all features work as intended by interacting with the application and checking for expected outcomes.

3. **Performance Testing**: Assess the application's load time and responsiveness under various conditions.

4. **Compatibility Testing**: Test the application across different browsers and devices to ensure consistent performance.

5. **Usability Testing**: Evaluate the user interface for ease of use and accessibility.

6. **Security Testing**: Check for vulnerabilities, such as data exposure and injection flaws.

7. **Automated Testing**: Use automation tools to run repetitive tests efficiently.

8. **Bug Reporting**: Document any issues found during testing and communicate them to the development team for resolution.
Ques:- * What are constraints and derivation?* Explain the process of taking backup in DataStage?*What are the different types of lookups available in DataStage?
Right Answer:
**Constraints and Derivation:**
- **Constraints** are rules that limit the type of data that can be entered into a database, ensuring data integrity (e.g., primary key, foreign key, unique, check constraints).
- **Derivation** refers to the process of calculating or transforming data values based on existing data, often using expressions or formulas in DataStage.

**Backup Process in DataStage:**
1. Stop the DataStage services.
2. Backup the DataStage project directories and configuration files.
3. Backup the DataStage repository database (e.g., using database-specific backup tools).
4. Restart the DataStage services after the backup is complete.

**Types of Lookups in DataStage:**
1. **Static Lookup**: Uses a fixed set of data for lookups.
2. **Dynamic Lookup**: Allows for real-time data retrieval and can update the lookup table.
3. **Sparse Lookup**: Efficiently handles large datasets by only loading relevant data into memory.
Ques:- What are NP complete and NP hard problems?
Asked In :-
Right Answer:
NP-complete problems are a subset of NP problems that are as hard as the hardest problems in NP, meaning if you can solve one NP-complete problem quickly, you can solve all NP problems quickly. NP-hard problems are at least as hard as NP-complete problems but are not necessarily in NP; they may not have solutions that can be verified quickly.
Ques:- Given that an array consists of only 0s, 1s, and 2s, sort it. Again, only very efficient code was accepted. Good old counting sort was sneered at. He wanted an algo to do this in one pass of the algorithm without using any extra space, and which p…
Asked In :-
Right Answer:
You can use the Dutch National Flag algorithm to sort the array in one pass without using extra space. Here’s the code in Python:

```python
def sort_array(arr):
low, mid, high = 0, 0, len(arr) - 1
while mid <= high:
if arr[mid] == 0:
arr[low], arr[mid] = arr[mid], arr[low]
low += 1
mid += 1
elif arr[mid] == 1:
mid += 1
else: # arr[mid] == 2
arr[mid], arr[high] = arr[high], arr[mid]
high -= 1
return arr
```

This algorithm sorts the array in-place in O(n) time complexity.
Ques:- You are given a list of points in the plane, write a program that outputs each point along with the three other points that are closest to it. These three points ordered by distance. The order is less then O(n^2). For example, given a set of point…
Asked In :-
Right Answer:
To solve this problem efficiently, you can use a spatial data structure like a KD-Tree or a Ball Tree to organize the points in the plane. Here's a Python implementation using a KD-Tree:

```python
from scipy.spatial import KDTree

def closest_points(points):
# Build a KD-Tree from the list of points
tree = KDTree(points)
result = []

for point in points:
# Query the tree for the 3 closest points (excluding the point itself)
distances, indices = tree.query(point, k=4) # k=4 to include the point itself
closest = [(points[i], distances[i]) for i in indices if points[i] != point]
closest.sort(key=lambda x: x[1]) # Sort by distance
result.append((point, closest[:3])) # Get the 3 closest points

return result

# Example usage
points = [(1, 2),
Ques:- If a person dials a sequence of numbers on the telephone, what possible words/strings can be formed from the letters associated with those numbers?
Asked In :- asml,
Right Answer:
To find possible words or strings from a sequence of numbers dialed on a telephone, map each number to its corresponding letters based on the traditional phone keypad:

- 2: A, B, C
- 3: D, E, F
- 4: G, H, I
- 5: J, K, L
- 6: M, N, O
- 7: P, Q, R, S
- 8: T, U, V
- 9: W, X, Y, Z

For example, if the sequence is "23", the possible combinations are: AD, AE, AF, BD, BE, BF, CD, CE, CF.

To generate all possible combinations for a given sequence of numbers, use a recursive or iterative approach to combine the letters corresponding to each digit.
Ques:- There are N numbers from 1 to N and there a is game to be played that starting from 1 every second num wud be eliminated …. perform this until there wud be only single num remained … give an efficient algo to calculate which num will rem…
Asked In :-
Right Answer:
The last remaining number can be found using the formula:

If N is a power of 2, the result is 1. If not, let L be the largest power of 2 less than N. The last remaining number is given by:

Last number = 2 * (N - L) + 1.
Ques:- There is a row of houses in which each house contains some amount of money. Write an algorithm that loots the maximum amount of money from these houses. The only restriction is that you cannot loot two houses that are directly next to each other….
Asked In :- asml,
Right Answer:
To solve the problem of looting the maximum amount of money from houses without looting two adjacent houses, you can use dynamic programming. Here’s the algorithm:

1. Create an array `dp` where `dp[i]` represents the maximum amount of money that can be looted from the first `i` houses.
2. Initialize:
- `dp[0] = 0` (no houses to loot)
- `dp[1] = money[0]` (loot the first house)
3. For each house from the second to the last (i.e., from 2 to n):
- Calculate `dp[i] = max(dp[i-1], dp[i-2] + money[i-1])`
- `dp[i-1]` is the maximum money if the current house is not looted.
- `dp[i-2] + money[i-1]` is the maximum money if the current house is looted


The Project Leader / Project Manager category on takluu.com is tailored for professionals aspiring to manage and lead projects efficiently across industries. Whether you are stepping into your first managerial role or aiming for senior project leadership positions, this section equips you with the knowledge and interview readiness required to excel.

Project management is about much more than just scheduling tasks. It involves defining clear objectives, resource planning, risk assessment, stakeholder communication, quality control, and team motivation. Our curated content covers key project management methodologies like Waterfall, Agile, Scrum, and Kanban, along with essential tools such as MS Project, Jira, and Trello.

You will find detailed explanations of core concepts including scope management, time and cost estimation, risk management, conflict resolution, and performance monitoring. Real-world interview questions and scenario-based problems help you demonstrate your leadership skills and decision-making ability during interviews.

The section also highlights soft skills such as effective communication, negotiation, and team building — crucial traits for successful project leaders and managers. Additionally, we cover PMP certification topics and best practices aligned with industry standards.

Whether the interview focuses on technical project management or behavioral competencies, this category prepares you to answer with clarity and confidence.

At Takluu, we aim to transform your project management knowledge into practical skills and interview success. Start preparing today and lead your projects — and career — to new heights.

AmbitionBox Logo

What makes Takluu valuable for interview preparation?

1 Lakh+
Companies
6 Lakh+
Interview Questions
50K+
Job Profiles
20K+
Users