3m Digital Interview Questions and Answers

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