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 technique to rotate rows into columns for data summarization

B. A type of index

C. A view

D. A stored procedure

Answer: Option A

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

What is a database cursor?

A. A backup file

B. A user account

C. A type of index

D. A control structure that enables traversal over rows in a result set

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A cursor allows row-by-row processing of query results, often used in procedural extensions of SQL.

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

Question #2

What geometric symbol is used in an Entity-Relationship (ER) diagram to represent a relationship between entities?

A. Circle

B. Rectangle

C. Oval

D. Diamond

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Diamonds are utilized in ER diagrams to depict relationships between two or more entities.

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

Question #3

What is a query optimizer in a DBMS?

A. A component that determines the most efficient way to execute a query

B. A user interface

C. A tool for indexing

D. A backup utility

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The query optimizer analyzes SQL queries and selects the most efficient execution plan based on statistics and indexes.

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

Explore All Database Management System (DBMS) MCQs