Upload Button Icon Add office photos

STAN Professionals

Compare button icon Compare button icon Compare

Filter interviews by

STAN Professionals Assistant Software Manager Interview Questions and Answers

Updated 19 Oct 2024

STAN Professionals Assistant Software Manager Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - SQL 

(2 Questions)

  • Q1. What is DDL command?
  • Ans. 

    DDL stands for Data Definition Language. It is used to define the structure of database objects.

    • DDL commands are used to create, modify, and delete database objects such as tables, indexes, and views.

    • Examples of DDL commands include CREATE, ALTER, and DROP.

    • DDL commands are not used to manipulate data within the database, that is done using DML (Data Manipulation Language) commands.

  • Answered by AI
  • Q2. Types of constraints..
  • Ans. 

    Types of constraints include primary key, foreign key, unique, check, and default constraints.

    • Primary key constraint ensures each row in a table is unique.

    • Foreign key constraint enforces referential integrity between two tables.

    • Unique constraint ensures that all values in a column are distinct.

    • Check constraint restricts the values that can be inserted into a column.

    • Default constraint provides a default value for a colu...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I want again this company work

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
6d (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about STAN Professionals?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Question based on oops java concept, logical reasoning, multithreading, data structures , collection, Servlet , ajax .

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basic concept knowledge based on core and advanced java

Give your answer in very confident mode .

Assistant Software Manager Interview Questions Asked at Other Companies

Q1. What is a DDL command?
Q2. Types of constraints..

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Core Java, SQL,JSP,Servlet
  • Q2. SQL Injection
  • Q3. Collection details
  • Q4. Rest API,Soap API

Interview Preparation Tips

Interview preparation tips for other job seekers - First Technical then Manager round (just project details)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - ZM And RM 

(1 Question)

  • Q1. Are you interested to do marketing...?
Round 3 - HR 

(1 Question)

  • Q1. Previous experience related queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared the nbfcs related queries
Round 1 - Technical 

(2 Questions)

  • Q1. Polymorphism, instance variables
  • Q2. Inheritance, array programs
Round 2 - HR 

(3 Questions)

  • Q1. What are your salary expectations?
  • Ans. 

    I expect a competitive salary based on my skills, experience, and industry standards, ideally in the range of $X to $Y.

    • Research industry standards: For example, Glassdoor or Payscale can provide insights into average salaries for similar roles.

    • Consider your experience: If you have 5 years of experience, you might expect a higher salary than someone just starting.

    • Location matters: Salaries can vary significantly based o...

  • Answered by AI
  • Q2. Why should we hire you?
  • Ans. 

    I bring a unique blend of technical skills, problem-solving abilities, and a passion for innovation that aligns with your team's goals.

    • Proven experience in developing scalable applications, such as a recent project where I improved system performance by 30%.

    • Strong collaboration skills demonstrated through successful teamwork on cross-functional projects, leading to timely delivery.

    • Continuous learner, recently completed...

  • Answered by AI
  • Q3. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself, nothing new just brush up core java
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Easy to moderate question

Round 2 - One-on-one 

(1 Question)

  • Q1. What is Axios? What is friend function? Given any array find the multiple elements?
  • Ans. 

    Axios is a popular JavaScript library used for making HTTP requests.

    • Axios is commonly used in frontend applications to communicate with backend servers.

    • It supports promises and can be used in both browser and Node.js environments.

    • Example: axios.get('https://api.example.com/data')

    • Friend function is a function that is not a member of a class but has access to its private and protected members.

    • It is declared with the keyw...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

We have a aptitude round where we have to be qualified for next coding round

Round 2 - Coding Test 

Coding round consist of 3 questions

Are these interview questions helpful?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
No response
Round 1 - Coding Test 

In the coding test two sum question was asked

Interview Questionnaire 

4 Questions

  • Q1. Life cycle of servlet and jsp
  • Ans. 

    Servlet and JSP life cycle involves initialization, request processing and destruction.

    • Servlet life cycle includes init(), service() and destroy() methods.

    • JSP life cycle includes translation, compilation, initialization, and request processing.

    • Servlet container manages the life cycle of servlets and JSPs.

    • Servlet and JSP objects are created and initialized during initialization phase.

    • During request processing phase, ser...

  • Answered by AI
  • Q2. Joins and basic SQL concept
  • Q3. Implementation of jdbc
  • Ans. 

    JDBC is a Java API for connecting to and interacting with databases.

    • JDBC stands for Java Database Connectivity.

    • It provides a standard interface for connecting to databases.

    • JDBC drivers are used to connect to specific databases.

    • JDBC can be used to execute SQL queries and retrieve results.

    • Example: Class.forName("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","userna...

  • Answered by AI
  • Q4. Puzzle questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic concepts of java ,servlet, jsp ,jdbc and javascript

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jan 2023. There were 4 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 - Aptitude Test 

General asked aptitude
Focus most on profit lost, percentage

Round 3 - One-on-one 

(1 Question)

  • Q1. Asked mostly on core java bcz i was selected for trainee role and JavaScript along with bootstrap
Round 4 - One-on-one 

(1 Question)

  • Q1. Asked DSA array, searching, sorting, linkedlist

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare yourself in java
Easy level of DSA
Servlet, jsp, jdbc
Spring and spring boot add advantage

STAN Professionals Interview FAQs

What are the top questions asked in STAN Professionals Assistant Software Manager interview?

Some of the top questions asked at the STAN Professionals Assistant Software Manager interview -

  1. What is DDL comma...read more
  2. Types of constraint...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4/5

based on 2 interview experiences

Manager
7 salaries
unlock blur

₹5.7 L/yr - ₹7.4 L/yr

Senior Executive
5 salaries
unlock blur

₹1.4 L/yr - ₹4 L/yr

Executive
5 salaries
unlock blur

₹1.8 L/yr - ₹2.9 L/yr

Executive Accountant
5 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Assistant Manager
4 salaries
unlock blur

₹4.5 L/yr - ₹7.2 L/yr

Explore more salaries
Compare STAN Professionals with

Karvy Financial Services

3.9
Compare

Reliance Money

3.5
Compare

Bss Microfinance

3.6
Compare

Sonata Finance

3.9
Compare
write
Share an Interview