Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

BirchStreet Systems

Compare button icon Compare button icon Compare
3.4

based on 62 Reviews

Filter interviews by

BirchStreet Systems Application Support Specialist Interview Questions and Answers

Updated 1 Jul 2022

BirchStreet Systems Application Support Specialist Interview Experiences

2 interviews found

Application Support Specialist Interview Questions & Answers

user image Anonymous

posted on 1 Jul 2022

I applied via Company Website and was interviewed in Jun 2022. There were 3 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 - One-on-one 

(1 Question)

  • Q1. Tell me about Yourself? , Views in SQL, Some DDL OR DML commands
    • Add your answer
Round 3 - One-on-one 

(1 Question)

  • Q1. Some SQL questions, About leadership
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic Communication skills and SQL Knowledge

Application Support Specialist Interview Questions & Answers

user image Anonymous

posted on 10 Aug 2021

I applied via Naukri.com and was interviewed in Jul 2021. There were 5 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. What are the SQL constraints and types.
  • Ans. 

    SQL constraints are rules that are applied to columns in a table to ensure data integrity and consistency.

    • SQL constraints are used to enforce rules on the data stored in tables.

    • They can be applied to individual columns or the entire table.

    • Common types of SQL constraints include primary key, foreign key, unique, not null, and check constraints.

    • Primary key constraints ensure that each row in a table is uniquely identifie...

    • Answered by AI
    View 2 more answers
  • Q2. Command to creat the table, explaint the DDL ( data definition language)
  • Ans. 

    Command to create a table and explanation of DDL

    • Use CREATE TABLE statement to create a table

    • Specify table name and column names with data types

    • Add constraints like primary key, foreign key, etc.

    • DDL is used to define and modify database objects

    • Examples: CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(50));

    • DDL includes CREATE, ALTER, DROP, TRUNCATE statements

    • Answered by AI
    Add your answer
  • Q3. Clause types and where and how it can be use?
  • Ans. 

    Clause types are used in grammar to categorize sentences based on their structure and purpose.

    • There are four main types of clauses: independent, dependent, relative, and noun clauses.

    • Independent clauses can stand alone as a sentence, while dependent clauses cannot.

    • Relative clauses provide additional information about a noun or pronoun in the sentence.

    • Noun clauses function as a noun in the sentence.

    • Clauses can be used t...

    • Answered by AI
    Add your answer
  • Q4. SQL joins and types
    • Add your answer
  • Q5. Why you want to change the job?
    • Add your answer
  • Q6. Explaint the working of the last organization.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Please go through the link below for SQL,
-----

Skills evaluated in this interview

Application Support Specialist Interview Questions Asked at Other Companies

asked in BirchStreet Systems
Q1. Clause types and where and how it can be use?
View answer (1)
asked in BirchStreet Systems
Q2. What are the SQL constraints and types.
View answers (3)
asked in BirchStreet Systems
Q3. Command to creat the table, explaint the DDL ( data definition la ... read more
View answer (1)
asked in Randstad
Q4. Do you know SQL , JAVASCRIPT?
View answer (1)
asked in Link Group
Q5. Tools and technology used in project
View answer (1)
View All

Application Support Specialist Jobs at BirchStreet Systems

View all

Top trending discussions

View All
Interview Tips & Stories
2d (edited)
timepasstiwari
·
A Digital Markter
Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question
So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about BirchStreet Systems?
Ask anonymously on communities.

Interview questions from similar companies

Associate Software Engineer Interview Questions & Answers

Infor Global Solution user image Anonymous

posted on 21 Feb 2022

I applied via Referral and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Mcq based on aptitude and code ouputs in sql,java
    • Add your answer
Round 2 - One-on-one 

(1 Question)

  • Q1. Basci techinal questions on java and oops concepts and sql
    • Add your answer
Round 3 - Group Discussion 

Group discussion on the given topic

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the oops concepts and core java questions and some sql questions

Associate Software Engineer Interview Questions & Answers

Blue Yonder user image Harsh Goyal

posted on 7 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Mcq on core section with 2 coding question

Associate Software Engineer Interview Questions & Answers

Blue Yonder user image Bellana Trisha

posted on 15 Oct 2024

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

2 coding questions and few other technical questions from os, cn, dsa and so on

Round 2 - Coding Test 

They asked me sql, dsa and oops...all of them were basics

Round 3 - HR 

(2 Questions)

  • Q1. Why this company
  • Ans. 

    I chose this company because of its innovative projects, strong company culture, and opportunities for growth.

    • Innovative projects: I am excited about the cutting-edge technologies and projects the company is working on.

    • Strong company culture: I value a positive work environment and the company's reputation for fostering a supportive culture is appealing to me.

    • Opportunities for growth: I see potential for career advance

    • Answered by AI
    Add your answer
  • Q2. Are u okay with any location?
  • Ans. 

    Yes, I am open to any location for the position of Associate Software Engineer.

    • I am flexible and willing to relocate for the right opportunity.

    • I believe in adapting to new environments and challenges.

    • I am excited about the prospect of working in different locations to gain diverse experiences.

    • Answered by AI
    Add your answer

Associate Software Engineer Interview Questions & Answers

Blue Yonder user image Anonymous

posted on 1 Dec 2024

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

I applied via Campus Placement and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Data Structures and Algorithms medium level questions

Round 2 - Technical 

(2 Questions)

  • Q1. I was asked to solve problems from linkedlist and trees. Then he asked about concepts of OOPs and DBMS. Comparatively he asked tough questions from OOPs.
    • Add your answer
  • Q2. As I had used reactjs, nodejs and MongoDB in my project, interviewer asked FAQs from these topics.
    • Add your answer
Round 3 - HR 

(2 Questions)

  • Q1. How do you handle pressure.
    • Add your answer
  • Q2. Toughest problem faced in project.
  • Ans. 

    Implementing a real-time chat feature with message encryption and decryption.

    • Implementing end-to-end encryption to ensure secure communication

    • Handling real-time updates and synchronization across multiple devices

    • Dealing with potential performance issues due to encryption and decryption processes

    • Answered by AI
    Add your answer

Associate Software Engineer Interview Questions & Answers

Zycus Infotech user image Anonymous

posted on 25 Sep 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic problem solving question puzzles

Round 2 - Technical 

(2 Questions)

  • Q1. Questions around projects worked on
    • Add your answer
  • Q2. Questions related to collections.
    • Add your answer

Associate Software Engineer Interview Questions & Answers

Zycus Infotech user image Anonymous

posted on 10 Apr 2024

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

I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Multiple choices questions related to logical reasoning, math, paaterns etc

Round 2 - Coding Test 

2 coding questions in the choice of your language

Round 3 - Technical 

(1 Question)

  • Q1. JavaScript and java related questions As a testing role, manual testing questions were asked
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on java

Associate Software Engineer Interview Questions & Answers

Yardi Systems user image Anonymous

posted on 16 Apr 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude test, easy to crack.

Round 2 - Coding Test 

Asked all SQL concepts and few scenario based questions.

Associate Software Engineer Interview Questions & Answers

Infor Global Solution user image Anonymous

posted on 26 Jun 2022

Round 1 - Technical 

(1 Question)

  • Q1. Explain Project, Core Java, Java
  • Ans. 

    Project, Core Java, and Java are all related to software development.

    • A project is a set of tasks with a specific goal.

    • Core Java is the basic version of the Java programming language.

    • Java is a high-level programming language used for developing applications.

    • Java is used for developing web applications, mobile applications, and desktop applications.

    • Core Java includes concepts like OOPs, Exception Handling, and Multi-thre...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with the Project technology used, Framework and basic concepts

Skills evaluated in this interview

More about working at BirchStreet Systems

BirchStreet Systems Interview FAQs

How many rounds are there in BirchStreet Systems Application Support Specialist interview?
BirchStreet Systems interview process usually has 3 rounds. The most common rounds in the BirchStreet Systems interview process are One-on-one Round and Resume Shortlist.
How to prepare for BirchStreet Systems Application Support Specialist interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at BirchStreet Systems. The most common topics and skills that interviewers at BirchStreet Systems expect are Application Support, SQL, Communication Skills and L1.
What are the top questions asked in BirchStreet Systems Application Support Specialist interview?

Some of the top questions asked at the BirchStreet Systems Application Support Specialist interview -

  1. Clause types and where and how it can be u...read more
  2. What are the SQL constraints and typ...read more
  3. Command to creat the table, explaint the DDL ( data definition languag...read more

Tell us how to improve this page.

BirchStreet Systems Interviews By Designations

Interview Questions for Popular Designations

Interview Questions from Similar Companies

Infor Global Solution Interview Questions
4.0
 • 70 Interviews
Yardi Systems Interview Questions
3.8
 • 69 Interviews
Zycus Infotech Interview Questions
2.9
 • 67 Interviews
Blue Yonder Interview Questions
3.9
 • 60 Interviews
Link Group Interview Questions
3.8
 • 34 Interviews
Mitsogo Technologies Interview Questions
2.6
 • 31 Interviews
Coupa Software Inc Interview Questions
3.8
 • 24 Interviews
Incrementors Web Solutions Interview Questions
4.3
 • 24 Interviews
Epicor Software Corporation Interview Questions
3.7
 • 21 Interviews
Servosys Solutions Interview Questions
3.0
 • 21 Interviews
View all
BirchStreet Systems Application Support Specialist Salary
based on 86 salaries
₹3 L/yr - ₹5.5 L/yr
55% less than the average Application Support Specialist Salary in India
View more details

BirchStreet Systems Application Support Specialist Reviews and Ratings

based on 10 reviews

3.0/5

Rating in categories

2.6

Skill development

3.3

Work-life balance

2.8

Salary

3.5

Job security

2.8

Company culture

2.8

Promotions

2.9

Work satisfaction

Explore 10 Reviews and Ratings
Application Support Specialist Jobs at BirchStreet Systems
Application Support Specialist (Spanish Language)

Noida

1-3 Yrs

₹ 3.45-5.2 LPA

Application Support Specialist (Turkish Language)

Noida

1-3 Yrs

₹ 3.45-5.2 LPA

Explore more jobs
BirchStreet Systems Salaries in India
Application Support Specialist
86 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Escalation Engineer
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
20 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Application Support Engineer
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare BirchStreet Systems with

Yardi Systems

3.7
Compare

SAP-Concur

3.9
Compare

Infor Global Solution

4.0
Compare

Epicor Software Corporation

3.7
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview