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 stored procedure

C. A view

D. A type of index

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 the purpose of the REVOKE command in SQL?

A. To create a user

B. To delete a table

C. To rollback a transaction

D. To remove user permissions

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
REVOKE is used to take away privileges previously granted to users.

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

Question #2

What is the situation called when two or more transactions are permanently blocked, each waiting for a lock held by the other transaction to be released?

A. Deadlock

B. Concurrency

C. Isolation failure

D. Starvation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Deadlock occurs when two or more transactions are stuck in a circular dependency, each waiting for resources locked by the other, preventing progress.

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

Question #3

Which operator in SQL is used to exclude specific data records from a search based on a collection of negative criteria?

A. NOT IN

B. MINUS

C. REMOVE

D. EXCEPT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The NOT IN operator filters the query results to exclude records whose values match any element within the provided list or subquery.

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

Explore All Database Management System (DBMS) MCQs