Upload Button Icon Add office photos

Filter interviews by

State Bank of India Assistant System Manager Interview Questions and Answers for Experienced

Updated 30 Jan 2022

State Bank of India Assistant System Manager Interview Experiences for Experienced

1 interview found

I applied via came up in google feed and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. The question asked were based on the basics of the technologies that you have worked on.
  • Q2. What is the difference between delete and truncate
  • Ans. 

    Delete removes specific rows from a table while truncate removes all rows from a table.

    • Delete is a DML command while truncate is a DDL command.

    • Delete is slower than truncate as it logs each row deletion while truncate does not.

    • Delete can be rolled back while truncate cannot be rolled back.

    • Delete can have a WHERE clause to specify which rows to delete while truncate deletes all rows.

    • Delete does not reset the identity of...

  • Answered by AI
  • Q3. Why should we use nodejs has over java
  • Ans. 

    Node.js is faster, more scalable, and easier to learn than Java.

    • Node.js is built on Chrome's V8 JavaScript engine, which is faster than Java's JVM.

    • Node.js uses an event-driven, non-blocking I/O model, making it more scalable than Java.

    • Node.js has a simpler and more intuitive syntax, making it easier to learn than Java.

    • Node.js has a large and active community, with many open-source libraries and frameworks available.

    • Jav...

  • Answered by AI
  • Q4. What is the latest version of oracle
  • Ans. 

    The latest version of Oracle is Oracle Database 21c.

    • Oracle Database 21c was released in January 2021.

    • It includes new features such as blockchain tables and persistent memory support.

    • It also has improved security and performance enhancements.

    • Previous versions include Oracle Database 19c and Oracle Database 18c.

  • Answered by AI
  • Q5. What is namespace in python
  • Ans. 

    Namespace is a way to organize code and avoid naming conflicts in Python.

    • A namespace is a mapping between names and objects.

    • Python uses namespaces to avoid naming conflicts and to provide a way to access objects.

    • Namespaces can be nested, and objects can be accessed using dot notation.

    • Python has built-in namespaces, such as the global namespace and local namespace.

    • Modules and classes also have their own namespaces.

  • Answered by AI
  • Q6. Sql vs nosql database
  • Ans. 

    SQL databases are relational and structured, while NoSQL databases are non-relational and unstructured.

    • SQL databases use tables with predefined schema, while NoSQL databases use documents, key-value pairs, or graphs.

    • SQL databases are better suited for complex queries and transactions, while NoSQL databases are better for handling large amounts of unstructured data.

    • Examples of SQL databases include MySQL, Oracle, and Po...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview is going to revolve around your CV. The panel comprises of senior managers not developers. They are like generalist of software development field( having working understanding of many technology and deep knowledge of none ). So the interview is going to revolve around comparing various technologies( sql vs nosql, java vs node ) asking about latest versions( oracle latest version, react latest version, angular version, css etc ) and some generic cs questions like delete vs truncate in sql. Prepare accordingly.

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about State Bank of India?
Ask anonymously on communities.

Interview questions from similar companies

Interview Preparation Tips

Round: Resume Shortlist
Experience: Initial shortlisting was based on resume where CGPA cutoff was around 8.

Round: Test
Experience: Questions were related to Data interpretation and Aptitude,which mostly tests a person's patience too.Around 20-25 were shortlisted after this round.

Round: Case Study Interview
Experience: Questions relating to case studies and course done in your maths were asked.

Round: HR Interview
Experience: In this round,the candidate was asked to talk about himself, his qualities and mostly the activities he was involved in the past 4-5 years of his life.

Skill Tips: A proper revision of math courses will also be useful during interviews and can do much better by having preparation in case studies.
Skills: Good communication skills
College Name: IIT MADRAS

Assistant System Manager Interview Questions Asked at Other Companies for Experienced

Q1. What is the difference between DELETE and TRUNCATE?
Q2. What is the latest version of Oracle?
Q3. Why should we use Node.js over Java?
Q4. What is a namespace in Python?
Q5. sql vs nosql database

I appeared for an interview before Sep 2019.

Interview Questionnaire 

8 Questions

  • Q1. 1 tell me about your self?
  • Ans. 

    I am a dedicated professional with a strong background in project management and a passion for continuous learning and teamwork.

    • Education: Graduated with a degree in Business Administration from XYZ University, where I developed strong analytical skills.

    • Experience: Worked as a project coordinator at ABC Company, successfully managing multiple projects and improving team efficiency by 20%.

    • Skills: Proficient in Microsoft...

  • Answered by AI
  • Q2. Why you want work at this company?
  • Q3. Why should I hire you?
  • Ans. 

    I bring a unique blend of skills, experience, and passion that aligns perfectly with your team's goals and values.

    • Proven track record of success in previous roles, such as increasing sales by 20% in my last position.

    • Strong analytical skills demonstrated through data-driven decision-making in project management.

    • Excellent communication abilities, evidenced by leading cross-functional teams to achieve project milestones.

    • A...

  • Answered by AI
  • Q4. If you are experience person----why are you looking for a job company change?
  • Q5. What are your salary requirements?
  • Q6. What is your ambition?
  • Ans. 

    My ambition is to grow as a professional, contribute meaningfully, and lead innovative projects that make a positive impact.

    • I aspire to take on leadership roles, guiding teams to success, like leading a project that improved efficiency by 30%.

    • I aim to continuously learn and adapt, pursuing certifications in my field to stay ahead of industry trends.

    • I want to mentor others, sharing knowledge and experiences to help them...

  • Answered by AI
  • Q7. How could be you contribute to our company if you're selected?
  • Ans. 

    I can leverage my skills and experience to drive innovation, enhance team collaboration, and contribute to achieving company goals.

    • Utilize my analytical skills to identify market trends and inform strategic decisions, as I did in my previous role by increasing sales by 20%.

    • Foster a collaborative team environment by organizing regular brainstorming sessions, similar to initiatives that improved project delivery times in...

  • Answered by AI
  • Q8. Finally do you have any questions to ask me

Interview Preparation Tips

Interview preparation tips for other job seekers - * Research the industry and company
* Clarify your are selling points ex:-(good
communication skills)
* And reason you the job
* Prepare for common interview questions
* Practice---practice---practice and be confident
At the time of interview time.

Interview Questionnaire 

1 Question

  • Q1. SAS ,SQl knowledge

I applied via Campus Placement and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. I was asked 3 Guesstimates. They weren't that difficult. They only wanted to see the process I took to get to the answer. The answer need not be correct.
  • Q2. They asked me what I thought about team work and how every team member's contribution is needed for the success of the project.
  • Q3. I talked about my work ex in Tableau so they asked what kind of work I did there.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare few Guesstimates before going to the interview. Also it would benefit If you can provide an experience with the analytical tools you have mentioned in the resume. It really helps.

Interview Questionnaire 

2 Questions

  • Q1. Salary expectations
  • Q2. Industry standards

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

Interview Questionnaire 

6 Questions

  • Q1. SQL JOINS
  • Q2. Python Packages
  • Ans. 

    Python packages are pre-written code libraries that can be imported and used in Python programs.

    • Packages contain modules, which contain functions and classes

    • Packages can be installed using pip or conda

    • Popular packages include NumPy, Pandas, and Matplotlib

  • Answered by AI
  • Q3. Python Projects mentioned in the resume
  • Q4. Basic HR questions
  • Q5. Puzzles
  • Q6. Basics about loans default in banking

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Calm and composed and go through your resume properly.
Revise SQL, SAS, and Python if you are targeting a role in the business intelligence unit of axis bank
Are these interview questions helpful?

I applied via Naukri.com and was interviewed before Sep 2021. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Purely on SSIS and SQL server
  • Q2. Performance Tuning,Scheduling , Deployment related questions.
Round 3 - Technical 

(1 Question)

  • Q1. About Previous Projects and SSIS scenario based questions.
Round 4 - One-on-one 

(1 Question)

  • Q1. About the company policies
Round 5 - HR 

(1 Question)

  • Q1. Discussion on Salary Front.

Interview Preparation Tips

Topics to prepare for IDFC FIRST Bank Business Analyst interview:
  • Performance Tuning
Interview preparation tips for other job seekers - Prepare well for technical interview .
There will be direct questions and scenario based questions as well.

I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Q2. What do you know about banking/credit cards
  • Ans. 

    Banking involves managing financial transactions, while credit cards allow users to borrow money for purchases.

    • Banking involves depositing and withdrawing money, managing accounts, and providing loans.

    • Credit cards allow users to borrow money for purchases and pay it back with interest.

    • Credit cards often come with rewards programs or cash back incentives.

    • Credit card debt can accumulate quickly and lead to financial diff...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Telephonic interview and face to face interview was taken. Overall smooth interview process, and asked about credit cards and banking industry for interview questions

Interview Questionnaire 

1 Question

  • Q1. Technical knowledge about SQL database knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest with your answers don't bluff the interviewers

State Bank of India Interview FAQs

What are the top questions asked in State Bank of India Assistant System Manager interview for experienced candidates?

Some of the top questions asked at the State Bank of India Assistant System Manager interview for experienced candidates -

  1. what is the difference between delete and trunc...read more
  2. why should we use nodejs has over j...read more
  3. what is the latest version of ora...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.6k Interviews
HDFC Bank Interview Questions
3.9
 • 2.5k Interviews
Axis Bank Interview Questions
3.7
 • 1.7k Interviews
IDFC FIRST Bank Interview Questions
3.9
 • 759 Interviews
IndusInd Bank Interview Questions
3.5
 • 678 Interviews
Bandhan Bank Interview Questions
3.7
 • 633 Interviews
Yes Bank Interview Questions
3.7
 • 478 Interviews
View all
State Bank of India Assistant System Manager Salary
based on 45 salaries
₹7.6 L/yr - ₹18 L/yr
13% more than the average Assistant System Manager Salary in India
View more details

State Bank of India Assistant System Manager Reviews and Ratings

based on 13 reviews

3.4/5

Rating in categories

2.7

Skill development

3.7

Work-life balance

3.8

Salary

4.9

Job security

2.5

Company culture

2.1

Promotions

2.9

Work satisfaction

Explore 13 Reviews and Ratings
Manager
560 salaries
unlock blur

₹17.1 L/yr - ₹30 L/yr

Deputy Manager
548 salaries
unlock blur

₹13.3 L/yr - ₹20.1 L/yr

Assistant Manager
520 salaries
unlock blur

₹9.8 L/yr - ₹18 L/yr

Chief Manager
379 salaries
unlock blur

₹14 L/yr - ₹60 L/yr

Relationship Manager
312 salaries
unlock blur

₹3.3 L/yr - ₹16 L/yr

Explore more salaries
Compare State Bank of India with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

3.7
Compare

Kotak Mahindra Bank

3.7
Compare
write
Share an Interview