What is a pivot table in a database context? MCQ with Answer and Explanation

Question

Share Report Error

What is a pivot table in a database context?

A. A type of index

B. A view

C. A technique to rotate rows into columns for data summarization

D. A stored procedure

Answer: Option C

Solution (By JKSSB Mock Tests)

Pivoting transforms data by turning unique values from one column into multiple columns, often for reporting.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Which constraint ensures that all values in a column are unique?

A. FOREIGN KEY

B. PRIMARY KEY

C. CHECK

D. UNIQUE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
UNIQUE constraint ensures that all values in a column are distinct, but allows NULL (unless combined with NOT NULL).

This question belongs to: Computer Database Management System (DBMS)

Question #2

What is the purpose of the SQL 'CONSTRAINT' keyword?

A. To create indexes

B. To create views

C. To join tables

D. To define rules for data integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which of the following is NOT an aggregate function in standard SQL?

A. SUM()

B. AVG()

C. COUNT()

D. LENGTH()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SUM(), AVG(), and COUNT() are aggregate functions operating on multiple rows, whereas LENGTH() is a scalar function acting on a single text value.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs