WNS Interview Questions, Process, and Tips

The question is asking about converting text to columns.

• Text to column is a feature in spreadsheet software that allows you to split a single column of text into multiple columns based on a delimiter.

• This feature is commonly used to separate data that is combined in a single cell into separate cells for easier analysis or manipulation.

• For example, if you have a column of full names in the format 'First Name Last Name',...read more

A delimiter in Excel is a character used to separate data in a cell or column.

• Common delimiters include commas, semicolons, and tabs.

• Delimiters can be used in functions like CONCATENATE and TEXTJOIN.

• Delimiters can also be used when importing or exporting data from Excel.

• Example: =CONCATENATE(A1,", ",B1) would join the values in cells A1 and B1 with a comma and space delimiter.

False. Approximation significance is not related to H&v lookup.

• Approximation significance is a statistical concept that measures the probability of obtaining a result by chance.

• H&v lookup is a function in Excel used to search for a value in a table.

• These two concepts are not related and therefore the answer is false.

Types of joins and their differences

• Inner join: returns only the matching rows from both tables

• Left join: returns all rows from the left table and matching rows from the right table

• Right join: returns all rows from the right table and matching rows from the left table

• Full outer join: returns all rows from both tables, with NULL values in place of non-matching rows

• Cross join: returns the Cartesian product of both tables

• ...read more

Where is used to indicate a location or position, while having is used to show possession or ownership.

• Where is used to ask about a place or location, while having is used to talk about something that someone possesses or owns.

• Where can also be used as a conjunction to introduce a subordinate clause that describes a location.

• Having can also be used as a gerund or present participle to describe an action of possessing o...read more

Explanation of different types of constraints and primary key vs foreign key

• Constraints are rules applied to columns to maintain data integrity

• Types of constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, and DEFAULT

• Primary key is a unique identifier for a row in a table, while foreign key is a reference to a primary key in another table

• Primary key cannot have null values, while foreign key can have n...read more