Add office photos
Filter interviews by
STAN Professionals Assistant Software Manager Interview Questions and Answers
STAN Professionals Assistant Software Manager Interview Experiences
1 interview found
FIDAUL HAOUE
(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
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. Asked about my experience as an integration developer
Covers basics aps around 15 question
DSA based questions from leetcode easy and medium
Software Developer Interview Questions & Answers
Mitsogo Technologies
Anonymous
posted on 8 May 2024
The apptitude test is an online assessment and you will have questions from Quantitative Aptitude and Logical Reasoning.
You will have 60 questions in each section which needs to be solved in 60 minutes.
The questions are subjective and they were not MCQ based on questions
For the technical role, round two is problem-solving.
Three questions need to be solved in 60 minutes.
The difficulty level is from medium to advanced.
Selected
I applied via Company Website and was interviewed before Jun 2023. There was 1 interview round.
(2 Questions)
- Q1. What are joins in sql
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. Types of arrays in PHP
- Ans.
Types of arrays in PHP include indexed arrays, associative arrays, and multidimensional arrays.
Indexed arrays: default type where each element is assigned a numeric index starting from 0.
Associative arrays: elements are assigned a specific key instead of numeric index.
Multidimensional arrays: arrays within arrays, creating a matrix-like structure.
Example: $indexedArray = [1, 2, 3]; $associativeArray = ['key1' => 'value...
Interview Preparation Tips
- PHP
- MySQL
Skills evaluated in this interview
(2 Questions)
- Q1. Polymorphism, instance variables
- Q2. Inheritance, array programs
(3 Questions)
- Q1. What are your salary expectations?
- Q2. Why should we hire you?
- Q3. Tell me about yourself.
Interview Preparation Tips
I applied via campus placement at University of Hyderabad, Hyderabad and was interviewed before Sep 2021. There were 3 interview rounds.
Aptitude + Coding Test. 27 basic Aptitude problems and 3 problem solving questions.
(1 Question)
- Q1. Technical Round 1 has questions based on databases. NoSql will be + point. UI technologies and basic data structures.
(1 Question)
- Q1. Technical Round 2, follow-up from round 1. Some more questions on databases
Interview Preparation Tips
- MySQL
- Angularjs
- Node.Js
- NoSQL
Software Developer Interview Questions & Answers
Greeksoft Technologies
Anonymous
posted on 31 Mar 2022
I applied via Naukri.com and was interviewed in Mar 2022. There were 2 interview rounds.
Simple questions
Interview Preparation Tips
- C
- C++
Software Tester Interview Questions & Answers
Incrementors Web Solutions
Anonymous
posted on 25 Jun 2021
Interview Questionnaire
1 Question
- Q1. I asked a little about the company, how it works or not, asked the terms and conditions, and asked about my role in company, how to work.
Interview Preparation Tips
I applied via Referral and was interviewed in Sep 2021. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Tell me about recent Project Details and what is your Role in this Project.
- Ans. I explained my project and the modules which I had developed. Informed about Team members and their responsibilities who were working on the same Project. Then my role in the team as well as my responsibilities in the Project.
- Q2. Git and Azure DevOps related Questions
- Ans. I Explained how we work on AzureDevOps. Explained workflow with Git Repos through DevOps Repositories. Explained Build and Release Pipelines also Explained NuGet Packages using Artifacts
- Q3. Explain Solid Principles and Where to use this with Example
- Ans.
Solid Principles are a set of design principles for writing maintainable and scalable software.
Solid Principles consist of five principles: Single Responsibility Principle, Open/Closed Principle, Liskov Substitution Principle, Interface Segregation Principle, and Dependency Inversion Principle.
Single Responsibility Principle states that a class should have only one reason to change.
Open/Closed Principle states that sof...
- Q4. Abstraction and Interface Differance
- Ans.
Abstraction focuses on hiding implementation details, while interface defines a contract for classes to follow.
Abstraction allows us to focus on the essential features of an object, while hiding unnecessary details.
Interface defines a set of methods that a class must implement, providing a contract for how the class should behave.
Abstraction is achieved through abstract classes and interfaces in object-oriented program...
Interview Preparation Tips
STAN Professionals Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Software Developer Interview Questions
- Senior Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Softwaretest Engineer Interview Questions
- Senior Software Developer Interview Questions
- Software Tester Interview Questions
- Software Engineer Trainee Interview Questions
- Show more
Interview Questions from Similar Companies
|
Senior Executive
7
salaries
|  ₹2.3 L/yr - ₹4 L/yr |
|
Executive Accountant
7
salaries
| ₹2 L/yr - ₹3.5 L/yr |
|
Manager
6
salaries
| ₹5.7 L/yr - ₹6.5 L/yr |
|
Assistant Manager
6
salaries
| ₹3 L/yr - ₹7.2 L/yr |
|
Executive
5
salaries
| ₹1.8 L/yr - ₹2.9 L/yr |
Deloitte
KPMG India
PwC
Ernst & Young
- Home >
- Interviews >
- STAN Professionals Interview Questions >
- STAN Professionals Assistant Software Manager Interview Questions
