AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
STAN Professionals Interview Questions, Process, and Tips
Top STAN Professionals Interview Questions and Answers
- Q1. What is DDL command?asked in Assistant Software Manager interview
- Q2. Types of constraints..asked in Assistant Software Manager interview
STAN Professionals Interview Experiences
2 interviews found
FIDAUL HAOUE
(5 Questions)
- Q1. Types of constraints
- Q2. What is ABNS and SBNA??
- Q3. What is a Join??
- Q4. What is a Foreign key??
- Ans.
A foreign key is a column or a group of columns in a database table that uniquely identifies a row in another table.
A foreign key establishes a relationship between two tables in a database.
It ensures referential integrity by enforcing a link between the data in the two tables.
Foreign keys help maintain data consistency and prevent orphaned records.
Example: In a database with tables for 'orders' and 'customers', the 'c...
- Q5. What is a Alter command?
Interview Preparation Tips
Skills evaluated in this interview
(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.
- 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
Interview Preparation Tips
Skills evaluated in this interview
Assistant Software Manager Interview Questions asked at other Companies
Jobs at STAN Professionals
Top trending discussions
Interview questions from similar companies
Anonymous
I applied via Campus Placement and was interviewed before Jul 2021. There were 4 interview rounds.
Aptitude test on CS subjects like C programming, DBMS, CN, and OS.
There were 2 input-output based questions of easy to moderate level
Every candidate was given an individual topic and was asked to speak on it
(1 Question)
- Q1. Some typical HR questions
Interview Preparation Tips
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.
Interview Preparation Tips
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Java questions
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.
Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.
(3 Questions)
- Q1. Explain OOPs w.r.t Java
- Ans.
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
OOPs stands for Object-Oriented Programming System
Java is a class-based OOPs language
Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs
Objects have state and behavior
Java supports interfaces, which allow for multiple inheritance
Example: A car can be represented as an object wit...
- Q2. Explain about the projects that you have worked on
- Q3. Explain how Java solves machine dependency of code execution
- Ans.
Java solves machine dependency by using bytecode and virtual machine.
Java code is compiled into bytecode which is platform-independent
The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific
JVM translates bytecode into machine code for the specific platform
This allows Java code to run on any platform with a JVM installed
Example: A Java program compiled on Windows can run on Linux or Mac as
(2 Questions)
- Q1. Why should we hire you?
- Q2. Tell me about yourself.
Interview Preparation Tips
- Java
Skills evaluated in this interview
I applied via Company Website and was interviewed before Jul 2021. There were 3 interview rounds.
Aptitude, reasoning, English, cloud sections
2 questions in which , one has to complete within an 50 minutes
(2 Questions)
- Q1. Tell me about t Yourself
- Q2. What are the previous experiences
Interview Preparation Tips
- Java
- SQL
- Agile Methodology
- SDLC
Keep it just and short
Explain more about your experiences
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
(1 Question)
- Q1. Print 1 to 100 without for loop
- Ans.
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
(1 Question)
- Q1. General questions as per your cv
Interview Preparation Tips
- Aptitude
I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.
Attended the codevita competition in final year of college.
(3 Questions)
- Q1. About College Project
- Q2. Some very basics of java
- Q3. Experience of college project as a team
Interview Preparation Tips
STAN Professionals Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
STAN Professionals Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
STAN Professionals Reviews and Ratings
based on 27 reviews
Rating in categories
|
Senior Executive
7
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Executive Accountant
7
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Manager
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Executive
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Deloitte
KPMG India
PwC
Ernst & Young
- Home >
- Interviews >
- STAN Professionals Interview Questions
