Frankfinn Institute of Air Hostess Training Senior Associate Interview Questions and Answers

Quantity aptitude,general IQ level question

Current news paper question, how to improve university education level.

Q1. Self introduction, current affairs questions. Education level questions etc
Add your answer

Q1. How r u and explain urself
Add your answer

Q1. How do you think you are fit for the role ?
Add your answer

Q1. What is your expectations from the job ?
Add your answer

I'm trusting me I will pass this interview

Q1. General questions regarding self and work
Add your answer

Teach a topic of your choice

Q1. What are your salary expectations?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. Will you be comfortable staying away from home for the job?
Add your answer
Q2. Are you willing to travel?
Add your answer

Write a pivot dinamic column from rows in SQL server.

Q1. Clustered and non clustered indexing in SQL server
Ans. 
Clustered indexing physically reorders the data in the table, while non-clustered indexing creates a separate structure.
• Clustered indexing determines the physical order of data rows in a table based on the indexed column.

• Non-clustered indexing creates a separate structure that contains the indexed column's values and pointers to the actual data rows.

• Clustered indexes are faster for retrieval but slower for inserts and ...read more
Answered by AI
Add your answer
Q2. Nested loops in SQL server
Ans. 
Nested loops in SQL server are used to iterate through multiple levels of data.
• Nested loops are used when you need to iterate through a set of data within another set of data.

• They can be implemented using nested SELECT statements or JOIN clauses.

• Example: SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id WHERE t1.column = 'value'
Answered by AI
Add your answer

Repository pattern in asp.net core API