Upload Button Icon Add office photos

Dreamztech Solutions

Compare button icon Compare button icon Compare

Filter interviews by

Dreamztech Solutions Associate Software Engineer Interview Questions and Answers

Updated 28 Jun 2021

8 Interview questions

An Associate Software Engineer was asked
Q. What are the differences between a partial view and a view?
Ans. 

Partial view is a reusable piece of a view, while view is the complete page.

  • Partial view can be used in multiple views, while view is unique

  • Partial view is a smaller component of a view

  • View is the complete HTML page, while partial view is a part of it

An Associate Software Engineer was asked
Q. How do you return results in MVC?
Ans. 

Results are returned through Views in MVC architecture.

  • In MVC, the Controller receives input and processes it, then sends data to the View for display.

  • The View then renders the data and returns it as a response to the user.

  • The Model contains the data and business logic, but does not directly return results in MVC.

  • Examples of returning results in MVC include returning a list of products or a user profile page.

Associate Software Engineer Interview Questions Asked at Other Companies

asked in Accenture
Q1. Triplets with Given Sum Problem Given an array or list ARR consis ... read more
Q2. Intersection of Two Arrays II Given two integer arrays ARR1 and A ... read more
asked in Accenture
Q3. Write a function to determine if a given string is a valid passwo ... read more
asked in Clarivate
Q4. Best Time to Buy and Sell Stock II Problem Statement Given the st ... read more
asked in CGI Group
Q5. Frog Jump Problem Statement A frog is positioned on the first ste ... read more
An Associate Software Engineer was asked
Q. What is an index in SQL?
Ans. 

Index in SQL is a database object that improves the speed of data retrieval operations.

  • Index is used to quickly locate data without having to search every row in a database table.

  • It is created on one or more columns of a table.

  • Indexes can be clustered or non-clustered.

  • Clustered index determines the physical order of data in a table.

  • Non-clustered index is a separate structure that contains a copy of the indexed col...

An Associate Software Engineer was asked
Q. How do you handle errors in stored procedures?
Ans. 

Error handling in stored procedures involves catching and handling exceptions that may occur during execution.

  • Use TRY-CATCH blocks to handle errors

  • Use RAISERROR to raise custom error messages

  • Use SET XACT_ABORT ON to roll back transactions on error

  • Log errors to a table for future reference

An Associate Software Engineer was asked
Q. Return results in JSON format.
Ans. 

Return JSON result

  • Create a JSON object with key-value pairs

  • Use JSON.stringify() to convert the object to a string

  • Return the string as the result

An Associate Software Engineer was asked
Q. What is the difference between a stored procedure and an SQL function?
Ans. 

Stored procedures are used to perform a set of operations, while SQL functions return a single value.

  • Stored procedures can have input and output parameters, while SQL functions only have input parameters.

  • Stored procedures can modify data in the database, while SQL functions cannot.

  • Stored procedures are precompiled and stored in the database, while SQL functions are compiled every time they are called.

  • Examples of s...

An Associate Software Engineer was asked
Q. Union all and union difference
Ans. 

Union all combines the results of two or more SELECT statements, while union difference returns only the distinct rows from the first SELECT statement that are not in the second SELECT statement.

  • Union all is used to combine the results of two or more SELECT statements into a single result set.

  • Union difference is used to return only the distinct rows from the first SELECT statement that are not in the second SELECT...

Are these interview questions helpful?
An Associate Software Engineer was asked
Q. Area in mvc
Ans. 

MVC stands for Model-View-Controller and is a software design pattern used in web development.

  • Model represents the data and business logic

  • View is responsible for rendering the user interface

  • Controller handles user input and updates the model and view accordingly

Dreamztech Solutions Associate Software Engineer Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

11 Questions

  • Q1. 1.Returns results in MVC
  • Ans. 

    Results are returned through Views in MVC architecture.

    • In MVC, the Controller receives input and processes it, then sends data to the View for display.

    • The View then renders the data and returns it as a response to the user.

    • The Model contains the data and business logic, but does not directly return results in MVC.

    • Examples of returning results in MVC include returning a list of products or a user profile page.

  • Answered by AI
  • Q2. Union all and union difference
  • Ans. 

    Union all combines the results of two or more SELECT statements, while union difference returns only the distinct rows from the first SELECT statement that are not in the second SELECT statement.

    • Union all is used to combine the results of two or more SELECT statements into a single result set.

    • Union difference is used to return only the distinct rows from the first SELECT statement that are not in the second SELECT stat...

  • Answered by AI
  • Q3. Retun result for json
  • Ans. 

    Return JSON result

    • Create a JSON object with key-value pairs

    • Use JSON.stringify() to convert the object to a string

    • Return the string as the result

  • Answered by AI
  • Q4. Partial view and view difference
  • Ans. 

    Partial view is a reusable piece of a view, while view is the complete page.

    • Partial view can be used in multiple views, while view is unique

    • Partial view is a smaller component of a view

    • View is the complete HTML page, while partial view is a part of it

  • Answered by AI
  • Q5. Area in mvc
  • Ans. 

    MVC stands for Model-View-Controller and is a software design pattern used in web development.

    • Model represents the data and business logic

    • View is responsible for rendering the user interface

    • Controller handles user input and updates the model and view accordingly

  • Answered by AI
  • Q6. Cross join
  • Q7. Left join
  • Q8. Left outer join
  • Q9. Difference between stored procedure and sql function
  • Ans. 

    Stored procedures are used to perform a set of operations, while SQL functions return a single value.

    • Stored procedures can have input and output parameters, while SQL functions only have input parameters.

    • Stored procedures can modify data in the database, while SQL functions cannot.

    • Stored procedures are precompiled and stored in the database, while SQL functions are compiled every time they are called.

    • Examples of stored...

  • Answered by AI
  • Q10. What is index in SQL
  • Ans. 

    Index in SQL is a database object that improves the speed of data retrieval operations.

    • Index is used to quickly locate data without having to search every row in a database table.

    • It is created on one or more columns of a table.

    • Indexes can be clustered or non-clustered.

    • Clustered index determines the physical order of data in a table.

    • Non-clustered index is a separate structure that contains a copy of the indexed columns ...

  • Answered by AI
  • Q11. Error handel in stored procedure
  • Ans. 

    Error handling in stored procedures involves catching and handling exceptions that may occur during execution.

    • Use TRY-CATCH blocks to handle errors

    • Use RAISERROR to raise custom error messages

    • Use SET XACT_ABORT ON to roll back transactions on error

    • Log errors to a table for future reference

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - If you don't know the answer please accept that you don't know

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Dreamztech Solutions?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2018. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Asked me to draw spring mvc architecture and about collection framework.
  • Q2. Asked me to write the logic for pattern.
  • Ans. 

    This question involves creating a specific pattern using loops and conditional statements in programming.

    • Identify the desired pattern (e.g., asterisks, numbers).

    • Use nested loops: outer loop for rows, inner loop for columns.

    • Control the output format with conditional statements.

    • Example: For a pyramid pattern, increase spaces and asterisks in each row.

  • Answered by AI
  • Q3. Asked me on core java.

Interview Preparation Tips

General Tips: be thorough with the core java and good to have knowledge on spring mvc
Skills: Communication
Duration: <1 week

Associate Software Engineer Interview Questions Asked at Other Companies

asked in Accenture
Q1. Triplets with Given Sum Problem Given an array or list ARR consis ... read more
Q2. Intersection of Two Arrays II Given two integer arrays ARR1 and A ... read more
asked in Accenture
Q3. Write a function to determine if a given string is a valid passwo ... read more
asked in Clarivate
Q4. Best Time to Buy and Sell Stock II Problem Statement Given the st ... read more
asked in CGI Group
Q5. Frog Jump Problem Statement A frog is positioned on the first ste ... read more

I applied via Referral and was interviewed before Jan 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Which technology are you using, is this latest?
  • Ans. 

    We are using a variety of technologies, including some of the latest ones.

    • We are using React for our front-end development.

    • We are also using Node.js for our back-end development.

    • We are using Docker for containerization.

    • We are using Kubernetes for orchestration.

    • We are using AWS for cloud hosting.

    • We are constantly evaluating new technologies to see if they can improve our development process.

  • Answered by AI
  • Q2. If not then which technology can we use instead of this?
  • Ans. 

    It depends on the specific requirements and constraints of the project.

    • Consider the project's goals and objectives

    • Evaluate the available technologies and their capabilities

    • Assess the project's budget and timeline

    • Consult with stakeholders and experts in the field

    • Examples: React vs Angular, MySQL vs MongoDB, Java vs Python

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi,
Listen carefully and speak fluently.

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

Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself
  • Ans. 

    I'm a passionate software engineer with a strong background in full-stack development and a love for solving complex problems.

    • Graduated with a degree in Computer Science from XYZ University.

    • Worked at ABC Corp, where I developed a web application that improved user engagement by 30%.

    • Proficient in languages like JavaScript, Python, and Java, with experience in frameworks like React and Django.

    • Enjoy collaborating in agile...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. 1 Project Explanation 2 SDLC & STLC. 3 Differentiate Smoke vs Sanity 4 What is Regression testing? 5 Bug life cycle. 6 Scenarios on real time example. 7 Questions on agile
  • Ans. 

    Interview questions for Software Engineer position

    • Project explanation should include details on the project's purpose, scope, and technologies used

    • SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) are methodologies used in software development and testing respectively

    • Smoke testing is a type of testing that checks if the basic functionalities of the software are working fine, while Sanity tes...

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. All basic HR questions and salary discussion.

Software Engineer Interview Questions & Answers

Contus user image MuRugenThiraN JayaM

posted on 29 Jun 2024

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

I applied via Company Website and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basics questions , checking logical skills

Round 2 - Technical 

(1 Question)

  • Q1. Deep Java question
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and company details
Round 1 - Coding Test 

Topics:
Python, Django, MySQL, Automation, Technical questions

Round 2 - Technical 

(3 Questions)

  • Q1. Topics: Python, Django, MySQL, Automation, Technical questions
  • Q2. Explain Django Architecture
  • Q3. Difference between XML and JSON
  • Ans. 

    XML is a markup language while JSON is a lightweight data interchange format.

    • XML uses tags to define elements while JSON uses key-value pairs.

    • XML is more verbose and complex than JSON.

    • JSON is easier to read and parse than XML.

    • XML supports namespaces and validation while JSON does not.

    • XML is widely used in web services and document exchange while JSON is preferred for data exchange between applications.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on Python Django
Showcase your skills

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Oct 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 - HR 

(1 Question)

  • Q1. Asking about interest and qualifications
  • Ans. Explain briefly about yourself and you can answer asper the questions by HR
  • Answered Anonymously
Round 3 - Technical 

(2 Questions)

  • Q1. Face 2 Face Interview
  • Q2. What is interface
Are these interview questions helpful?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before May 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Oops concept, adodotet and entity framework, sql query, asked to write c# code to display reverse pyramid like design with numbers. Html , css basic
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Telephonic Call 

(2 Questions)

  • Q1. Asking about the whereabouts
  • Q2. Checking com skills and availability
Round 2 - Technical 

(3 Questions)

  • Q1. Basic questions based on resume
  • Q2. Basic .net questions
  • Q3. Logical questions related to problem solving

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and communicate effectively. Include only those things in your resume which you are fully confident.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Palindrome code should design
  • Q2. Regarding sql topics like joins and acid
  • Q3. Project explain and domain
  • Q4. Project explain and domain and internal working
  • Q5. Oops concepts and coding

Interview Preparation Tips

Interview preparation tips for other job seekers - Plzzzz don't join this worst company...they treat u like daily wages person

Dreamztech Solutions Interview FAQs

What are the top questions asked in Dreamztech Solutions Associate Software Engineer interview?

Some of the top questions asked at the Dreamztech Solutions Associate Software Engineer interview -

  1. difference between stored procedure and sql funct...read more
  2. partial view and view differe...read more
  3. error handel in stored proced...read more

Tell us how to improve this page.

Dreamztech Solutions Associate Software Engineer Salary
based on 41 salaries
₹2 L/yr - ₹6 L/yr
40% less than the average Associate Software Engineer Salary in India
View more details

Dreamztech Solutions Associate Software Engineer Reviews and Ratings

based on 8 reviews

3.7/5

Rating in categories

3.9

Skill development

3.4

Work-life balance

3.6

Salary

4.6

Job security

3.5

Company culture

3.0

Promotions

3.5

Work satisfaction

Explore 8 Reviews and Ratings
Associate Software Engineer
41 salaries
unlock blur

₹2 L/yr - ₹6 L/yr

Software Engineer
37 salaries
unlock blur

₹3 L/yr - ₹8.6 L/yr

Software Developer
12 salaries
unlock blur

₹2.3 L/yr - ₹8.1 L/yr

Senior Software Engineer
10 salaries
unlock blur

₹5.6 L/yr - ₹11.4 L/yr

Application Developer
10 salaries
unlock blur

₹2.2 L/yr - ₹10.4 L/yr

Explore more salaries
Compare Dreamztech Solutions with

Accel Frontline

4.1
Compare

Apmosys Technologies

3.4
Compare

Pitney Bowes

3.8
Compare

DynPro

3.8
Compare
write
Share an Interview