i
TCS
Filter interviews by
Clear (1)
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 Feb 2021. There were 3 interview rounds.
Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
OOPs stands for Object-Oriented Programming System
Java is a class-based OOPs language
Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs
Objects have state and behavior
Java supports interfaces, which allow for multiple inheritance
Example: A car can be represented as an object wit...
Java solves machine dependency by using bytecode and virtual machine.
Java code is compiled into bytecode which is platform-independent
The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific
JVM translates bytecode into machine code for the specific platform
This allows Java code to run on any platform with a JVM installed
Example: A Java program compiled on Windows can run on Linux or Mac as
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
It was a basic aptitude test.
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
- basic programming on C
based on 5 interviews
1 Interview rounds
based on 98 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
66.2k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.5k
salaries
| ₹8 L/yr - ₹25 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.8 L/yr |
Associate Consultant
29.6k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture