Free Preparation Discussions
MENU
CompTIA Exam DS0-001 Topic 2 Question 22 Discussion
Topic #: 2
Which of the following best describes the category of SQL commands required to revoke access to database objects?
The category of SQL commands that is required to revoke access to database objects is DCL. DCL, or Data Control Language, is a subset of SQL commands that are used to control or manage the access or permissions of users or roles on a database. DCL includes commands such as GRANT and REVOKE. GRANT is a DCL command that is used to grant privileges or roles to users or roles on specific objects in a database, such as tables, views, procedures, etc. REVOKE is a DCL command that is used to revoke privileges or roles from users or roles on specific objects in a database. For example, the following statement uses the REVOKE command to revoke the SELECT privilege from user Alice on table employee:
REVOKE SELECT ON employee FROM Alice;
Sue
4 months agoRaylene
3 months agoDorthy
3 months agoKirk
4 months agoMarylou
3 months agoKristin
3 months agoAnglea
3 months agoStephaine
3 months agoJanine
4 months agoEdna
4 months agoAndree
4 months agoJustine
5 months agoCarolann
3 months agoSheridan
3 months agoAdelina
3 months agoFrancoise
3 months agoSommer
3 months agoGeorgene
3 months agoColby
3 months agoIraida
3 months agoDevora
3 months agoShizue
3 months agoLouis
3 months agoDyan
3 months agoArmanda
3 months agoEva
3 months agoGlen
3 months agoHyun
3 months agoVallie
3 months agoLeanora
4 months agoParis
4 months agoGwenn
4 months agoSang
5 months agoBrianne
5 months agoRikki
4 months agoSang
5 months agoJanine
5 months agoEdna
5 months ago