American Broadcasting Company Data Analyst Interview Questions and Answers for Experienced

Normal general aptitude questions

DSA must and sql, python

Q1. Joins,Where,having
Add your answer

Q1. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of a particular column in a database table to their physical storage locations on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that satisfy a certain condit...read more
Answered by AI
Add your answer

Q1. Asked about the projects from the resume. It was based on Python. The project was stock prediction using ml. They mainly asked about the concepts used. And they also asked the equations related to data sci...read more
Add your answer

Q1. I didn't qualified for this round
Add your answer

Related to programming language python SQL .net

Q1. Technical questions about the tools
Add your answer

Q1. Normal discussion about their policy salary
Add your answer

Q1. Basic Machine Learning Question
Add your answer
Q2. Ask about Previous work or project
Add your answer

Pandas and SQL questions and some business case

Q1. The head of the vertical took interview, explained role and asked about my experience.
Add your answer
Q2. What project did you work on?
Add your answer

Q1. A senior data scientist asked technical questions on my experience.
Add your answer
Q2. What is the advantage or lstm over rnn.
Ans. 
LSTM has better memory retention than RNN.
• LSTM can remember long-term dependencies better than RNN.

• LSTM has a gating mechanism that controls the flow of information.

• LSTM can handle vanishing gradient problem better than RNN.

• LSTM is more suitable for tasks that require long-term memory, such as speech recognition and language translation.
Answered by AI
Add your answer
Q3. What is multicollinearity and what are its effects?
Ans. 
Multicollinearity is a phenomenon where two or more independent variables in a regression model are highly correlated.
• It can lead to unstable and unreliable estimates of regression coefficients.

• It can make it difficult to determine the individual effect of each independent variable on the dependent variable.

• It can also result in inflated standard errors and p-values, making it difficult to identify statistically signif...read more
Answered by AI
Add your answer

Q1. What is Ram? What is Rom?
Ans. 
RAM stands for Random Access Memory, a type of computer memory that can be accessed randomly. ROM stands for Read-Only Memory, a type of memory that stores data permanently.
• RAM is volatile memory used by the computer to store data and program instructions temporarily.

• ROM is non-volatile memory that stores firmware and cannot be easily modified or deleted.

• RAM is faster but loses data when power is turned off, while ROM ...read more
Answered by AI
View 1 more answer
Q2. Which language understand the computer?
Ans. 
Computers understand machine language, which is a set of binary codes representing instructions that the computer can execute.
• Computers understand machine language, which consists of binary code representing instructions.

• High-level programming languages like Python, Java, C++ are used to write code that is then translated into machine language.

• Compilers and interpreters are used to convert high-level code into machine
Answered by AI
View 1 more answer

Q1. What is the machine language?
Ans. 
Machine language is the lowest-level programming language that directly corresponds to instructions executed by a computer's CPU.
• Machine language consists of binary code representing instructions that can be executed by a computer's central processing unit (CPU)

• It is the lowest-level programming language and is specific to the type of CPU being used

• Machine language is difficult for humans to read and write, as it is co...read more
Answered by AI
View 1 more answer

Q1. What does BIOS works for?
Ans. 
BIOS works as a firmware that initializes hardware components during the boot process of a computer.
• BIOS stands for Basic Input/Output System

• It is responsible for initializing and testing hardware components like the CPU, memory, and storage devices

• BIOS also provides the necessary instructions for the operating system to boot up

• It is stored on a ROM chip on the motherboard
Answered by AI
View 1 more answer