What is the purpose of the REVOKE command in SQL? MCQ with Answer and Explanation

Question

Share Report Error

What is the purpose of the REVOKE command in SQL?

A. To delete a table

B. To create a user

C. To rollback a transaction

D. To remove user permissions

Answer: Option D

Solution (By JKSSB Mock Tests)

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

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

The total number of attributes (columns) present in a relation determines its what?

A. Schema

B. Degree

C. Domain

D. Cardinality

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The number of attributes or columns in a relation is defined as the degree of that relation.

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

Question #2

The concept that prevents concurrent transactions from interfering with each other and creating data inconsistencies is known as what?

A. Atomicity

B. Isolation

C. Consistency

D. Durability

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Isolation ensures that the execution of concurrent transactions does not interfere with one another, making them appear as if they are executing sequentially.

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

Question #3

What is a virtual table that does not physically exist on storage but is defined by an underlying SQL query called?

A. Trigger

B. Stored Procedure

C. View

D. Index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A View is a virtual, logical table derived from the result set of an SQL SELECT query. It behaves like a table but does not store data independently.

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

Explore All Database Management System (DBMS) MCQs