10+ Leapup Edutech Interview Questions and Answers

Functions return a single value, while stored procedures can perform multiple operations.

• Functions return a single value, while stored procedures can return multiple values or perform operations.

• Functions can be used in SELECT statements, while stored procedures cannot be used in SELECT statements.

• Functions cannot modify the database state, while stored procedures can modify the database state.

• Functions can be called from within stored procedures, while stored procedures cann...read more

Avoid deadlocks by setting proper isolation levels, minimizing transaction duration, using indexes, and handling errors.

• Set appropriate isolation levels to prevent locks from escalating to deadlocks

• Minimize transaction duration to reduce the likelihood of deadlocks

• Use indexes to improve query performance and reduce the chance of deadlocks

• Handle errors gracefully to avoid leaving transactions in an inconsistent state

Master data fields and tables store key information about entities in a system.

• Fields typically include attributes like name, address, contact information, etc.

• Tables store records of entities with unique identifiers and corresponding data.

• Examples of master data tables include customer, product, employee, etc.

CTE is a temporary result set while views are permanent virtual tables.

• CTE is defined using WITH keyword, while views are defined using CREATE VIEW statement.

• CTEs can be referenced within the same query, while views can be referenced in multiple queries.

• CTEs are not stored as objects in the database, while views are stored as objects.

• CTEs are mainly used for complex queries or recursive queries, while views are used for simplifying queries and reusability.

To find the second highest salary, use the SQL query with the ORDER BY and LIMIT clauses.

• Write a SQL query to select the distinct salaries from the table.

• Order the salaries in descending order using the ORDER BY clause.

• Use the LIMIT clause to retrieve the second row from the result set.

Expected CTC should be based on industry standards, experience, skills, and responsibilities of the role.

• Consider industry standards for MS SQL DBA roles

• Take into account your level of experience and expertise

• Factor in the responsibilities and workload of the position

• Research average salaries for similar roles in your location

• Be prepared to justify your expected CTC based on your qualifications and value you bring to the role

An index is a data structure that improves the speed of data retrieval operations on a database table.

• Types of indexes include clustered, non-clustered, unique, and filtered indexes.

• Clustered indexes physically order the data in the table based on the index key.

• Non-clustered indexes store a separate copy of the indexed columns and a pointer to the actual data.

• Unique indexes ensure that no two rows have the same values in the indexed columns.

• Filtered indexes only include a sub...read more

Vendor customer Materila views refer to the perspectives and opinions of the vendor's customers on the materials provided by the vendor.

• Vendor customer Materila views can vary based on the quality, reliability, and cost-effectiveness of the materials supplied by the vendor.

• Customers may appreciate materials that meet their specific requirements and standards, leading to positive views of the vendor.

• On the other hand, if the materials are subpar or do not meet expectations, cu...read more

ISO and FSSC 22000 are both food safety management systems, but FSSC 22000 is more specific to the food industry.

• ISO is a generic standard for quality management systems, applicable to various industries.

• FSSC 22000 is a certification scheme specifically designed for the food industry.

• ISO focuses on overall quality management, while FSSC 22000 emphasizes food safety.

• ISO 9001 is a part of the ISO family, while FSSC 22000 is a standalone certification.

• ISO covers a broader range ...read more

Food safety refers to the practices and measures taken to ensure that food is safe for consumption and free from contamination.

• Food safety involves proper handling, storage, and preparation of food to prevent foodborne illnesses.

• It includes maintaining cleanliness and hygiene in food production, processing, and distribution.

• Food safety also involves monitoring and controlling potential hazards, such as biological, chemical, and physical contaminants.

• Examples of food safety pr...read more

Configuration of pricing involves setting up pricing procedures, condition types, access sequences, and condition records in SAP SD module.

• Define pricing procedures in SPRO transaction

• Create condition types for different pricing elements

• Set up access sequences to determine how system searches for condition records

• Maintain condition records for pricing in VK11 transaction

• Assign pricing procedures to sales document types

Output management with IDoc involves sending and receiving data between SAP systems and external systems.

• IDocs are used for exchanging data between SAP systems and external systems

• Output management involves sending and receiving IDocs for various business processes

• IDocs can be used for sending sales orders, invoices, delivery notes, etc.

• Output determination in SAP SD can trigger the creation of IDocs for communication with external systems

MRP stands for Material Requirements Planning, which is a system used to manage and plan the materials needed for production. BOM stands for Bill of Materials, which is a list of all the components needed to manufacture a product.

• MRP helps in determining the quantity and timing of materials needed for production

• BOM lists all the raw materials, components, and sub-assemblies required to manufacture a product

• MRP and BOM are essential tools in production planning and inventory m...read more

A work center description provides an overview of the tasks and responsibilities associated with a specific work area or department.

• Includes information on the purpose of the work center

• Describes the roles and responsibilities of employees in the work center

• Outlines the tasks and activities that are typically performed in the work center

CDC in Snowflake refers to Change Data Capture, a feature that captures and replicates changes made to data in real-time.

• CDC in Snowflake allows for tracking and replicating changes made to data in real-time

• It helps in maintaining data consistency across different systems

• CDC can be used for data integration, data warehousing, and real-time analytics