Ihg Group Process Specialist Interview Questions and Answers

Extract 'oyo' from domain name in Google Sheets.

• Use the formula =REGEXEXTRACT(A1, "oyo") where A1 is the cell containing the domain name.

• This will extract the first occurrence of 'oyo' in the domain name.

• If 'oyo' appears multiple times, use =REGEXEXTRACT(A1, "oyo", 2) for the second occurrence, and so on.

Time() is a SQL function that returns the current system date and time.

• Time() can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• The returned value is in the format 'YYYY-MM-DD HH:MI:SS'.

• Timezone can affect the returned value.

• Example: SELECT Time() AS CurrentTime;

Yes

• The English language is a West Germanic language that originated in England.

• It is the third most spoken language in the world, with over 1.3 billion speakers.

• English has a large vocabulary and is known for its complex grammar rules.

• It is the official language of many countries and widely used in international communication.

• English has various dialects and accents, including British English, American English, and Aus

I carry a positive and proactive attitude towards my work and team.

• I believe in leading by example and always strive to maintain a positive outlook.

• I am proactive in identifying and addressing challenges, finding solutions, and motivating my team to do the same.

• I foster a collaborative and supportive environment where everyone feels valued and motivated.

• I am open to feedback and continuously seek opportunities for pers...read more