Upload Button Icon Add office photos

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

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 .
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in Feb 2025, where I was asked the following questions.

  • Q1. What is JPA
  • Ans. 

    JPA (Java Persistence API) is a specification for managing relational data in Java applications using object-relational mapping.

    • JPA provides a way to map Java objects to database tables.

    • It simplifies database interactions through an object-oriented approach.

    • Common implementations include Hibernate, EclipseLink, and OpenJPA.

    • Example: Using JPA annotations like @Entity to define a persistent class.

    • JPA supports querying wi...

  • Answered by AI
  • Q2. Write a program to find duplicate elements in the list
  • Ans. 

    This program identifies and returns duplicate elements from a given list.

    • Use a set to track seen elements and a list for duplicates.

    • Iterate through the list and check if an element is in the set.

    • If it is, add it to the duplicates list; otherwise, add it to the set.

    • Example: For the list [1, 2, 3, 2, 4, 3], the output should be [2, 3].

  • Answered by AI
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:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
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

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 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
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-

I appeared for an interview in Aug 2022.

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 - Technical 

(2 Questions)

  • Q1. Mainlyfocus on oops and basic core java question
  • Q2. What is try catch and finally
  • Ans. 

    try catch and finally are keywords used in exception handling in programming languages.

    • try block contains the code that may throw an exception

    • catch block catches the exception thrown by the try block and handles it

    • finally block contains the code that is executed regardless of whether an exception is thrown or not

    • try-catch-finally is used to handle errors and prevent program crashes

    • Example: try { //code that may throw a...

  • Answered by AI
Round 3 - Group Discussion 

Why are you leaving your company

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing here to learn ,and expect everything from you

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Core java Java script Servlet jsp
Round 3 - Technical 

(1 Question)

  • Q1. Servlet and jsp
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Sep 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Aptitude Test 

Logical questions were there with difficult from easy to medium type.

Round 3 - Technical 

(1 Question)

  • Q1. Core Java, Basic SQL then Project discussion afyer that 1 to 2 coding questions (easy to medium type)

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.

STAN Professionals Assistant Software Manager Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Link Group Interview Questions
3.8
 • 34 Interviews
Icl Fincorp Interview Questions
3.2
 • 18 Interviews
PharmaACE Interview Questions
2.6
 • 16 Interviews
Innocule Interview Questions
4.3
 • 15 Interviews
View all
Manager
7 salaries
unlock blur

₹5.7 L/yr - ₹7.4 L/yr

Senior Executive
7 salaries
unlock blur

₹2.3 L/yr - ₹4 L/yr

Executive Accountant
7 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Assistant Manager
6 salaries
unlock blur

₹3 L/yr - ₹7.2 L/yr

Executive
5 salaries
unlock blur

₹1.8 L/yr - ₹2.9 L/yr

Explore more salaries
Compare STAN Professionals with

Karvy Financial Services

3.8
Compare

Reliance Money

3.6
Compare

Sonata Finance

3.9
Compare

Bss Microfinance

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