DCL commands in SQL include: MCQ with Answer and Explanation

Question

Share Report Error

DCL commands in SQL include:

A. CREATE and DROP

B. SELECT and JOIN

C. GRANT and REVOKE

D. INSERT and UPDATE

Answer: Option C

Solution (By JKSSB Mock Tests)

Data Control Language (DCL) commands manage access permissions.

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

Share Report

Which SQL keyword is used to give users permission to access database objects?

A. GRANT

B. REVOKE

C. PERMIT

D. ASSIGN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
GRANT is a DCL command used to assign privileges to users.

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

Question #2

Share Report

What is a relation in relational database terms?

A. A row

B. A table

C. A column

D. A key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In the relational model, a relation is a table consisting of rows and columns.

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

Question #3

Share Report

What is a data dictionary in a DBMS?

A. A log file

B. A repository of metadata about the database

C. A backup of the database

D. A table containing user data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The data dictionary stores metadata such as table definitions, column types, constraints, and other database objects.

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

Explore All Database Management System (DBMS) MCQs