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
I was interviewed in Jan 2025.
Hai iam ns,ramakrishna i can compately in dipoma in final deee branch 2023 in dipoma promated
The question seems to be asking about the timing of an appointment letter.
An appointment letter is typically sent out before a scheduled meeting or interview.
It is important to confirm the timing and details mentioned in the appointment letter.
If the appointment letter is not received on time, it is advisable to follow up with the sender.
I want to join this job because, I want to grow my career and enhance my skile and being a self independent
My strengthis my ability to stay organised and mange multiple tasks at once I have the projects dwon into smaller tasks and finding efficient ways to complete them and My weakness is that I something take too long finish tasks, but I am working on it.
A about my family background I have four members in my family including me my father is a farmer, my mother is a house wife also and my sister pursuing graduation
posted on 4 Feb 2025
I was interviewed in Jan 2025.
posted on 4 Dec 2024
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
posted on 20 Dec 2024
It was Easy to medium . overall good
It was Medium to tough level
FIFO (First In, First Out) and LIFO (Last In, First Out) are inventory management methods.
FIFO: Items that are added first are the first to be removed. Like a queue.
LIFO: Items that are added last are the first to be removed. Like a stack.
I would focus on improving access to quality education for all citizens.
Implementing policies to ensure equal opportunities for education
Investing in infrastructure and resources for schools in underserved areas
Providing scholarships and financial aid for students from low-income families
Promoting vocational training programs to address skills gaps in the workforce
posted on 24 Nov 2024
I applied via Job Portal and was interviewed in Oct 2024. There were 2 interview rounds.
First Round was assessment test round, Which includes English + Cognitive questions
posted on 8 Jan 2025
posted on 3 Sep 2024
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 2 interview rounds.
My favorite movie is The Shawshank Redemption.
Directed by Frank Darabont
Based on a Stephen King novella
Set in a prison in Maine
Themes of hope, friendship, and redemption
Starring Tim Robbins and Morgan Freeman
My favorite color is blue because it reminds me of the calming ocean and clear skies.
Blue is associated with calmness and tranquility
It symbolizes trust, loyalty, and confidence
Examples: navy blue, sky blue, royal blue
Power draining refers to the excessive consumption of power by a device or system, leading to decreased battery life or performance.
Power draining can occur due to background apps running constantly on a device.
Faulty hardware components can also contribute to power draining.
Settings such as high screen brightness or frequent data syncing can increase power draining.
Examples include a smartphone losing battery quickly ...
VPN stands for Virtual Private Network. It is used to create a secure connection over the internet, allowing users to access private networks remotely.
VPN encrypts data to ensure privacy and security
It allows users to access restricted websites or content
Commonly used for remote work, accessing company networks, and bypassing geo-restrictions
Examples include NordVPN, ExpressVPN, and Cisco AnyConnect
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
67.1k
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.6 L/yr |
Associate Consultant
29.1k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture