Interview question for Tcs

TCS (Tata Consultancy Service) Limited is an Indian multinational company which deals in consultancy service and Information technology. It is headquartered in Mumbai, India. It is a part of the Tata group and operates in 46 countries.
TCS is one of the largest Indian company by market capitalization and one of the most trusted Indian brands worldwide. It alone generates 70% of the dividends of its parent company Tata Sons.

1. What are different database Environments used in any project?

The Project to project database environment varies.But the following is basic environment structure used for projects.
1. Development Environment:
In Development Environment all developer works and development work is been done on development environment.
2. Test Environment:
Developers does not have access of test environment. After development is done the code is migrated to Test Environment. Testing team is working on Test environment and execute black box as well as white box test cases on this Environment. Sometimes System Integration Testing (SIT) is also done on this Environment.

2. What do you mean by inline function?

The idea behind inline functions is to insert the code of a called function at the point where the function is called. If done carefully, this can improve the application’s performance in exchange for increased compile time and possibly (but not always) an increase in the size of the generated binary executables.

3. What is Null in SQL?

A NULL value in a table is a value in a field that appears to be blank, which means a field with a NULL value is a field with no value.
It is very important to understand that a NULL value is different than a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation.

4. Explain the functionality of linked list?

A linked list consists of two parts: information and the link. In the single connected listening, the beginning of the list is marked by a unique pointer named start. This pointer does point to the first element of the list and the link part of each node consists of an arrow looking to the next node, but the last node of the list has null pointer identifying the previous node. With the help of start pointer, the linked list can be traversed easily.

5. What is not null constraint?

By default, a table column can hold NULL values. The NOT NULL constraint enforces a column to NOT accept NULL values. The NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new record, or update a record without adding a value to this field.

6. What is Polymorphism?

Polymorphism is a concept in OOPS which means having many forms. In simple words, it means that different actions will be performed in different instances. Polymorphism is of two types:
1. Method overloading
2. Operator overloading

7. What is friend function?

A friend for a class is used in object-oriented programming to allow access to public, private, or protected data in the class from the outside.
Normally, a function that is not a member of a class cannot access such information; neither can an external class. Occasionally, such access will be advantageous for the programmer. Under these circumstances, the function or external class can be declared as a friend of the class using the friend keyword.

8. Tell me something about abstract classes?

An abstract class is a class which does not fully represent an object. Instead, it represents a broad range of different classes of objects. However, this representation extends only to the features that those classes of objects have in common. Thus, an abstract class provides only a partial description of its objects.

9. Can you list out the areas in which data structures are applied extensively?

• Compiler Design,
• Operating System,
• Database Management System,
• Statistical analysis package,
• Numerical Analysis,
• Graphics,
• Artificial Intelligence,
• Simulation

10. What is software development life-cycle?

Software development life-cycle is steps involved in the life cycle of software development phase. Generally, it is followed by the development team which develops the software in the organization. It consists of a clear explanation of developing and maintaining the software.

11. What is normalization of databases, joins and keys?

Normalization is process of organizing data in a database efficiently. Two goals of the normalization process are: to eliminate redundant data (for example, storing the same data in more than one table) and also ensure data dependencies make sense (only storing related data in a table). These both are important as they reduce the amount of space a database consumes and ensure that data is logically stored.

12. What are WPF and WCF?

WPF/WCF application, need in .NET 3.0 Framework. These application will cover the following concepts:
WCF(Windows Communication Foundation)
o The new service orientated attributes
o The use of interfaces
o The use of callbacks
o Asynchronous delegates
o Creating the proxy
WPF ( Windows Presentation Foundation )
o Styles
o Templates
o Animations
o Databinding

13. What quality do you think a leader should have?

There are many qualities that a leader should have but to name a few, a leader should be able to coordinate a team, he should have excellent understanding of people and their behavior at different points of time, he should be able to find people he can depend on, he should be able to be distinguished in a crowd of people, he should be able to instruct a group of people, he should be dominant and many more are there.