Which language category in SQL is used by database administrators to grant and revoke access privileges and security permissions? MCQ with Answer and Explanation

Question
Which language category in SQL is used by database administrators to grant and revoke access privileges and security permissions?
A. DDL
B. TCL
C. DCL
D. DML
Answer: Option C
Solution (By JKSSB Mock Tests)
Data Control Language (DCL) includes commands like GRANT and REVOKE, which manage privileges and security configurations for database 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
Which statement about primary keys in a relational database table is completely true?
A. A primary key column can accept a single NULL value.
B. Primary keys must always be numeric integers.
C. A table can contain at most one primary key.
D. A table can have multiple distinct primary keys.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A relational database table can have exactly one primary key constraint defined, which uniquely identifies each record and strictly forbids NULLs.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What does ACID stand for in database transactions?
A. All Correct Information Display
B. Accuracy, Control, Integrity, Data
C. Access, Create, Insert, Delete
D. Atomicity, Consistency, Isolation, Durability
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ACID properties ensure reliable transaction processing in DBMS.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What is 'data about data' commonly referred to in a Database Management System?
A. Hyper-data
B. Sub-data
C. Metadata
D. Directory
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Metadata is defined as data about data. It describes the structure, constraints, data types, and properties of the actual data stored in a database.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Networking 325 Microsoft Office 1199 CPU (Central Processing Unit) 327 Cyber Security 269 Memory and Storage Devices 438
Explore Subjects
Geography GK 6121 Current Affairs 575 History GK 3374 Accountancy and Statistics 3179 Maths 5575
Practice Mix
Select the most appropriate meaning of the idiom: 'Make a mountain out of a molehill'.
What does the 'GUI' acronym stand for in computer interface terminology?
A trader marks his goods 80% above cost price and gives a discount of 40%. Find his gain percent.
Which type of memory is used to store the firmware that boots the computer?
The average of 8 numbers is 30. If one number is 40, find the average of the remaining 7.