DCL commands in SQL include: MCQ with Answer and Explanation

Question
DCL commands in SQL include:
A. SELECT and JOIN
B. CREATE and DROP
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
What is the purpose of the SAVEPOINT statement?
A. To create a point within a transaction to which you can later roll back
B. To release locks
C. To permanently save changes
D. To start a new transaction
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SAVEPOINT creates a named point within a transaction, allowing partial rollback to that point without affecting the entire transaction.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'CHECK' constraint?
A. To define relationships
B. To enforce uniqueness
C. To set a default value
D. To validate data based on a condition
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
CHECK constraint ensures that values in a column meet a specified condition, such as age > 0.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following ensures data integrity in RDBMS?
A. User input without checks
B. Constraints like primary key, foreign key
C. No validation rules
D. Random data entry
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Integrity constraints such as keys enforce rules for valid data.
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.