DaMENSCH Interview Questions and Answers

Q1. Tell me about your current role
Add your answer
Q2. Tell me about to current company and what it does.
Add your answer

Q1. About Experience, knowledge, salary,
Add your answer

Q1. Distribution & Dealers planning and growth
Add your answer

All abouts skill, strength, experience, system knowledge, growth

Q1. Self introduction and about my previous job
Add your answer

Q1. Basic Introduction and previous work experience
Add your answer
Q2. What is SQL and which memory management it use?
Ans. 
SQL is a programming language used for managing relational databases. It uses dynamic memory management.
• SQL stands for Structured Query Language

• It is used for managing and manipulating data in relational databases

• SQL uses dynamic memory management, which means that memory is allocated and deallocated as needed

• Examples of SQL-based relational database management systems include MySQL, Oracle, and Microsoft SQL Server
Answered by AI
Add your answer
Q3. What is RDBMS and why we use SQL?
Ans. 
RDBMS is a relational database management system that organizes data into tables. SQL is used to query and manipulate data in RDBMS.
• RDBMS stands for Relational Database Management System

• It organizes data into tables with rows and columns

• SQL (Structured Query Language) is used to interact with RDBMS

• SQL allows querying, inserting, updating, and deleting data

• RDBMS and SQL provide a structured and efficient way to store an
Answered by AI
View 1 more answer
Q4. How to you check which query is good?
Ans. 
To check which query is good, consider factors like execution time, resource usage, and accuracy of results.
• Check the execution time of the query and compare it with other queries.

• Analyze the resource usage of the query, such as CPU and memory usage.

• Check the accuracy of the results and compare them with the expected output.

• Consider the complexity of the query and its impact on the database.

• Take into account the scalab...read more
Answered by AI
Add your answer
Q5. What is the use of aggregation functions?
Ans. 
Aggregation functions are used to perform calculations on a set of values and return a single value as output.
• Aggregation functions are commonly used in databases and data analysis to summarize and analyze large amounts of data.

• Examples of aggregation functions include SUM, AVG, MAX, MIN, COUNT, and GROUP BY.

• These functions can be used to calculate totals, averages, maximum and minimum values, and counts of specific da...read more
Answered by AI
Add your answer
Q6. When can we use group by? Can we use group by without where clause?
Ans. 
Group by is used to group data based on a common attribute. It can be used without a where clause.
• Group by is used to group data based on a common attribute

• It is used with aggregate functions like sum, count, avg, etc.

• It can be used without a where clause to group all the data in the table

• Group by is often used with having clause to filter the groups based on some condition
Answered by AI
Add your answer
Q7. What is normalisation?
Ans. 
Normalisation is the process of organizing data in a database to reduce redundancy and dependency.
• It involves breaking down a table into smaller tables and defining relationships between them.

• The goal is to eliminate data redundancy and ensure data consistency.

• Normalization is achieved through a series of normal forms, with each level building on the previous one.

• For example, a customer's address should not be repeated...read more
Answered by AI
Add your answer
Q8. What major libraries used in python?
Ans. 
Python has several major libraries including NumPy, Pandas, Matplotlib, and Scikit-learn.
• NumPy is used for numerical computing and data analysis.

• Pandas is used for data manipulation and analysis.

• Matplotlib is used for data visualization.

• Scikit-learn is used for machine learning and data mining.
Answered by AI
Add your answer

Q1. Round 2 interview Interview duration was 1 hour. The interviewer asked me to write some ecommerce SQL queries given condition. (1 hour) 1) Find the pair of products that sells together in the cart. 2) To...read more
Add your answer