Quiz for Pivoting Data

Q1: Which SQL operation is used to transform rows into columns?

A. UNION B. JOIN C. PIVOT D. ORDER BY

Q2: What is the main use of pivoting data in SQL?

A. To rotate rows into columns B. To join tables C. To filter results D. To delete data

Q3: Which SQL clause is often used in pivoting data?

A. GROUP BY B. PIVOT C. ORDER BY D. HAVING

Q4: Which function is commonly used during pivoting to aggregate values?

A. SUM() B. CONCAT() C. LEN() D. NOW()

Q5: In which RDBMS is the PIVOT operator natively supported?

A. MySQL B. PostgreSQL C. SQL Server D. SQLite

Q6: What is required in the IN clause of a PIVOT statement?

A. Table name B. Column alias C. List of column values D. Foreign key

Q7: Which keyword is used in SQL Server to undo a pivot?

A. UNPIVOT B. REVERSE C. ROLLBACK D. DE-PIVOT

Q8: What type of query is typically used before pivoting data?

A. DELETE B. UPDATE C. SELECT with GROUP BY D. INSERT INTO

Q9: Can you pivot on multiple columns at once in SQL?

A. Yes, with aliasing B. No C. Only with triggers D. Only with JOINs

Q10: Which clause helps in aggregating data along a pivot axis?

A. WHERE B. HAVING C. AGGREGATE D. GROUP BY

Q11: What does pivoting help improve in reporting?

A. Security B. Data entry C. Visualization and readability D. Data deletion

Q12: Which aggregate function is used in pivoting to count items?

A. SUM() B. COUNT() C. AVG() D. MAX()

Q13: Is it mandatory to use aggregate functions with PIVOT?

A. Yes B. No C. Only in MySQL D. Only in joins

Q14: What type of data is easiest to pivot?

A. Numeric with categories B. Unstructured text C. Image data D. Binary blobs

Q15: What should be done if new columns appear often in pivot data?

A. Use dynamic SQL B. Avoid pivoting C. Use HAVING clause D. Drop the table

Q16: Which database does NOT natively support PIVOT?

A. SQL Server B. Oracle C. PostgreSQL D. None

Q17: Which PostgreSQL extension helps with pivoting?

A. dblink B. crosstab C. tablefunc D. pivot_tool

Q18: Which keyword in SQL Server allows transforming columns into rows?

A. UNION B. UNPIVOT C. JOIN D. MERGE

Q19: Why would you pivot data in business reports?

A. To sort data faster B. To change schema C. To compare metrics side by side D. To encrypt data

Q20: Which function is usually used in pivoting categorical counts?

A. AVG() B. MAX() C. COUNT() D. SUM()

Q21: How can you dynamically generate pivot columns in SQL Server?

A. Using FOR XML and dynamic SQL B. Using only PIVOT C. Using CTEs alone D. Using primary keys