American Broadcasting Company Interview Questions, Process, and Tips

Q1. Write sql query to find 3rd highest salary
Ans. 
SQL query to find 3rd highest salary
• Use the ORDER BY clause to sort salaries in descending order

• Use the LIMIT and OFFSET clauses to skip the first two highest salaries

• Select the salary from the table
Answered by AI
Add your answer
Q2. Difference between star schema and snowflake schema
Ans. 
Star schema has a single centralized fact table with denormalized dimensions, while snowflake schema has normalized dimensions in separate tables.
• Star schema is simpler and easier to understand, while snowflake schema allows for more flexibility and normalization.

• In star schema, dimensions are denormalized and directly connected to the fact table, while in snowflake schema, dimensions are normalized and split into mult...read more
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer

Q1. Tell me about cloud
Ans. 
Cloud computing is the delivery of computing services over the internet, offering resources like storage, databases, networking, and more.
• On-demand access to resources

• Scalability and flexibility

• Pay-as-you-go pricing model

• Examples: AWS, Azure, Google Cloud
Answered by AI
Add your answer
Q2. What are diff types of cloud
Ans. 
Types of cloud include public, private, hybrid, and community clouds.
• Public cloud: Services are delivered over the internet and shared among multiple customers (e.g. AWS, Azure, Google Cloud)

• Private cloud: Services are maintained on a private network and dedicated to a single organization (e.g. VMware, OpenStack)

• Hybrid cloud: Combination of public and private clouds, allowing data and applications to be shared between ...read more
Answered by AI
Add your answer
Q3. Roles and responsibilities
Add your answer

Q1. SQL based questions
Add your answer
Q2. SQL question
Add your answer

Q1. Current JD discussed with achievements
Add your answer

Q1. All technical discussion held
Add your answer

English, Coding, Pseudo code

Q1. String, Array, Linked list, Stack
Add your answer
Q2. Decision Making, creative, Verbal & Witten communication
Add your answer

Q1. Tell me something about your self
Add your answer
Q2. Where do you see yourself in next 5 years
Add your answer