Creative Enterprises Project Engineer Interview Questions and Answers

Demonstrate joining duplicate records in tables using different types of joins.

• Inner join will only return the matching records (1,1 and 2,2) from both tables.

• Left outer join will return all records from Table1 and matching records from Table2 (including Null values).

• Right outer join will return all records from Table2 and matching records from Table1 (including Null values).

• Full join will return all records from both ...read more

SCD stands for Slowly Changing Dimensions. It is a technique used in data warehousing to track changes in data over time.

• SCD is used to maintain historical data in a data warehouse

• There are three types of SCD: Type 1, Type 2, and Type 3

• Type 1 SCD overwrites old data with new data

• Type 2 SCD creates a new record for each change and maintains a history of changes

• Type 3 SCD adds new columns to the existing record to track ...read more

A program to convert a variable name from snake_case to camelCase and vice-versa.

• Split the input string by underscore (_) to get an array of words.

• For snake_case to camelCase conversion, capitalize the first letter of each word except the first one.

• For camelCase to snake_case conversion, insert an underscore (_) before each capital letter except the first one.

• Join the array of words with the appropriate delimiter to ge

Program to find the number whose occurrence is greater than N/2 in an array of integers.

• Take two inputs, one integer N and an array of integers.

• Loop through the array and count the occurrence of each number.

• Return the number whose occurrence is greater than N/2.

• If no such number found, return '-1'.

Program to return character and their occurrence in a string.

• Iterate through the string and count the occurrence of each character.

• Store the count in a dictionary or hashmap.

• Create a new string by concatenating the character and their count.

• Return the new string.