Fidelity International Technical Consultant Interview Questions and Answers

Q1. About Okta in general
Add your answer

Q1. About Okta and IAM flows and concepts in detail.
Add your answer

Q1. What are the different SQL joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• 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 tables

• CROSS J...read more
Answered by AI
Add your answer
Q2. What are CODS rule
Ans. 
CODS rule is a troubleshooting method used in technical support to identify and resolve issues.
• CODS stands for Cause, Observation, Diagnosis, Solution.

• It helps technical support engineers systematically identify the root cause of a problem and provide a solution.

• By following the CODS rule, engineers can efficiently troubleshoot and resolve technical issues.

• Example: If a customer reports slow internet connection, the en...read more
Answered by AI
Add your answer

Q1. Different Questions Related to project development
Add your answer

Q1. Personal Questions to judge the interest level,salary expectations
Add your answer

Use case will be given and we will be asked to develop features for the usecase

Q1. Technical questions related to your domain
Add your answer

Q1. Check your character and longitvity
Ans. 
I have a strong character and a proven track record of long-term commitment in my career.
• Consistently meeting project deadlines and exceeding expectations

• Receiving positive feedback from colleagues and supervisors

• Staying with the same company for several years and progressing in my role

• Handling challenging situations with professionalism and integrity
Answered by AI
Add your answer