AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Sun Dew
Solutions
Compare
Filter interviews by
Sun Dew Solutions Interview Questions and Answers
14 Interview questions
MySQL uses a structured storage system with various storage engines to manage data efficiently and support different use cases.
MySQL supports multiple storage engines like InnoDB, MyISAM, and MEMORY, each optimized for different scenarios.
InnoDB is the default engine, providing ACID compliance, transactions, and foreign key support.
MyISAM is optimized for read-heavy operations and offers full-text search capabilit...
Indexing in MySQL improves query performance by allowing faster data retrieval and efficient data organization.
Indexes speed up data retrieval by reducing the amount of data scanned. For example, searching for a user by ID is faster with an index.
They help maintain the uniqueness of data. For instance, a primary key index ensures no duplicate values in a column.
Indexes can improve the performance of JOIN operation...
A widget in Flutter is a reusable component that represents part of the user interface.
Widgets are the building blocks of a Flutter application.
They can be combined and nested to create complex UI layouts.
Widgets can be stateless or stateful, depending on whether they can change over time.
Examples of widgets include buttons, text fields, images, and containers.
Different types of Widgets in Flutter include StatelessWidget, StatefulWidget, Container, Text, Image, ListView, GridView, etc.
StatelessWidget: A widget that does not require mutable state.
StatefulWidget: A widget that can change over time.
Container: A widget that allows you to customize its child widget's position, size, and appearance.
Text: A widget that displays a short piece of text.
Image: A widget that displa...
To reduce the size of a Flutter application, we can use code splitting, remove unused resources, optimize images, and enable compression.
Use code splitting to split the app into smaller chunks that are loaded on-demand.
Remove unused resources and dependencies to eliminate unnecessary code.
Optimize images by compressing them without compromising quality.
Enable compression techniques like Gzip or Brotli to reduce th...
Flutter is an open-source UI software development kit created by Google for building natively compiled applications for mobile, web, and desktop from a single codebase.
Flutter is used to develop cross-platform mobile applications.
It allows developers to write code once and deploy it on both iOS and Android platforms.
Flutter uses a reactive framework and a rich set of pre-designed widgets to create beautiful and re...
React is a JavaScript library for building user interfaces.
React uses a virtual DOM to efficiently update the actual DOM.
Components are the building blocks of React applications.
React allows for declarative programming, making it easier to reason about code.
React can be used with other libraries and frameworks, such as Redux and Next.js.
Futuristic skills for a frontend developer include AI, VR/AR, PWAs, and accessibility.
Proficiency in AI and machine learning for creating intelligent interfaces
Knowledge of VR/AR for developing immersive experiences
Expertise in Progressive Web Apps (PWAs) for building fast and reliable web applications
Understanding of accessibility guidelines and techniques for creating inclusive designs
Verification ensures that the product is built according to the requirements, while validation ensures that the product meets the customer's needs.
Verification checks if the product meets the specified requirements and standards.
Validation checks if the product meets the customer's needs and expectations.
Verification is done during the development phase.
Validation is done after the development phase.
Verification i...
Agile testing is a software testing approach that follows the principles of Agile methodology.
Agile testing involves continuous testing throughout the software development lifecycle.
It emphasizes collaboration between developers, testers, and stakeholders.
Test cases are created and executed in short iterations, allowing for quick feedback and adjustments.
Automated testing is often used to increase efficiency and s...
Sun Dew Solutions Interview Experiences
8 interviews found
Prasenjit Karmakar
Selected
I applied via Hirect and was interviewed before Jul 2022. There were 4 interview rounds.
(1 Question)
- Q1. Asked SQL basic to advance level concept.
1-hour test with 15 questions on Python or SQL.
(1 Question)
- Q1. Basic Hr Question. But they judge the psychology of the candidate.
Interview Preparation Tips
Zulfequar Ali
Selected
I applied via Naukri.com and was interviewed in Jul 2023. There were 3 interview rounds.
(3 Questions)
- Q1. What is Flutter?
- Ans.
Flutter is an open-source UI software development kit created by Google for building natively compiled applications for mobile, web, and desktop from a single codebase.
Flutter is used to develop cross-platform mobile applications.
It allows developers to write code once and deploy it on both iOS and Android platforms.
Flutter uses a reactive framework and a rich set of pre-designed widgets to create beautiful and respons...
- Q2. What is a Widget in Flutter?
- Ans.
A widget in Flutter is a reusable component that represents part of the user interface.
Widgets are the building blocks of a Flutter application.
They can be combined and nested to create complex UI layouts.
Widgets can be stateless or stateful, depending on whether they can change over time.
Examples of widgets include buttons, text fields, images, and containers.
- Q3. What are the different types of Widgets in Flutter?
- Ans.
Different types of Widgets in Flutter include StatelessWidget, StatefulWidget, Container, Text, Image, ListView, GridView, etc.
StatelessWidget: A widget that does not require mutable state.
StatefulWidget: A widget that can change over time.
Container: A widget that allows you to customize its child widget's position, size, and appearance.
Text: A widget that displays a short piece of text.
Image: A widget that displays an...
(2 Questions)
- Q1. What can we do to reduce the size of an application developed using Flutter?
- Ans.
To reduce the size of a Flutter application, we can use code splitting, remove unused resources, optimize images, and enable compression.
Use code splitting to split the app into smaller chunks that are loaded on-demand.
Remove unused resources and dependencies to eliminate unnecessary code.
Optimize images by compressing them without compromising quality.
Enable compression techniques like Gzip or Brotli to reduce the siz...
- Q2. How to handle the huge number of concurrent HTTP requests of orders for the same item? What if there is only one item left in the stock?
- Ans.
Use a queue system to manage concurrent requests and implement a reservation system for the last item in stock.
Implement a queue system to handle concurrent requests for the same item.
Use a reservation system for the last item in stock to prevent overselling.
Notify users about the availability status of the item in real-time.
Implement a timeout mechanism for requests to prevent bottlenecks.
Consider implementing caching...
(3 Questions)
- Q1. Introduce yourself.
- Q2. How will you handle the situation when there is less time in hand but more work to do?
- Q3. What skills do you have other than related to the job?
Interview Preparation Tips
- Dart
- Flutter
- Communication Skills
Skills evaluated in this interview
(1 Question)
- Q1. Python SQL Power BI
(2 Questions)
- Q1. What is a brand? What is your inspiration to start work?
- Ans.
A brand is a unique identity that represents a company, product, or service. Inspiration to start work comes from various sources.
A brand is the perception and reputation of a company or product in the minds of consumers.
It encompasses the visual elements such as logo, colors, typography, and design that create a recognizable identity.
A brand also includes the values, mission, and personality that differentiate it from...
- Q2. What is the difference between UI & UX? Mention the top 5 trends of the latest design.
- Ans.
UI is the user interface while UX is the user experience. Top 5 design trends are minimalism, bold typography, dark mode, 3D elements, and micro-interactions.
UI is the visual aspect of a product while UX is the overall experience of the user with the product.
Minimalism is a trend that focuses on simplicity and clarity in design.
Bold typography is a trend that uses large and impactful fonts to convey a message.
Dark mode...
(1 Question)
- Q1. Need to make a Logo and SMP posts or a web layout along with 2 banners
(1 Question)
- Q1. Regarding CTC and formal Q&A
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview in Feb 2023.
(1 Question)
- Q1. Basic SQL, Window Functions, Index, Table Partition
(1 Question)
- Q1. Still haven't given, planning to give it tomorrow.
Interview Preparation Tips
Tapan Das
Selected
I appeared for an interview before May 2024, where I was asked the following questions.
- Q1. Why indexing is needed in MySQL?
- Ans.
Indexing in MySQL improves query performance by allowing faster data retrieval and efficient data organization.
Indexes speed up data retrieval by reducing the amount of data scanned. For example, searching for a user by ID is faster with an index.
They help maintain the uniqueness of data. For instance, a primary key index ensures no duplicate values in a column.
Indexes can improve the performance of JOIN operations by ...
- Q2. Explain MySQL storage system
- Ans.
MySQL uses a structured storage system with various storage engines to manage data efficiently and support different use cases.
MySQL supports multiple storage engines like InnoDB, MyISAM, and MEMORY, each optimized for different scenarios.
InnoDB is the default engine, providing ACID compliance, transactions, and foreign key support.
MyISAM is optimized for read-heavy operations and offers full-text search capabilities.
T...
Selected
I applied via Company Website and was interviewed before Dec 2021. There were 5 interview rounds.
(2 Questions)
- Q1. What technical skills do you have?
- Q2. According to you what are the futuristic skills required for a frontend developer?
- Ans.
Futuristic skills for a frontend developer include AI, VR/AR, PWAs, and accessibility.
Proficiency in AI and machine learning for creating intelligent interfaces
Knowledge of VR/AR for developing immersive experiences
Expertise in Progressive Web Apps (PWAs) for building fast and reliable web applications
Understanding of accessibility guidelines and techniques for creating inclusive designs
(1 Question)
- Q1. A demo Project will be assigned.
(1 Question)
- Q1. Tell me how React works.
- Ans.
React is a JavaScript library for building user interfaces.
React uses a virtual DOM to efficiently update the actual DOM.
Components are the building blocks of React applications.
React allows for declarative programming, making it easier to reason about code.
React can be used with other libraries and frameworks, such as Redux and Next.js.
(1 Question)
- Q1. Can you take ownership of a project?
Interview Preparation Tips
- Post CSS
- SCSS
- HTML
- CSS3
- React
- Angular
- Javascript
- Photoshop
- figma
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Dec 2021. There were 5 interview rounds.
(2 Questions)
- Q1. What is regression testing in software testing?
- Ans.
Regression testing is a type of software testing that ensures that previously developed and tested software still performs correctly after changes or updates have been made.
It is performed to verify that changes made in the software do not have any unintended side effects on the existing functionality.
It involves re-executing test cases that have been previously executed to ensure that the existing functionality has no...
- Q2. What is the difference between verification and validation?
- Ans.
Verification ensures that the product is built according to the requirements, while validation ensures that the product meets the customer's needs.
Verification checks if the product meets the specified requirements and standards.
Validation checks if the product meets the customer's needs and expectations.
Verification is done during the development phase.
Validation is done after the development phase.
Verification is a p...
(2 Questions)
- Q1. 1. Prepare test cases and test them.
- Ans.
Creating and executing test cases ensures software quality and functionality meet requirements.
Identify the requirements: Understand what the software is supposed to do.
Create test cases: Write detailed test cases covering all functionalities.
Example: For a login feature, test cases could include valid login, invalid password, and empty fields.
Execute test cases: Run the test cases and document the results.
Example: Rec...
- Q2. 2. While writing down test cases you also need to check the SEO compatibility of the website given
(1 Question)
- Q1. What is Agile testing?
- Ans.
Agile testing is a software testing approach that follows the principles of Agile methodology.
Agile testing involves continuous testing throughout the software development lifecycle.
It emphasizes collaboration between developers, testers, and stakeholders.
Test cases are created and executed in short iterations, allowing for quick feedback and adjustments.
Automated testing is often used to increase efficiency and speed ...
(1 Question)
- Q1. Why do you want to work for our company?
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Easy and moderate level question
Given a relevant topic and discussion on it
(2 Questions)
- Q1. Introducd yourself
- Q2. Why do you want to join us
Reasoning and aptitude questions were asked
(1 Question)
- Q1. Interview was around python programming and team fitment
Sun Dew Solutions Interview FAQs
Some of the top questions asked at the Sun Dew Solutions interview -
The duration of Sun Dew Solutions interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Sun Dew Solutions Interviews By Designations
- Sun Dew Solutions Data Engineer Interview Questions
- Sun Dew Solutions Graphic & UI Designer Interview Questions
- Sun Dew Solutions Quality Analyst Interview Questions
- Sun Dew Solutions Mobile Application Developer Interview Questions
- Sun Dew Solutions ETL Developer Interview Questions
- Sun Dew Solutions Technical Associate Interview Questions
- Sun Dew Solutions Front end Developer Interview Questions
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 9 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Sun Dew Solutions Reviews and Ratings
based on 45 reviews
Rating in categories
|
Technical Associate
17
salaries
|  ₹3 L/yr - ₹7.6 L/yr |
|
Junior Technical Associate
9
salaries
| ₹2.2 L/yr - ₹5 L/yr |
|
Quality Analyst
7
salaries
| ₹4 L/yr - ₹5.2 L/yr |
|
Presales Consultant
6
salaries
| ₹4.8 L/yr - ₹6.4 L/yr |
|
Data Engineer
5
salaries
| ₹4.8 L/yr - ₹6 L/yr |
Zidio Development
Northcorp Software
Accel Frontline
Elentec Power India (EPI) Pvt. Ltd.
- Home >
- Interviews >
- Sun Dew Solutions Interview Questions
