i
TCS
Filter interviews by
Clear (1)
I was interviewed 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.
Precompilation unit is a compiled code that can be reused by multiple source files.
Precompilation unit is created by the compiler from the source code.
It contains the compiled code of header files and other dependencies.
It can be reused by multiple source files, reducing compilation time.
It is also known as precompiled header or PCH.
Example: stdafx.h in Visual Studio is a precompiled header file.
posted on 15 Feb 2016
The first 50 prime numbers are...
Start with 2, the first prime number
Check each odd number greater than 2
Use trial division to check if a number is prime
Stop when you have found 50 prime numbers
Sorting a file within a range
Use a sorting algorithm like quicksort or mergesort
Read the file and store the data in an array or list
Sort the array or list within the given range
Write the sorted data back to the file
I am a passionate software engineer with experience in developing web applications using various technologies.
Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular
Proficient in backend development with Node.js, Express, and MongoDB
Familiar with version control systems like Git and project management tools like Jira
posted on 27 Dec 2015
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge in algorithms and data structures
Passionate about learning new technologies and solving complex problems
I have worked on various projects including a web application for inventory management and a mobile app for fitness tracking.
Developed a web application using React for inventory management
Created a mobile app using Flutter for fitness tracking
Implemented RESTful APIs for communication between frontend and backend systems
My area of interest is artificial intelligence and machine learning.
I have experience in developing machine learning models for predictive analytics.
I am interested in natural language processing and computer vision applications.
I enjoy exploring deep learning algorithms and neural networks.
I have worked on projects involving recommendation systems and image recognition.
C++ is a high-level programming language with features like object-oriented programming, templates, and memory management.
C++ supports object-oriented programming concepts like encapsulation, inheritance, and polymorphism.
Templates allow generic programming and code reusability.
C++ provides low-level memory manipulation through pointers.
Standard Template Library (STL) provides a collection of classes and functions for ...
Big Data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big Data is characterized by the 3Vs - Volume, Velocity, and Variety.
It requires specialized tools and technologies such as Hadoop, Spark, and NoSQL databases.
Examples of Big Data include social media data, sensor data, and financial market data.
Program to reverse a string without using string function
Iterate through the string from end to start and append each character to a new string
Use a loop to swap the first and last characters, then move towards the middle until the entire string is reversed
Convert the string to a character array, then swap the first and last elements until the entire array is reversed
I was responsible for designing and implementing the project's database and backend functionality.
Designed the database schema and created the necessary tables
Implemented the backend functionality using Java and Spring framework
Collaborated with team members to integrate the frontend and backend components
Tested the application and fixed any bugs or issues that arose
Presented the project to the faculty and received pos
Keys in a database are unique identifiers used to establish relationships between tables and ensure data integrity.
Keys are used to uniquely identify records in a database table.
Primary keys are used to uniquely identify each record in a table.
Foreign keys establish relationships between tables.
Keys help enforce data integrity and maintain consistency in the database.
Examples of keys include primary keys, foreign keys,
Issues in cloud include security, downtime, vendor lock-in, and data privacy.
Security concerns such as data breaches and unauthorized access
Downtime and service interruptions affecting business operations
Vendor lock-in and limited flexibility in choosing cloud providers
Data privacy and compliance with regulations such as GDPR and HIPAA
Developed a web application for online shopping using React and Node.js
Implemented user authentication and authorization using JSON Web Tokens (JWT)
Used MongoDB as the database to store user and product information
Implemented a search feature using Elasticsearch to provide fast and accurate search results
Integrated Stripe payment gateway for secure online transactions
The flow diagram of my final year project showcases the step-by-step process of its execution.
The flow diagram illustrates the sequence of activities and their dependencies.
It helps in understanding the overall structure and logic of the project.
Each step in the diagram represents a specific task or action.
Arrows indicate the flow of control or data between different steps.
Decision points are represented by diamond-sha...
Normalisation reduces data redundancy and improves data integrity in a database.
Prevents data duplication and inconsistencies
Simplifies database maintenance and updates
Improves query performance
Enforces data integrity and consistency
Follows best practices for database design
Examples: breaking down a customer table into separate tables for orders, addresses, and payments
Examples: creating a separate table for product ca...
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge of algorithms and data structures
Familiar with agile development methodologies and version control systems like Git
I am a problem solver, team player, quick learner, detail-oriented, and have strong communication skills.
Problem solver - I enjoy tackling complex problems and finding innovative solutions.
Team player - I work well with others and value collaboration in achieving goals.
Quick learner - I am able to pick up new technologies and concepts quickly.
Detail-oriented - I pay attention to the smallest details to ensure high-qual...
Yes, I have a Bachelor's degree in Computer Engineering.
Bachelor's degree in Computer Engineering
Experience in software development
Knowledge of engineering principles applied to software design
My day was productive and challenging, with a lot of problem-solving and collaboration.
Completed a major coding project ahead of schedule
Participated in a brainstorming session with team members
Solved a tricky bug in the codebase
Attended a virtual meeting with stakeholders
No, I do not have any relatives in Pune. I have arranged for my accommodation in a rented apartment near the office.
No relatives in Pune
Accommodation arranged in a rented apartment near the office
Yes, My Passion Challenge test is a coding competition for software engineers.
My Passion Challenge test is a coding competition that evaluates the coding skills of software engineers.
It is designed to test problem-solving abilities, algorithmic thinking, and coding proficiency.
Participants are given a set of coding challenges to solve within a specified time limit.
The challenges can range from simple to complex, coveri...
Considering pursuing a Master's degree in Computer Science to deepen knowledge and advance career.
Considering pursuing a Master's degree in Computer Science
To deepen knowledge and advance career
Examples: MS in Computer Science at XYZ University, online courses in AI and Machine Learning
based on 7 interviews
1 Interview rounds
based on 10 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹0 L/yr - ₹0 L/yr |
IT Analyst
66.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
AST Consultant
51.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
29.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Amazon
Wipro
Infosys
Accenture