Best Value Chem HR Executive Interview Questions and Answers

Q1. General questions
Add your answer

Q1. Technical Test and product test
Add your answer

Q1. Deep knowledge of Market
Add your answer

Tricky questions from js, sql, c#

Q1. Uses of B Tree
Ans. 
B Trees are used for indexing in databases and file systems.
• Used for efficient searching, insertion, and deletion operations in databases.

• Helps in maintaining sorted data for quick retrieval.

• Commonly used in file systems to store large amounts of data efficiently.

• Each node in a B Tree can have multiple children, reducing the height of the tree.
Answered by AI
Add your answer
Q2. What is CTE in sql
Ans. 
CTE stands for Common Table Expression in SQL, used to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTEs improve readability and maintainability of complex queries

• CTEs can be recursive, allowing for hierarchical data querying

• CTEs are defined using the WITH keyword followed by the CTE name and query
Answered by AI
Add your answer

Q1. Program to reverse a linked list
Ans. 
Reverse a linked list by changing the next pointers of each node to point to the previous node.
• Start with three pointers: current, prev, and next.

• Iterate through the linked list, updating the next pointers to point to the previous node.

• Update prev, current, and next pointers in each iteration until the end of the list is reached.
Answered by AI
Add your answer
Q2. Puzzles from geeksforgeeks
Add your answer

Q1. General HR questions like difficulties, strength weakness etc.
Add your answer

Q1. What is your current role?
Ans. 
I am currently working as a Business Analyst at a technology company.
• Analyzing business processes and requirements

• Creating reports and dashboards for stakeholders

• Collaborating with cross-functional teams to gather and analyze data
Answered by AI
Add your answer
Q2. About basic finance
Add your answer

Q1. What is hedge fund?
Ans. 
A hedge fund is an investment fund that pools capital from accredited individuals or institutional investors and invests in a variety of assets.
• Hedge funds are typically only available to accredited investors due to their complex and risky nature.

• They often use leverage and derivatives to amplify returns.

• Hedge funds charge both a management fee and a performance fee based on the fund's profits.

• They can invest in a wide...read more
Answered by AI
Add your answer
Q2. What are derivatives ?
Ans. 
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
• Derivatives can be used for hedging, speculation, or arbitrage.

• Common types of derivatives include options, futures, forwards, and swaps.

• Derivatives allow investors to take positions on the price movements of assets without owning the assets themselves.

• They are often used to manage risk in financial markets.

• Derivati...read more
Answered by AI
Add your answer

Q1. Why do you wan to change?
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for professional growth and development

• Interest in exploring new industries or sectors

• Seeking a more collaborative work environment

• Opportunity to work on more impactful projects

• Desire for better work-life balance
Answered by AI
Add your answer
Q2. Salary discussion
Add your answer

Q1. What is arrow function in JS
Ans. 
Arrow functions are a concise way to write functions in JavaScript.
• Arrow functions have a shorter syntax compared to regular functions.

• They do not have their own 'this' keyword, and instead inherit 'this' from the parent scope.

• Arrow functions are best suited for non-method functions, and cannot be used as constructors.

• Example: const add = (a, b) => a + b;
Answered by AI
View 1 more answer
Q2. What is runtime polymerphism
Ans. 
Runtime polymorphism is the ability of a subclass to override a method from its superclass during runtime.
• Runtime polymorphism is achieved through method overriding in object-oriented programming.

• It allows a subclass to provide a specific implementation of a method that is already defined in its superclass.

• The actual method called is determined by the type of object at runtime.

• Example: Animal class has a method 'makeSo...read more
Answered by AI
Add your answer
Q3. What is abstraction in oops
Ans. 
Abstraction in OOP is the concept of hiding complex implementation details and showing only the necessary features to the outside world.
• Abstraction allows us to focus on what an object does rather than how it does it

• It helps in reducing complexity and improving maintainability of code

• Example: A car is an abstraction of various components like engine, wheels, etc. Users interact with the car without needing to know the ...read more
Answered by AI
Add your answer

DSA questions Reverse the linkedlist

Q1. Explain your project
Add your answer
Q2. He asked two SQL queries
Add your answer

Only DSa and aptitude was asked

Q1. Brief about previous work experience
Add your answer
Q2. Questions regarding technical knowledge
Add your answer

Q1. Discussion regarding salary
Add your answer

Q1. What is the concrete
Ans. 
Concrete is a strong and durable building material made from a mixture of cement, sand, gravel, and water.
• Concrete is commonly used in construction for buildings, roads, bridges, and more

• It is known for its strength, durability, and versatility

• The ingredients of concrete include cement, sand, gravel, and water

• Concrete can be poured into molds to create various shapes and structures
Answered by AI
Add your answer
Q2. How admixture work in concrete and different type of admixture and its uses.
Ans. 
Admixtures are added to concrete to alter its properties or enhance its performance. They can improve workability, durability, and strength.
• Admixtures are added to concrete during mixing to modify its properties.

• Types of admixtures include water-reducing, air-entraining, accelerating, retarding, and plasticizers.

• Water-reducing admixtures improve workability and reduce water content.

• Air-entraining admixtures create smal...read more
Answered by AI
Add your answer
Q3. Properties of construction materials
Ans. 
Construction materials have various properties that affect their performance and durability.
• Strength: Ability to withstand loads without breaking or deforming (e.g. concrete, steel)

• Durability: Resistance to wear, weathering, and deterioration over time (e.g. brick, stone)

• Density: Mass per unit volume, affects weight and insulation properties (e.g. wood, foam)

• Thermal conductivity: Ability to conduct heat, important for ...read more
Answered by AI
Add your answer
Q4. How to do mix design for different grade.
Ans. 
Mix design for different grade involves determining the proportions of materials to achieve desired concrete properties.
• Identify the required grade of concrete based on project specifications.

• Select suitable materials such as cement, aggregates, and water.

• Calculate the mix proportions based on desired strength and workability.

• Perform trial mixes and adjust proportions as needed.

• Test the concrete for desired properties ...read more
Answered by AI
Add your answer

Q1. Expected salary and Prevoius salary details
Add your answer
Q2. For how long you will associate with company
Add your answer