Google Data Science Intern Interview Questions and Answers for Freshers

Normalization to BCNF ensures that every non-trivial functional dependency is satisfied.

• Identify all functional dependencies

• Eliminate partial dependencies

• Eliminate transitive dependencies

• Ensure every determinant is a candidate key

HAVING clause is used with GROUP BY to filter groups, WHERE clause is used to filter rows.

• HAVING clause is used with GROUP BY clause to filter groups based on aggregate functions.

• WHERE clause is used to filter rows based on conditions.

• HAVING clause is used after GROUP BY clause, while WHERE clause is used before GROUP BY clause.

• HAVING clause can use aggregate functions, while WHERE clause cannot.

• Example: SELECT categor...read more

Find the missing number from 1 million random numbers.

• Calculate the sum of all numbers from 1 to 1 million using the formula n(n+1)/2

• Calculate the sum of all the given numbers

• Subtract the sum of given numbers from the sum of all numbers to get the missing number

Data is used in various industries and sectors for analysis and decision-making.

• Data is used in finance to analyze market trends and make investment decisions.

• Data is used in healthcare to track patient outcomes and improve treatment plans.

• Data is used in marketing to analyze customer behavior and target advertising campaigns.

• Data is used in transportation to optimize routes and improve logistics.

• Data is used in educat...read more