i
TCS
Filter interviews by
I appeared for an interview in May 2024.
Optimizing SQL queries involves using indexes, minimizing data retrieval, and avoiding unnecessary joins.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using subqueries or temporary tables
Time travel is a theoretical concept that involves moving between different points in time.
Time travel is a popular theme in science fiction literature and movies.
The concept of time travel raises questions about causality and the nature of time.
Some theories suggest that time travel could be possible through wormholes or time machines.
The cache will be invalidated and refreshed when the query changes.
When the query changes, the cache will be invalidated to ensure accurate results.
The system will refresh the cache with the updated query results.
This helps prevent outdated or incorrect data from being served from the cache.
I would rate myself 8 out of 10 in SQL. I have strong knowledge and experience in writing complex queries and optimizing database performance.
Strong understanding of SQL syntax and commands
Experience in writing complex queries involving multiple tables and joins
Knowledge of database optimization techniques
Familiarity with Snowflake specific SQL functions and features
Cache is a hardware or software component that stores data to reduce future data retrieval time.
Cache is used to store frequently accessed data for quick retrieval.
Types of cache include CPU cache, web cache, and browser cache.
Cache helps improve performance by reducing the need to access data from slower storage mediums.
Examples of cache include L1, L2, and L3 caches in CPUs, and caching mechanisms in web browsers.
Cac...
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
Snowflake is a cloud-based data warehousing platform that offers features like data sharing, scalability, and performance.
Snowflake allows for easy data sharing between organizations and departments.
It offers scalability by allowing users to easily resize their computing resources based on their needs.
Snowflake provides high performance through its unique architecture that separates storage and compute.
It supports vari...
Types of caches include memory cache, disk cache, and browser cache.
Memory cache stores data in memory for quick access.
Disk cache stores data on disk for faster retrieval than from the original source.
Browser cache stores web page elements locally to reduce loading times.
Other types include CPU cache, page cache, and object cache.
What people are saying about TCS
TCS interview questions for designations
Get interview-ready with Top TCS Interview Questions
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
Good questions with detailed interview
Snowflake architecture is a cloud-based data warehousing platform that separates storage and compute resources for scalability and performance.
Snowflake uses a unique architecture with separate storage and compute layers.
Data is stored in scalable and durable storage, while compute resources can be scaled independently for processing.
Snowflake's architecture allows for automatic scaling, high performance, and concurren...
I applied via LinkedIn and was interviewed in Oct 2022. There were 2 interview rounds.
Variant data type is a flexible data type in Snowflake that can store semi-structured and nested data.
Variant data type can store JSON, Avro, ORC, and Parquet data formats.
It allows for querying and manipulating semi-structured data without the need for schema changes.
Example: A variant column can store a JSON object with nested arrays and objects.
Union combines rows from two or more tables, while join combines columns from two or more tables.
Union appends the rows of one table to another, while join combines columns of two tables based on a common column.
Union does not require a common column, while join requires a common column to match the rows.
Union removes duplicates, while join retains duplicates.
Union can be used to combine tables with different columns, ...
Snowflake architecture is a cloud-based data warehousing solution that separates storage, compute, and services.
Snowflake uses a unique multi-cluster, shared data architecture.
It separates storage, compute, and services, allowing for independent scaling.
Data is stored in a columnar format, allowing for efficient querying and analysis.
Snowflake also offers automatic scaling and concurrency control.
It supports multiple c...
The size of data loaded in bulk loading varies based on the file format and compression used.
The size of data loaded can range from a few MBs to several GBs.
The file format used can impact the size of data loaded.
Compression can reduce the size of data loaded.
Snowflake supports various file formats like CSV, JSON, Parquet, etc.
Examples: A CSV file of 1 GB can be loaded in a few minutes.
A compressed Parquet file of 10 G
The role with the highest level of access should create the custom role.
The role with the highest level of access should have the ability to manage roles and grant permissions.
This ensures that the custom role is created with the appropriate level of access and permissions.
For example, if the custom role is for a specific department, the department manager role should create it.
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
based on 7 interviews
1 Interview rounds
based on 11 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
66.1k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.8k
salaries
| ₹8 L/yr - ₹25 L/yr |
Associate Consultant
30k
salaries
| ₹9 L/yr - ₹32 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.8 L/yr |
Amazon
Wipro
Infosys
Accenture