
TCS


30+ TCS Developer Interview Questions and Answers
Q1. How setup network in lab anf what equipment u required?
To setup a network in a lab, you need equipment and a plan.
Determine the network topology and design
Choose appropriate networking equipment such as routers, switches, and cables
Configure network settings such as IP addresses and subnet masks
Test the network to ensure connectivity and functionality
Consider security measures such as firewalls and access control
Examples of equipment: Cisco routers, Juniper switches, Cat6 Ethernet cables
Q2. difference between function and store procedure?
Functions return a value while stored procedures do not.
Functions can be used in SQL statements while stored procedures cannot.
Functions can be called from within stored procedures.
Functions can be used in views while stored procedures cannot.
Functions can have input parameters while stored procedures can have both input and output parameters.
Q3. What is OPPS and explain each one of them
OPPS stands for Object-Oriented Programming Principles. It includes concepts like encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling of data and methods into a single unit (class) to hide implementation details.
Inheritance: Ability of a class to inherit properties and methods from another class.
Polymorphism: Ability to use a single interface to represent different types of objects.
Abstraction: Simplifying complex systems by breaking them down in...read more
Q4. How you identity the bot is ready to run?
The bot is ready to run when it has completed all necessary initialization processes.
Check if all required dependencies have been installed
Ensure all necessary configurations have been set up
Verify that the bot can connect to any required APIs or databases
Test the bot's functionality to ensure it is working as expected
Q5. Write code to find the difference between two dates.
Code to find the difference between two dates.
Use a date library like moment.js or date-fns
Subtract the earlier date from the later date to get the difference
Convert the difference to the desired format (days, hours, etc.)
Q6. What is composition and aggregation relationship
Composition is a strong relationship where the child object cannot exist without the parent object. Aggregation is a weak relationship where the child object can exist independently.
Composition is a 'has-a' relationship, where the parent object owns the child object.
Aggregation is a 'has-a' relationship, where the child object is a part of the parent object.
In composition, the child object's lifetime is managed by the parent object.
In aggregation, the child object's lifetime ...read more
Q7. Do you know m scripting? What is based workspace.
M scripting is a programming language used for data manipulation and analysis. Based workspace is a feature in M scripting for managing data and variables.
M scripting is a programming language used in Power Query for data transformation and manipulation.
Based workspace in M scripting allows users to manage data and variables in a structured manner.
Examples of M scripting functions include Table.AddColumn, Table.TransformColumns, and List.Transform.
Q8. Write code to transpose a Matrix
Code to transpose a matrix
Iterate through rows and columns of the matrix
Swap the elements at (i,j) and (j,i) positions
Return the transposed matrix
Q9. tell me 4 pillars of c++?
The 4 pillars of C++ are Abstraction, Encapsulation, Inheritance, and Polymorphism.
Abstraction: Hiding implementation details and showing only necessary information.
Encapsulation: Binding data and functions together to prevent external interference.
Inheritance: Creating new classes from existing ones, inheriting their properties and methods.
Polymorphism: Using a single interface to represent multiple types of objects.
Q10. how many types of joining?exmplae
There are four types of joining in SQL: Inner Join, Left Join, Right Join, and Full Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Join returns all the rows from both tables, with NULL values in the columns where there is no match.
Examples: Inner Join - SELECT * FROM table1 IN...read more
Q11. What are stages and n process studio?
Stages are the different phases of a process in nProcess Studio, a software development tool for creating business applications.
nProcess Studio is a software development tool used for creating business applications
Stages are the different phases of a process in nProcess Studio
Each stage represents a step in the process and can have its own set of rules and actions
Examples of stages include 'Data Entry', 'Validation', and 'Approval'
Stages can be customized to fit the specific ...read more
Q12. what is querry string ?how we use that?
A query string is a part of a URL that contains data to be passed to a web server.
It starts with a question mark (?) and is followed by key-value pairs separated by ampersands (&).
It is commonly used to filter or sort data on a web page.
Example: www.example.com/search?q=apple&category=fruit
To use it, simply append the query string to the end of the URL.
Q13. Swap value of two variables without a third variable
To swap values of two variables without a third variable, use arithmetic operations.
Use addition and subtraction to swap values
Example: a = 5, b = 10. a = a + b (a = 15), b = a - b (b = 5), a = a - b (a = 10)
Q14. what is response.redirect?
response.redirect is a method used in web development to redirect the user to a different URL.
response.redirect is used to redirect the user to a different URL
It is commonly used in web applications to redirect users after a successful login or when accessing restricted pages
The method can be used with different programming languages and frameworks, such as ASP.NET, PHP, and Node.js
The redirected URL can be specified as an absolute or relative path
Q15. what is unique key
A unique key is a field or combination of fields in a database table that uniquely identifies each record.
A unique key ensures that no two records in a table have the same values for the specified field(s).
It can be a single field or a combination of fields.
It is used to enforce data integrity and prevent duplicate records.
Examples include primary keys, candidate keys, and alternate keys.
Q16. what is asp.net life cycle?
ASP.NET life cycle is the series of events that occur during the processing of a request.
ASP.NET life cycle includes stages like initialization, page rendering, and disposal.
During initialization, the page and its controls are created and initialized.
During page rendering, the page is processed and HTML is generated.
During disposal, resources used by the page are released.
Events like Page_Load and Page_PreRender occur during the life cycle.
Understanding the life cycle is impo...read more
Q17. what is the view state?
View state is a hidden state of the page that stores values of controls and other page-specific data.
View state is used to maintain the state of server-side controls between postbacks.
It is stored in a hidden field on the page and is encrypted for security purposes.
View state can be disabled to improve performance, but this may cause issues with control state.
Example: A user fills out a form, but then navigates away from the page. When they return, their form data is still th...read more
Q18. what is constraint?
A constraint is a limitation or restriction on something.
Constraints can be applied in various fields such as software development, engineering, and project management.
In software development, constraints can include limitations on memory usage, processing speed, and storage capacity.
In engineering, constraints can include limitations on materials, dimensions, and weight.
In project management, constraints can include limitations on time, budget, and resources.
Examples of cons...read more
Q19. what is cond parameter?
The cond parameter is a conditional parameter used in programming to evaluate a series of conditions and return a value based on the first condition that is true.
Cond parameter is commonly used in programming languages like Lisp and Clojure.
It takes a series of pairs where the first element is a condition and the second element is the value to return if the condition is true.
Example: (cond ((= x 0) 'zero) ((= x 1) 'one) (true 'other))
Q20. what is exceptional handling
Exception handling is the process of responding to unexpected events or errors in a program.
Exception handling allows developers to gracefully handle errors and prevent crashes in a program.
It involves using try, catch, and finally blocks to handle exceptions.
Examples include catching a divide by zero error or a file not found exception.
Q21. what is polymerphism
Polymorphism is the ability of an object to take on many forms.
Polymorphism allows objects of different classes to be treated as if they were objects of the same class.
It is achieved through method overriding and method overloading.
Example: A parent class Animal can have child classes like Dog, Cat, and Bird. Each child class can have its own implementation of the method 'makeSound'.
Polymorphism makes code more flexible and reusable.
Q22. what is null indicator
Null indicator is a flag used to indicate whether a value is null or not in database systems.
Null indicator is used in database systems to handle null values efficiently.
It is typically a single bit flag associated with a data field.
A null indicator value of 0 indicates that the corresponding value is not null, while a value of 1 indicates it is null.
Q23. Explain oops concept with example
OOPs concept is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
OOPs stands for Object-Oriented Programming
Key concepts include encapsulation, inheritance, and polymorphism
Example: Inheritance - a class 'Animal' can be inherited by classes like 'Dog' and 'Cat'
Q24. what is session?
Session is a way to store and retrieve user data between HTTP requests.
Session is a temporary storage of user data on the server side.
It is identified by a unique session ID which is stored in a cookie or URL parameter.
Session data can be used to maintain user state, such as login status or shopping cart contents.
Q25. what is oops concept
Object-oriented programming paradigm focusing on objects and classes for code organization and reusability.
Encapsulation: bundling data and methods that operate on the data into a single unit (class)
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
Abstraction: hiding the complex implementation details and showing only the necessary features
Q26. what is procedures
Procedures are a set of instructions or steps to be followed in order to complete a task or achieve a goal.
Procedures help in organizing tasks and ensuring consistency in execution.
They can be written in a formal document or informally communicated.
Examples include cooking recipes, assembly instructions, and software development processes.
Q27. Fibonacce sequence in java
Fibonacci sequence is a series of numbers where each number is the sum of the two preceding ones.
Create an array to store the Fibonacci sequence
Use a loop to calculate each number in the sequence by adding the previous two numbers
Start with 0 and 1 as the first two numbers in the sequence
Q28. Concept of oops.
OOPs is a programming paradigm that uses objects to represent real-world entities and encapsulates data and behavior.
OOPs stands for Object-Oriented Programming.
It focuses on the concept of objects, which have properties and methods.
Encapsulation, inheritance, and polymorphism are the three main pillars of OOPs.
Encapsulation refers to the practice of hiding data and methods within an object.
Inheritance allows objects to inherit properties and methods from other objects.
Polymo...read more
Q29. write code for fibinacci
Code to generate Fibonacci sequence
Use a loop to generate Fibonacci numbers
Start with 0 and 1 as the first two numbers
Add the previous two numbers to get the next number
Repeat until desired number of Fibonacci numbers are generated
Q30. Joins and its types
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
FULL JOIN returns rows when there is a match in one of the tabl...read more
More about working at TCS







Top HR Questions asked in TCS Developer
Interview Process at TCS Developer



Reviews
Interviews
Salaries
Users/Month

