Clarivate Intern 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

Reverse a linked list in pairs of three.

• Create a function that takes the head of the linked list as input.

• Traverse the linked list in pairs of three and reverse each pair.

• Update the head of the linked list to the new head after reversing each pair.

• Return the new head of the linked list.

Search a number in sorted rotated array.

• Use binary search to find the pivot point where the array is rotated

• Determine which half of the array the target number may be in

• Perform binary search on the appropriate half of the array to find the target number

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