Maruti Suzuki Regional Training Center Interview Questions and Answers

A database is a collection of structured data organized for easy access, while a data warehouse is a centralized repository for storing and analyzing large volumes of data.

• Database is used for transactional processing and storing current data.

• Data warehouse is used for analytical processing and storing historical data.

• Database is typically used for day-to-day operations.

• Data warehouse is used for decision-making and business intelligence.

• Examples: MySQL, Oracle, SQL Server (d...read more

Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

• Window functions are used to perform calculations on a set of rows related to the current row in a query result.

• The LAG function is a window function that allows you to access data from a previous row in the result set.

• Example: SELECT employee_id, salary, LAG(salary) OVER (ORDER BY hire_date) AS prev_salary FROM employees;

DAX (Data Analysis Expressions) is a formula language used in Power BI to create custom calculations and aggregations.

• DAX is similar to Excel formulas but designed for more complex data analysis tasks

• It can be used to create calculated columns, measures, and calculated tables in Power BI

• DAX functions include aggregation functions like SUM, AVERAGE, and COUNT, as well as logical functions and date functions

• Example: CALCULATE function in DAX allows for applying filters to calcu...read more

Nested for loop used to iterate through a list of items

• Use a for loop to iterate through the main list

• Inside the first loop, use another for loop to iterate through each item in the sublist

• Example: for item in main_list: for sub_item in item: print(sub_item)

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table an...read more

Dependency Injection is a design pattern used in Spring Boot to inject dependencies into an object.

• Dependency Injection is a way to achieve loose coupling between objects

• It allows for easier testing and maintenance of code

• Spring Boot uses annotations like @Autowired and @Component to inject dependencies

• Constructor Injection, Setter Injection, and Field Injection are the three types of Dependency Injection

• Example: @Autowired private UserService userService;