BPTP Senior MIS Analyst Interview Questions and Answers for Experienced

Q1. What are joins and its types?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer

Q1. RCC Mivon shuttering experience?
Ans. 
RCC Mivon shuttering experience involves using reinforced concrete construction techniques for formwork and scaffolding.
• Experience in setting up formwork and scaffolding for reinforced concrete structures

• Knowledge of RCC Mivon shuttering techniques and materials

• Ability to interpret construction drawings and plans for RCC Mivon shuttering

• Experience in coordinating with construction teams and contractors for RCC Mivon sh
Answered by AI
View 1 more answer
Q2. Finishing work experience?
Add your answer
Q3. Yes , I have. I told them about my job profile. They asked me 4- 5 questions related to work , which I answered well. But not recieved any response later.
Add your answer

Ppt preparation on real estate on deck making skills

Q1. About you previous job
Add your answer
Q2. About data and stuff , excel and analytics skill and power BI
Add your answer

Q1. Ask about work specific technical questions
Add your answer
Q2. Discuss on job profile , qualifications and basis
Add your answer

Q1. Salary and family discussions
Add your answer

Q1. Slab cycle of aluminium shuttering
Ans. 
The slab cycle of aluminium shuttering refers to the process of using aluminium formwork for casting slabs in construction projects.
• Aluminium shuttering is lightweight and durable, making it ideal for repetitive use in slab construction.

• The slab cycle involves setting up the aluminium formwork, pouring concrete, allowing it to cure, and then dismantling the formwork for reuse.

• Aluminium shuttering can be easily assemble...read more
Answered by AI
Add your answer

Q1. Why do you want to change the company?
Ans. 
I am seeking new challenges and growth opportunities that align with my career goals.
• Looking for a company that values innovation and creativity

• Seeking a role with more responsibility and leadership opportunities

• Interested in expanding my skill set and learning from new experiences

• Desire to work for a company with a strong reputation and positive culture

• Current company lacks growth opportunities and does not align with
Answered by AI
View 1 more answer
Q2. What is your CTC expectation?
Ans. 
My CTC expectation is in line with industry standards and commensurate with my experience and skills.
• I have researched the industry standards for Assistant Manager roles and have a realistic expectation.

• My expectation is based on my experience and skills, which I believe add value to the role.

• I am open to negotiation and willing to discuss the compensation package.

• I am more interested in the growth opportunities and ch
Answered by AI
View 1 more answer