American Broadcasting Company Senior Associate 1 Interview Questions and Answers

Q1. How many types of joins in sql
Ans. 
There are four types of joins in SQL: 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 table.

• FULL JOIN: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer
Q2. Diff between list and set
Ans. 
List is an ordered collection of elements with duplicates allowed, while set is an unordered collection of unique elements.
• List maintains the order of elements, while set does not guarantee any specific order.

• List allows duplicate elements, while set does not allow duplicates.

• List is implemented using classes like ArrayList, LinkedList, etc., while set is implemented using classes like HashSet, TreeSet, etc.
Answered by AI
Add your answer
Q3. Diff between map set
Ans. 
Map is a collection of key-value pairs where each key is unique, while a set is a collection of unique elements with no duplicate values.
• Map allows duplicate values but keys must be unique, while set does not allow duplicates.

• Map is accessed using keys, while set is accessed using elements.

• Example: Map - {1: 'apple', 2: 'banana'}, Set - {'apple', 'banana'}
Answered by AI
Add your answer
Q4. Write Fibonacci program
Ans. 
Fibonacci program generates the Fibonacci sequence up to a specified number of terms.
• Start with two variables initialized to 0 and 1

• Use a loop to calculate the next Fibonacci number by adding the previous two numbers

• Repeat the process until the desired number of terms is reached
Answered by AI
Add your answer

Basic dsa questions from leetcode

Q1. Basic dsa questions and puzzles
Add your answer

Q1. They directly explained workculture and asked same questions from previous two questions
Add your answer

Q1. Tell me about your self
Add your answer

Q1. About the Educational Qualification
Add your answer
Q2. About the English knowledge
Add your answer

Basic knowledge of the candidates

Program out put and input question

Giveing a situation and ask for the results

Discuss the question marketing and sales regarding

Discuss the previous working

Q1. Discuss the workings related questions
Add your answer
Q2. Marketing and sales regarding questions
Add your answer

Q1. Discuss the workings related questions
Add your answer

Inhance your knowledge

Q1. How do you seen yourself in next 5 years
Add your answer
Q2. Long term goals
Add your answer

Q1. About my experience, current ctc and expected ctc
Add your answer

Q1. About my day to day role in the previous company
Add your answer
Q2. Biggest campaign
Ans. 
My biggest campaign was a nationwide marketing campaign for a new product launch.
• Developed comprehensive marketing strategy

• Utilized multiple channels such as social media, TV, and print advertising

• Collaborated with influencers and brand ambassadors

• Analyzed data and adjusted tactics for optimal results
Answered by AI
Add your answer