Tcg Digital Solutions Interview Questions, Process, and Tips

ETL is a process of extracting data from various sources, transforming it and loading it into a target system. ELT is a process of extracting data from various sources, loading it into a target system and then transforming it.

• ETL involves transforming data before loading it into the target system

• ELT involves loading data into the target system before transforming it

• ETL is best suited for structured data

• ELT is best suit...read more

Normalisation in RDBMS is the process of organizing data in a database to reduce redundancy and improve data integrity. Polymorphism is the ability of an object to take on multiple forms. Encapsulation is the bundling of data and methods that operate on the data into a single unit.

• Normalisation in RDBMS involves breaking down a table into smaller tables and defining relationships between them to reduce redundancy.

• Query...read more

During my 1st internship, I worked as a marketing intern at a tech startup.

• Assisted in creating social media content and managing online campaigns

• Conducted market research and competitor analysis

• Participated in brainstorming sessions for new marketing strategies

Consulting is providing expert advice and guidance to help individuals or organizations solve problems or improve performance.

• Consulting involves analyzing a situation, identifying issues, and recommending solutions.

• Consultants often have specialized knowledge or expertise in a particular area.

• Consulting can be done in various industries such as management, IT, finance, and healthcare.

• Consultants work closely with clie...read more

Swapping two numbers without using a temporary variable.

• Use the XOR operation to swap two numbers without using a temporary variable.

• XOR the first number with the second number to get a temporary result.

• XOR the temporary result with the first number to get the second number.

• XOR the temporary result with the second number to get the first number.

R is a programming language commonly used for statistical analysis and data visualization.

• R has various built-in functions for data manipulation, statistical analysis, and graphical representation.

• Some commonly used functions in R include mean(), sum(), plot(), and lm().

• R also has packages that provide additional functions for specific tasks, such as dplyr for data manipulation and ggplot2 for data visualization.

The Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

• Start with two initial numbers, 0 and 1

• Each subsequent number is the sum of the two preceding ones

• Repeat this process to generate the desired number of terms

The question is about finding the light ball among 9 balls using a balance.

• Divide the 9 balls into 3 groups of 3 balls each.

• Compare any two groups on the balance.

• If the balance is balanced, the light ball is in the third group.

• If the balance is unbalanced, the light ball is in the lighter group.

• Repeat the process with the lighter group until the light ball is found.