STEMM One Cloudworks Flutter Developer Interview Questions and Answers

It was Python coding and Sql query assessment round.

Q1. Perform task on joins?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Use JOIN keyword to combine tables based on a common column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer
Q2. Explain projects
Ans. 
Projects are specific tasks or assignments that require a set of skills and resources to complete.
• Projects are temporary endeavors with a defined beginning and end.

• They are unique, with specific goals, deliverables, and constraints.

• Projects require a team of individuals with different roles and responsibilities.

• Examples: Developing a data pipeline for real-time analytics, building a recommendation system for an e-comme
Answered by AI
Add your answer

Q1. What is indexing in SQL?
Ans. 
Indexing in SQL is a technique used to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of data.

• They work similar to the index in a book, allowing the database to quickly find the rows that match a certain condition.

• Indexes can be created using a single column or a combination of columns.

• ...read more
Answered by AI
Add your answer
Q2. Lift capacity and passenger sql query
Add your answer
Q3. What is your experience in Pyspark , python
Ans. 
I have extensive experience in using Pyspark and Python for data engineering tasks.
• I have worked on various projects involving data processing, transformation, and analysis using Pyspark and Python.

• I am proficient in writing efficient and optimized code in Pyspark for big data processing.

• I have experience in handling large datasets and implementing complex data pipelines using Pyspark and Python.
Answered by AI
Add your answer
Q4. Tell me about architecture of the project that you are working on
Add your answer

Q1. Sql queries, python program and my clg background
Add your answer
Q2. Star pattern, codding and sql question oral
Add your answer

Q1. Joins , sub queries
Add your answer
Q2. Trigger, group by
Add your answer

Programing questiion star pattern

Q1. Explain Differnece between ETL AND ELT?
Ans. 
ETL is Extract, Transform, Load where data is extracted, transformed, and loaded in that order. ELT is Extract, Load, Transform where data is extracted, loaded, and then transformed.
• ETL: Data is extracted from the source, transformed in a separate system, and then loaded into the target system.

• ELT: Data is extracted from the source, loaded into the target system, and then transformed within the target system.

• ETL is sui...read more
Answered by AI
Add your answer
Q2. Explain the differnece between the difference?
Ans. 
The difference between the difference is the result of subtracting one value from another.
• Difference is the result of subtracting two values.

• The difference between two values can be positive, negative, or zero.

• For example, the difference between 10 and 5 is 5.
Answered by AI
Add your answer

Q1. Calculate repeating element in list
Ans. 
Find the repeating element in a list
• Iterate through the list and keep track of elements seen so far

• Use a hash set to efficiently check for duplicates

• Return the first element that is already in the set
Answered by AI
Add your answer
Q2. Calculate maximum salary in SQL
Ans. 
Use the MAX() function in SQL to calculate the maximum salary.
• Use the MAX() function along with the column name of the salary field.

• Example: SELECT MAX(salary) FROM employees;

• Ensure the correct table and column names are used in the query.
Answered by AI
Add your answer

Q1. SQL basic questions, Difference between types of join, Aggregate function, Triggers and cursors
Add your answer

Q1. Salary discussion with roles and responsiblity
Add your answer

Q1. What are advance types of join ?
Ans. 
Advanced types of join include outer join, self join, and cross join.
• Outer join: includes unmatched rows from one or both tables

• Self join: joins a table with itself

• Cross join: combines each row from one table with each row from another table
Answered by AI
Add your answer
Q2. Difference between having clause and where clause?
Ans. 
The WHERE clause is used to filter rows before grouping, while the HAVING clause is used to filter groups after grouping.
• WHERE clause is used with SELECT, UPDATE, and DELETE statements.

• HAVING clause is used with SELECT statements that include GROUP BY clause.

• WHERE clause filters individual rows based on conditions.

• HAVING clause filters groups based on conditions.

• WHERE clause is applied before the GROUP BY clause.

• HAVING...read more
Answered by AI
Add your answer
Q3. Differnce between join and union?
Ans. 
Join combines rows from two or more tables based on a related column, while union combines rows from two or more tables into a single result set.
• Join is used to combine rows from different tables based on a related column.

• Union is used to combine rows from two or more tables into a single result set.

• Join can be used with different types like inner join, left join, right join, etc.

• Union only combines rows with the same ...read more
Answered by AI
Add your answer
Q4. Basic oops concept ?
Add your answer
Q5. What are python data structure?
Ans. 
Python data structures are containers that hold and organize data in different ways.
• Some common Python data structures are lists, tuples, sets, and dictionaries.

• Lists are ordered and mutable, allowing duplicate elements.

• Tuples are ordered and immutable, useful for storing related data together.

• Sets are unordered and contain unique elements, useful for mathematical operations.

• Dictionaries are key-value pairs, providing
Answered by AI
Add your answer