Upload Button Icon Add office photos

Filter interviews by

Asa International india Microfinance DBA Consultant Interview Questions and Answers

Updated 23 Sep 2024

Asa International india Microfinance DBA Consultant Interview Experiences

1 interview found

DBA Consultant Interview Questions & Answers

user image Rofiq Ahmed

posted on 23 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How do you perform database backup and restoration in MSSQL?
  • Ans. 

    Performing MSSQL database backup and restoration involves using SQL Server Management Studio or T-SQL commands.

    • Use SQL Server Management Studio to perform backup and restoration tasks.

    • For backup, right-click on the database, select Tasks, then Backup. Choose the backup type, destination, and options.

    • For restoration, right-click on Databases, select Restore Database. Choose the source, destination, and options.

    • Alternati...

  • Answered by AI
  • Q2. How do you optimize a slow-running query?
  • Ans. 

    Optimizing a slow-running query involves identifying bottlenecks and making adjustments to improve performance.

    • Identify the root cause of the slow query by analyzing execution plans

    • Consider creating or modifying indexes to improve data retrieval

    • Optimize the query itself by rewriting it to be more efficient

    • Update statistics on tables involved in the query to help the query optimizer make better decisions

    • Consider partiti

  • Answered by AI

Interview questions from similar companies

I applied via Approached by Company and was interviewed before Aug 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

General questions relating to mutual funds, simple maths and business module.

Round 2 - One-on-one 

(1 Question)

  • Q1. Make sure you are strong with communication and address your plans and strategy for business development. Accept all the tasks and responsibilities with yes sir, so that the manager gets a good feel.
Round 3 - HR 

(1 Question)

  • Q1. Always ask for hike against the proposed CTC . Hr always takes your side here because it's business development and he knows you will have to be paid well to generate business.

Interview Preparation Tips

Interview preparation tips for other job seekers - Speak with confidence, agree to tasks and responsibilities.

I applied via LinkedIn and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. String manipulation code

Interview Preparation Tips

Interview preparation tips for other job seekers - Be careful to answer to the point

Interview Questionnaire 

1 Question

  • Q1. It was mostly about the instrument reference data and typical business analyst question about change management, BRD, Agile and technology we use.

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Coding questions with system design questions and puzzles were asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your resume up to date. Do not add unnecessary stuff to your resume else they will easily catch you. Be as real as yo can. You should know some languages of your interest and should have relevant work experience in that.

I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - Group Discussion 

Economy of India - Current issues, Strength, Weakness,Opportunities, Threats of Indian Economy

Round 2 - HR 

(1 Question)

  • Q1. About self, Family, Education, Why I SEC

Interview Preparation Tips

Interview preparation tips for other job seekers - Financial knowledge & Some Finance Certification will add value

I appeared for an interview before May 2016.

Interview Questionnaire 

6 Questions

  • Q1. What is Debt Market ?
  • Ans. 

    Debt market refers to the financial market where investors buy and sell debt securities, such as bonds and loans.

    • Debt market is a part of the capital market where debt securities are traded.

    • It provides a platform for companies, governments, and individuals to borrow or lend money.

    • Debt securities include bonds, treasury bills, commercial papers, and mortgage-backed securities.

    • Investors in the debt market earn interest o...

  • Answered by AI
  • Q2. Different way of investment ?
  • Ans. 

    Different ways of investment include stocks, bonds, real estate, mutual funds, and commodities.

    • Stocks: Buying shares of a company

    • Bonds: Investing in debt securities

    • Real Estate: Purchasing properties for rental income or capital appreciation

    • Mutual Funds: Pooling money with other investors to invest in a diversified portfolio

    • Commodities: Investing in physical goods like gold, oil, or agricultural products

  • Answered by AI
  • Q3. What is SIP ?
  • Ans. 

    SIP stands for Session Initiation Protocol.

    • SIP is a signaling protocol used for initiating, modifying, and terminating real-time sessions between two or more participants over an IP network.

    • It is commonly used for voice and video calls, instant messaging, and multimedia conferences.

    • SIP enables the establishment of communication sessions and the negotiation of session parameters.

    • It works in conjunction with other protoc...

  • Answered by AI
  • Q4. What is mutual Fund?
  • Ans. 

    A mutual fund is a type of investment vehicle that pools money from multiple investors to invest in a diversified portfolio of securities.

    • Mutual funds are managed by professional fund managers.

    • Investors buy shares of the mutual fund, which represent their ownership in the fund's assets.

    • Mutual funds offer diversification, as they invest in a variety of stocks, bonds, or other securities.

    • They provide small investors acce...

  • Answered by AI
  • Q5. Introduce your self?
  • Ans. 

    I am a motivated and enthusiastic individual seeking an internship opportunity.

    • I have a strong academic background in my field of study.

    • I have gained practical experience through internships or projects.

    • I possess excellent communication and teamwork skills.

    • I am eager to learn and contribute to the organization.

    • I am passionate about the industry and have a clear career goal.

  • Answered by AI
  • Q6. Tell me about your past job ? (if experienced)
  • Ans. 

    I worked as a software developer at XYZ company.

    • Developed and maintained software applications

    • Collaborated with a team to meet project deadlines

    • Implemented new features and resolved bugs

    • Participated in code reviews and testing

    • Worked with technologies such as Java, SQL, and JavaScript

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Students with the career of 60% and above were selected for the process.

Round: Group Discussion
Experience: GD was initiated by me by giving a brief description about the topics and welcoming every one on the dice to share their views, I was very particular at not selecting any side yet, my focus was just to highlight myself by starting the topic and than collecting facts from other.
Later on I kept my points strongly with facts and examples and also made others believe at my point.
Tips: Mantra For GD
Opening Speech
Control the GD by adding points in middle
Finish the discussion by giving the final thoughts.

Always remember its a discussion not a debate, make notes of other points it will help you to collect few more points and it will always come handy while giving the final thoughts about the topic.
Duration: 15 minutes

Round: Company Briefing
Experience: After GD the selected student were told about the company what it dose, how it functions, what we expect from an Intern.

Round: Technical + HR Interview
Experience: You have to be well aware of the finance terms and norms, different market and financial tool, initial marketing terms, each interview lasted for 15-20 min, where they selected students on the basic of his/her fluency in English and knowledge about the subject.
Tips: Go through Financial Service, balance Sheet, current market scenario,
current exchange ratio.

Skills: Finance Basics, Finance Current Affairs, Proficiency In English, Knowledge About Industries
College Name: KIIT University

I appeared for an interview in Apr 2017.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself?
  • Ans. 

    I am a recent graduate with a degree in Computer Science and a passion for coding and problem-solving.

    • Recent graduate with a degree in Computer Science

    • Passionate about coding and problem-solving

    • Experience with programming languages like Java, Python, and C++

    • Completed internships at tech companies such as Google and Microsoft

  • Answered by AI

Interview Preparation Tips

Round: HR Interview
Experience: I told them about my education; skills etc
Tips: Give brief and crsip information

College Name: PCTE ludhiana

I appeared for an interview in May 2017.

Interview Questionnaire 

2 Questions

  • Q1. Why do you want to intern with us?
  • Ans. 

    I am passionate about your industry and eager to gain hands-on experience in a professional setting.

    • Passionate about the industry

    • Eager to gain hands-on experience

    • Desire to learn from professionals

  • Answered by AI
  • Q2. Why do you think you have an interest in financial planning?
  • Ans. 

    I have always been fascinated by the intricate world of finance and enjoy helping others make informed decisions about their money.

    • I have a strong aptitude for numbers and analysis

    • I enjoy researching and staying up-to-date on financial trends

    • I find satisfaction in helping others achieve their financial goals

    • I believe financial planning is crucial for long-term stability and success

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: This is one of the important steps and it should be eye catching.
Tips: List all your achievments and experiences.

Round: HR Interview
Tips: Be confident and show keen interest in learning

College Name: Keshav Mahavidyalaya

Analyst Interview Questions & Answers

Wells Fargo user image SNEHA KUMARI SHARMA

posted on 1 Jun 2017

I appeared for an interview in Aug 2016.

Interview Questionnaire 

11 Questions

  • Q1. Basics of programming language
  • Q2. Basics of programming language
  • Q3. Microprocessor basics
  • Q4. Logic of traffic light functionality
  • Ans. 

    Traffic lights use a set sequence of colors to control the flow of vehicles and pedestrians.

    • Traffic lights use red, yellow, and green lights to indicate when vehicles and pedestrians should stop, slow down, or go.

    • The sequence of colors is typically red, yellow, green, and then back to red.

    • Different traffic lights may have different timings for each color depending on the traffic flow and pedestrian activity.

    • Traffic lig...

  • Answered by AI
  • Q5. Logic of elevator operation
  • Ans. 

    The logic of elevator operation involves a system of sensors, controls, and algorithms to efficiently transport passengers between floors.

    • Elevators use sensors to detect the presence of passengers and determine their desired floor.

    • Controls process this information and calculate the most efficient route for the elevator to take.

    • Algorithms prioritize elevator assignments based on factors like proximity, floor traffic, an...

  • Answered by AI
  • Q6. Coding on paper.
  • Q7. How was the technical I review experience
  • Q8. How was the technical I review experience
  • Q9. Why wells Fargo?
  • Ans. 

    Wells Fargo is a reputable and established financial institution with a strong track record in the industry.

    • Wells Fargo has a long history dating back to 1852, making it one of the oldest and most established banks in the United States.

    • The company has a strong reputation for providing a wide range of financial services, including banking, investments, and insurance.

    • Wells Fargo has a large network of branches and ATMs, ...

  • Answered by AI
  • Q10. Comments on the moto of the company
  • Q11. General questions related to resume included details.

Interview Preparation Tips

Round: Test
Experience: Computer based Test
Enrollment round
Followed with other test rounds with one minute timer for each question.
Tips: Be quick,still careful.
Time management is the key to score.

Total Questions: 75

Round: Technical Interview
Experience: Computer based Test
Enrollment round
Followed with other test rounds with one minute timer for each question.
Tips: Be quick,still careful.
Time management is the key to score.


Round: Technical Interview
Experience: A general introduction of oneself.Hobbies and inclination towards IT sector job and why wells Fargo followed by different subject knowledge and basics .

Tips: Be confident.
Revise coding basics.
Know your microprocessor basics.
Be frank to say if u are unable to recall an answer at that moment.


College Name: Sikkim Manipal University

Asa International india Microfinance Interview FAQs

How many rounds are there in Asa International india Microfinance DBA Consultant interview?
Asa International india Microfinance interview process usually has 1 rounds. The most common rounds in the Asa International india Microfinance interview process are Technical.
What are the top questions asked in Asa International india Microfinance DBA Consultant interview?

Some of the top questions asked at the Asa International india Microfinance DBA Consultant interview -

  1. How do you perform database backup and restoration in MSS...read more
  2. How do you optimize a slow-running que...read more

Tell us how to improve this page.

Asa International india Microfinance DBA Consultant Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 580 Interviews
Bajaj Finserv Interview Questions
4.0
 • 538 Interviews
ICICI Securities Interview Questions
3.9
 • 163 Interviews
Sharekhan Interview Questions
3.8
 • 85 Interviews
Bajaj Capital Interview Questions
3.8
 • 81 Interviews
View all
Branch Manager
33 salaries
unlock blur

₹1.8 L/yr - ₹3.5 L/yr

Loan Officer
11 salaries
unlock blur

₹0.8 L/yr - ₹2.1 L/yr

Senior Loan Officer
9 salaries
unlock blur

₹1.2 L/yr - ₹2.5 L/yr

Chief Internal Auditor
4 salaries
unlock blur

₹17.3 L/yr - ₹21 L/yr

Assistant Branch Manager
4 salaries
unlock blur

₹1.7 L/yr - ₹2.1 L/yr

Explore more salaries
Compare Asa International india Microfinance with

Bajaj Finserv

4.0
Compare

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

Motilal Oswal Financial Services

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview