10+ SG Technologies Interview Questions and Answers

To find customers who purchased the same item multiple times on the same day.

• Identify unique customers who purchased the same item multiple times on the same day

• Check for duplicate transactions by customer and item on the same day

• Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day

The query selects all columns and calculates the total amount for each customer in table t2.

• The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

• The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

• The 'select *' statement selects all columns from the table along with the calculated total amount.

• The 'sum(amt) over (partition by customer)' calculates the total amount for each cust...read more

In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.

• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: SELECT * FROM employees WHERE department = 'IT';

I would highlight the benefits of an android touch screen phone such as ease of use, access to apps, and staying connected with family and friends.

• Explain the convenience of touch screen technology for easier navigation and typing

• Demonstrate the wide range of apps available for entertainment, communication, and utility

• Emphasize the importance of staying connected with family and friends through messaging and video calls

Accounting is the process of recording, summarizing, and analyzing financial transactions of a business. A balance sheet is a financial statement that shows a company's assets, liabilities, and equity at a specific point in time.

• Accounting involves recording financial transactions, summarizing them in financial statements, and analyzing the results.

• A balance sheet is a financial statement that shows a company's assets (what it owns), liabilities (what it owes), and equity (th...read more

Accounting is the process of recording, classifying, and summarizing financial transactions to provide information that is useful in making business decisions. Inventory refers to the goods and materials that a business holds for the ultimate purpose of resale.

• Accounting involves keeping track of financial transactions such as sales, purchases, and expenses

• Inventory management involves tracking the quantity and value of goods a business has on hand

• Accounting and inventory are...read more

I would highlight the benefits of using a duster for cleaning and dusting tasks.

• Explain how a duster can easily remove dust and dirt from surfaces

• Mention the convenience of using a duster for hard-to-reach areas

• Highlight the effectiveness of a duster in reducing allergens and improving air quality

A bill is a request for payment, while an invoice is a detailed record of a transaction.

• A bill is typically sent before payment is due, while an invoice is sent after a transaction has occurred.

• A bill may include a summary of charges, while an invoice provides a detailed breakdown of the goods or services provided.

• Invoices are often used for accounting and tax purposes, while bills are more commonly used in everyday transactions.

• For example, a restaurant may give a customer a...read more

There are four types of GST in India - CGST, SGST, IGST, and UTGST. They are used for different types of transactions.

• CGST is levied by the central government on intra-state transactions

• SGST is levied by the state government on intra-state transactions

• IGST is levied by the central government on inter-state transactions

• UTGST is levied by the union territories on intra-state transactions

• GST is used to replace multiple indirect taxes like excise duty, service tax, VAT, etc.

• It is...read more

GST stands for Goods and Services Tax, a value-added tax levied on most goods and services sold for domestic consumption.

• GST is a consumption tax that is imposed on the supply of goods and services.

• There are different types of GST, such as CGST (Central Goods and Services Tax), SGST (State Goods and Services Tax), and IGST (Integrated Goods and Services Tax).

• CGST is collected by the central government, SGST by the state government, and IGST on inter-state supplies.

• GST has rep...read more

Vyapar in marketing refers to the process of conducting business or trade.

• Vyapar involves buying and selling goods or services.

• It includes activities such as advertising, promotion, and distribution.

• Vyapar aims to attract customers and generate revenue for the business.

• Examples of vyapar in marketing include running social media campaigns, participating in trade shows, and offering discounts to customers.

To productinize Data Pipelines, one must automate, monitor, and scale the pipeline for efficient and reliable data processing.

• Automate the data pipeline using tools like Apache Airflow or Kubernetes

• Monitor the pipeline for errors, latency, and data quality issues using monitoring tools like Prometheus or Grafana

• Scale the pipeline by optimizing code, using distributed computing frameworks like Spark, and leveraging cloud services like AWS Glue

• Implement data lineage tracking to...read more

To complete your target, set specific goals, create a plan, prioritize tasks, track progress, and adjust as needed.

• Break down the target into smaller, achievable goals

• Create a plan with deadlines and milestones

• Prioritize tasks based on importance and urgency

• Track progress regularly and make adjustments as needed

• Celebrate milestones and successes along the way

Perfect singleton design pattern ensures only one instance of a class is created and provides a global point of access to it.

• Private constructor to prevent direct instantiation

• Private static instance variable

• Public static method to access the instance

• Lazy initialization to create the instance only when needed

• Thread-safe implementation to prevent multiple instances in a multi-threaded environment

BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data.

• BigQuery uses a distributed architecture to process and analyze large datasets quickly.

• It allows users to run SQL-like queries on datasets stored in Google Cloud Storage.

• BigQuery automatically scales to handle large amounts of data and can be integrated with other Google Cloud services.

• It supports real-time data streaming for up-to-date analysis.

• Users are billed based ...read more

Rotate a matrix by 90 degrees in place

• Transpose the matrix

• Reverse each row of the transposed matrix

Event loop is a mechanism in JavaScript that allows for asynchronous operations to be executed in a non-blocking way.

• Event loop is responsible for handling the execution of code in JavaScript.

• It allows for asynchronous operations to be executed without blocking the main thread.

• Tasks are added to the event queue and executed in the order they were added.

• Event loop continuously checks the call stack and the event queue to determine which task to execute next.

Quick sort is a popular sorting algorithm that uses divide and conquer strategy.

• Divides array into smaller sub-arrays based on a pivot element

• Recursively sorts sub-arrays

• Combines sorted sub-arrays to get final sorted array

• Time complexity: O(n log n) on average, O(n^2) worst case

• Example: [3, 6, 8, 10, 1, 2, 1] -> [1, 1, 2, 3, 6, 8, 10]