American Broadcasting Company Data Analyst Interview Questions and Answers

Q1. What is sql in rdbms
Ans. 
SQL (Structured Query Language) in RDBMS (Relational Database Management System) is a language used to manage and manipulate data in databases.
• SQL is used to retrieve, insert, update, and delete data in a database

• It allows for creating and modifying database schemas

• SQL is a standard language for relational databases such as MySQL, PostgreSQL, and Oracle

• Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE
Answered by AI
Add your answer

Q1. What is CTE and explain in detail
Ans. 
CTE stands for Common Table Expressions, a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTEs are defined using the WITH keyword in SQL

• They help in simplifying complex queries by breaking them into smaller, more manageable parts

• CTEs can be recursive, allowing for hierarchical data to be queried easily

• They are commonly used in recursive queries, data manipulation, and r
Answered by AI
Add your answer

Q1. Where did you get to know about this
Ans. 
I found out about this opportunity through a job posting on LinkedIn.
• I came across the job posting while browsing through my LinkedIn feed

• I clicked on the job posting and read the details

• I applied for the position through the LinkedIn platform
Answered by AI
Add your answer

Logical reasoning and coding test

Python,Sql,excel,web scrapping

Normal aptitude test with coding

Assignment on excel and python

Q1. Question On Sql Queries, Power BI, Excel , Data Anaylsis
Add your answer

Q1. Tell me about yourself, Strength and weakness
Add your answer