i
TCS
Filter interviews by
I applied via Company Website and was interviewed in Feb 2022. There were 2 interview rounds.
Replication is a process of copying and distributing data and database objects from one database to another.
Replication is used to improve the availability and scalability of databases.
It can be used for disaster recovery, reporting, and load balancing.
There are three types of replication: snapshot, transactional, and merge.
Snapshot replication copies the entire database to another server.
Transactional replication copi...
A cluster in SQL Server is a group of servers that work together to provide high availability and scalability.
A cluster is used to ensure that a database is always available, even if one server fails.
It allows for load balancing across multiple servers to improve performance.
SQL Server supports two types of clusters: failover clusters and active-active clusters.
Failover clusters have one active server and one or more s...
High availability techniques ensure system uptime and minimize downtime.
Redundancy of hardware and software components
Load balancing to distribute traffic across multiple servers
Clustering to provide failover capabilities
Disaster recovery planning to ensure business continuity
Automated monitoring and alerting to quickly identify and resolve issues
To fix log space and tempdb issues, I would increase the size of the log file and move tempdb to a separate drive.
Increase the size of the log file to prevent it from filling up too quickly
Move tempdb to a separate drive to improve performance and prevent it from competing with other databases for space
Regularly monitor and manage log space and tempdb usage to prevent future issues
Fragmentation is the process of breaking something into smaller pieces or parts.
Fragmentation can occur in various fields such as computer storage, memory, and databases.
In computer storage, fragmentation happens when files are broken into smaller pieces and scattered across different parts of the hard drive, making it slower to access the data.
In memory, fragmentation occurs when there are small gaps between blocks of...
Blocking occurs when one transaction holds a lock on a resource that another transaction needs, while a deadlock occurs when two or more transactions are waiting for each other to release locks.
Blocking occurs when a transaction is waiting for a resource that is locked by another transaction.
Deadlock occurs when two or more transactions are waiting for each other to release locks.
Blocking can be resolved by allowing th...
Performance tuning in SQL Server
Identify slow queries using SQL Profiler or DMVs
Optimize query execution plan using indexes and statistics
Reduce network latency by minimizing data transfer
Use stored procedures instead of ad-hoc queries
Consider partitioning large tables
Regularly monitor and maintain database health
I applied via Naukri.com and was interviewed before Oct 2022. There were 4 interview rounds.
I applied via LinkedIn and was interviewed in May 2022. There was 1 interview round.
What people are saying about TCS
I applied via Company Website and was interviewed before Sep 2021. There were 3 interview rounds.
Numerology and calculation based test held online.
Java based program test included 2 programs preparation within 1 hr
TCS interview questions for designations
I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.
The project involved designing and implementing a new network infrastructure for a large corporation.
Conducted a thorough analysis of the existing network infrastructure
Designed a new network architecture that met the company's needs
Implemented the new network infrastructure with minimal disruption to business operations
Tested and optimized the new network to ensure optimal performance
Provided ongoing support and maint
I applied via Campus Placement and was interviewed before Feb 2020. There was 1 interview round.
I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.
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;
based on 5 interviews
1 Interview rounds
based on 101 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