XimKart
Satyam Venture Engineering Services Interview Questions and Answers
Q1. What is the method to obtain a running total per month for a given sales data set, and how can the three-month moving average of total sales be calculated?
Running total per month can be obtained by summing the sales data for each month. Three-month moving average can be calculated by averaging the total sales for the current month and the two previous months.
To obtain a running total per month, sum the sales data for each month.
To calculate the three-month moving average of total sales, average the total sales for the current month and the two previous months.
Example: Running total for January = Sales in January, Three-month mo...read more
Q2. What is the difference between relational and non-relational databases, and can you provide examples of each?
Relational databases store data in tables with predefined relationships, while non-relational databases store data in flexible, schema-less formats.
Relational databases use structured query language (SQL) for querying data
Non-relational databases are more flexible and can store data in various formats like key-value pairs, documents, graphs, etc.
Examples of relational databases include MySQL, Oracle, and SQL Server
Examples of non-relational databases include MongoDB, Cassandr...read more
Q3. Which is more efficient: Common Table Expressions (CTEs) or Subqueries?
CTEs are generally more efficient than subqueries due to their ability to be reused and optimized by the query planner.
CTEs can be referenced multiple times within a query, reducing the need to repeat the same subquery logic.
CTEs can improve query readability and maintainability by breaking down complex logic into smaller, more manageable parts.
CTEs can be optimized by the query planner, potentially leading to better performance compared to subqueries.
Q4. Current Location
I am currently located in New York City.
I am based in New York City
I have been living in New York for the past 5 years
My current address is in Manhattan, New York
Q5. Reverse a stack using recursion
Reverse a stack using recursion
Use recursion to remove each element from the stack and store it in a temporary variable
Recursively call the reverse function on the remaining stack
Push the temporary variable back into the reversed stack
Q6. Design a Invoice generation system
Design a system for generating invoices.
Identify the necessary data for an invoice (e.g. customer information, item details, pricing)
Create a database schema to store invoice data
Develop a user interface for entering invoice information
Implement logic to calculate totals, taxes, and discounts
Generate a PDF or printable version of the invoice
Include functionality for tracking invoice status and payment
Consider security measures to protect sensitive data
Interview Process at Satyam Venture Engineering Services
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month