American Broadcasting Company Interview Questions, Process, and Tips

Q1. What are the methods used to optimize the performance of an SQL query?
Ans. 
Methods to optimize SQL query performance
• Use indexes on columns frequently used in WHERE clauses

• Avoid using SELECT * and only retrieve necessary columns

• Optimize joins by using appropriate join types (e.g. INNER JOIN, LEFT JOIN)

• Use EXPLAIN to analyze query execution plan and identify bottlenecks

• Avoid using functions in WHERE clauses as they can prevent index usage
Answered by AI
Add your answer
Q2. How would you implement LDAP, SAML, and Single Sign-On (SSO)?
Ans. 
Implementing LDAP, SAML, and SSO involves configuring authentication protocols for secure access.
• Set up LDAP server for centralized user authentication and authorization

• Configure SAML for single sign-on across multiple applications

• Integrate SSO solution like OAuth or OpenID Connect for seamless user experience
Answered by AI
Add your answer

Q1. Python Question on Lists, Dictionary
Add your answer
Q2. SQLquestion on querying the data from different tables using joins, group by.
Add your answer

1. Question of list, occurence of particular item
2. Select query with group by in sql

It was a good experience

Q1. About java and spring boot
Add your answer
Q2. About database and microservice
Add your answer

Q1. Asked about my salary expectation
Add your answer
Q2. Asked about company and current CTC
Add your answer

Q1. Sql joins differences and types
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• 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 tab...read more
Answered by AI
Add your answer
Q2. ADF activities and pipelines, IR
Add your answer

Q1. Reason for change of company
Ans. 
Seeking new challenges and growth opportunities in a different environment.
• Desire for career advancement

• Opportunity to work on new projects

• Seeking a better work-life balance

• Company culture mismatch

• Relocation to a new area
Answered by AI
Add your answer
Q2. Salary discussion
Add your answer