5.2 Transform Data in SQL Quiz

2. Evelyn, Jackson, and Oliver are working on a database project. They are stuck at a point where they need to merge two columns in SQL. Can you help them out? How can they concatenate two columns in SQL?

• CONCAT(column1, column2)

• ADD(column1, column2)

3. Imagine Olivia, Ava, and Isla are playing a game of 'SQL Function Trivia'. They come across a card that asks, 'What is the purpose of the SQL function 'SUBSTRING'?' Can you help them answer?

• To convert a string to uppercase

• To extract a substring from a string.

4. Charlotte, Ethan, and Olivia are having a friendly competition to see who can clean up their SQL code the fastest. They need to remove leading and trailing spaces from a string. Which SQL command should they use to win the competition?

• TRIM

• REMOVE

5. Grace, Rohan, and Isla are having a friendly debate about SQL functions. They are particularly interested in the difference between 'CAST' and 'CONVERT'. Can you help them out?

• The 'CAST' function is used to convert data types, while the 'CONVERT' function is used to convert data types and also allows for additional formatting options.

• The 'CAST' function is used for date and time manipulation, while the 'CONVERT' function is used for mathematical calculations.

6. Michael, Aria, and Lily are having a friendly competition to see who can replace a specific substring in a string with another substring in SQL the fastest. Which method should they use?

• They should use the REPLACE function

• They should use the MODIFY function

7. Scarlett, James, and Elijah are having a friendly competition to see who can write the longest SQL string! Which SQL function should they use to calculate the length of their strings?

• LEN()

• MAX()

8. Olivia, Lily, and James are having a friendly competition to see who can extract the year from a date in SQL the fastest. Can you help them out?

• SELECT EXTRACT(YEAR FROM your_date_column) AS year FROM your_table_name;

• SELECT DATEPART(YEAR, your_date_column) AS year FROM your_table_name;

9. Olivia, Zoe, and Charlotte are having a friendly debate about SQL functions. Olivia says that the 'COALESCE' function is used to return the first non-null value in a list of expressions. On the other hand, Charlotte thinks it's used to return the maximum value in a list of expressions. Who is correct?

• Olivia is correct.

• Charlotte is correct.

10. William, Ethan, and Avery are having a friendly competition to see who can transform rows into columns in SQL the fastest. What method should they use to achieve this?

• They should use the CONCAT function

• They should use the PIVOT function