Find Interview Questions for Top Companies
Ques:- How do you eliminate duplicate values in DB2 SELECT ?
Asked In :- trifacta, tractable,
Right Answer:
You can eliminate duplicate values in a DB2 SELECT statement by using the `DISTINCT` keyword. For example:

```sql
SELECT DISTINCT column_name FROM table_name;
```
Ques:- A userdefined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.
Right Answer:
The user-defined name that serves as the anchor for packages is called a "collection." In SPUFI, if you want to select a maximum of 1000 rows but only get 200 rows, it means that the query returned fewer rows than the specified limit due to the actual data available.
Ques:- How to replace particular string.For example:- suppose their are 1000 of records for email-id.like tarun.it@hotmail.com..but i want to replace the only hotmail.com for all email-ids not the user name(tarun.it) with yahoo.com.
Right Answer:
You can use the `REPLACE` function in SQL Server to replace "hotmail.com" with "yahoo.com" in the email addresses. Here’s the SQL query:

```sql
UPDATE your_table_name
SET email_column = REPLACE(email_column, 'hotmail.com', 'yahoo.com')
WHERE email_column LIKE '%hotmail.com';
```
Ques:- You client is a large real estate development company considering buying a piece of real estate. How do you analyze the investment?
Right Answer:
To analyze the investment, I would:

1. **Conduct Market Research**: Assess the local real estate market trends, demand, and supply.
2. **Evaluate Financial Metrics**: Calculate key metrics such as ROI, cash flow, cap rate, and net present value (NPV).
3. **Perform Due Diligence**: Review property documents, zoning laws, and any potential legal issues.
4. **Assess Location**: Analyze the property's location for accessibility, amenities, and future development plans.
5. **Estimate Costs**: Consider acquisition costs, renovation expenses, and ongoing operational costs.
6. **Risk Analysis**: Identify potential risks and develop mitigation strategies.
7. **Consult Stakeholders**: Gather input from relevant stakeholders, including financial advisors and real estate experts.
Ques:- How will you sell a fridge to an Eskimo?
Right Answer:
I would focus on the unique features of the fridge, such as its ability to keep food fresh and organized, and emphasize how it can help store perishable items efficiently, making life easier and more convenient even in a cold environment.
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.
Ques:- You have been retained joint by a disposable diaper company and a federal commission on waste management. Estimate the volume percentage of disposable diapers in the total U.S. household garbage.
Right Answer:
Disposable diapers make up approximately 3-4% of total U.S. household garbage by volume.
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.
Ques:- What are some techniques used for defining scope?
Right Answer:
Some techniques used for defining scope include:

1. **Expert Judgment** - Consulting with stakeholders and experts to gather insights.
2. **Requirements Gathering** - Collecting detailed requirements through interviews, surveys, and workshops.
3. **Work Breakdown Structure (WBS)** - Breaking down the project into smaller, manageable components.
4. **Scope Statement** - Creating a formal document that outlines the project objectives, deliverables, and boundaries.
5. **Use Cases** - Defining specific scenarios to clarify requirements and expectations.
6. **Prototyping** - Developing a preliminary model to visualize and refine project requirements.
Ques:- Forming a team, developing the team and improving knowledge are direct responsibilities of the project manager, do you agree?
Right Answer:
Yes, I agree. Forming a team, developing the team, and improving knowledge are key responsibilities of a project manager.
Ques:- Experience of site management
Right Answer:
I have experience in site management, where I coordinated daily operations, supervised staff, ensured safety compliance, managed resources, and communicated with stakeholders to keep projects on schedule and within budget.
Ques:- What is ment by Onsite and Offshore Project.can any 1 explain me.
Right Answer:
Onsite projects are those where the work is done at the client's location, while offshore projects are conducted at a different location, often in another country, typically to take advantage of cost savings or specialized skills.
Ques:- Define a risk register?
Right Answer:
A risk register is a document that lists identified risks for a project, along with their assessment, mitigation strategies, and status. It helps project managers track and manage risks throughout the project lifecycle.
Ques:- What are beams, panels, experience etc?
Right Answer:
Beams are structural elements that support loads and span between supports, typically used in buildings and bridges. Panels refer to flat sections of materials, often used in walls or ceilings, that can provide structural support or aesthetic finishes. Experience in this context usually refers to practical knowledge and skills gained through working on projects involving beams and panels.
AmbitionBox Logo

What makes Takluu valuable for interview preparation?

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