i
TCS
Filter interviews by
I applied via Naukri.com and was interviewed before Mar 2023. There were 2 interview rounds.
Structure Query Language (SQL) is a standard language for managing and manipulating databases.
SQL is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables.
It is a declarative language, meaning users specify what they want to retrieve or modify without needing to specify how to do it.
Common SQL commands include SELECT, INSERT, UPDATE, DELETE, and CREATE.
Example:...
To write a join, use the JOIN keyword followed by the table name and the ON keyword to specify the join condition.
Use the JOIN keyword to combine rows from two or more tables based on a related column between them
Specify the join condition using the ON keyword followed by the columns to join on
Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
Aggregate functions are used in SQL queries to perform calculations on groups of rows and return a single result.
Examples of aggregate functions include SUM, AVG, COUNT, MIN, and MAX.
These functions are commonly used with the GROUP BY clause to group rows based on a specified column.
Table partitions are a way to divide a large table into smaller, more manageable parts.
Table partitions help improve query performance by allowing data to be stored and accessed more efficiently.
Partitions can be based on a range of values (e.g. dates) or a list of values (e.g. regions).
They can also be used for easier data management, such as archiving old data or isolating specific data for security purposes.
posted on 15 Sep 2023
I applied via Recruitment Consulltant and was interviewed in Mar 2023. There were 4 interview rounds.
An IP address is a unique numerical label assigned to each device connected to a computer network.
IP address stands for Internet Protocol address.
It is used to identify and locate devices on a network.
There are two types of IP addresses: IPv4 and IPv6.
Example of IPv4 address: 192.168.1.1
Example of IPv6 address: 2001:0db8:85a3:0000:0000:8a2e:0370:7334
posted on 8 Jan 2025
posted on 6 Jul 2024
The test is about grammatical knowledge.
Ethernet is a networking technology commonly used for connecting devices in a local area network (LAN).
Ethernet is a system for connecting a number of computer systems to form a local area network (LAN).
It uses a protocol called CSMA/CD (Carrier Sense Multiple Access with Collision Detection) to manage traffic on the network.
Ethernet cables are commonly used to physically connect devices to a network switch or router.
E...
A network is a collection of computers, servers, mainframes, network devices, and other devices connected to one another to share data and resources.
Networks can be wired or wireless
Common types of networks include LAN (Local Area Network) and WAN (Wide Area Network)
Networks can be private (intranet) or public (internet)
Examples of network devices include routers, switches, and modems
posted on 21 May 2024
I applied via Approached by Company
Talk about one of three topics for 2 mins
DHCP is a network protocol that automatically assigns IP addresses to devices, DNS translates domain names to IP addresses, routers connect networks, gateways connect networks with different protocols, booting into safe mode allows troubleshooting.
DHCP automatically assigns IP addresses to devices on a network
DNS translates domain names to IP addresses for easier access
Routers connect different networks together to ena...
IP address is a unique identifier assigned to each device connected to a network. Classes of IP include A, B, C, D, and E. Workgroup and domain are network organization structures. BSOD is Blue Screen of Death.
IP address is a unique numerical label assigned to each device on a network
Classes of IP include A, B, C, D, and E with different ranges of addresses
Workgroup is a peer-to-peer network where each computer has its...
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
I applied via Job Portal and was interviewed in May 2024. There were 3 interview rounds.
Speak about any of your interested for 2 minutes
I applied via Company Website and was interviewed in Aug 2022. There were 3 interview rounds.
A firewall is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules.
Firewalls can be hardware or software-based
They can be configured to block or allow traffic based on IP addresses, ports, protocols, and other criteria
Firewalls can also be used to create virtual private networks (VPNs) for secure remote access
IP binding is the process of associ...
I m best computer hadware and network troubleshooting team leader
I applied via Atos and was interviewed before Jun 2023. There was 1 interview round.
based on 1 interview
Interview experience
based on 6 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
67k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.3k
salaries
| ₹8 L/yr - ₹25 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.7 L/yr |
Associate Consultant
29.1k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture