Free Preparation Discussions
MENU
CompTIA DS0-001 Exam - Topic 1 Question 9 Discussion
Topic #: 1
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;
Justine
10 months agoChan
10 months agoGoldie
10 months agoDewitt
10 months agoAvery
11 months agoErnie
11 months agoGolda
11 months agoOliva
11 months agoLilli
11 months agoLenna
11 months agoLeslie
11 months agoMose
11 months agoAmie
11 months agoChristoper
12 months agoCordelia
12 months agoQuinn
12 months agoRefugia
2 years agoHyun
2 years agoAnnamae
2 years agoAnnalee
2 years agoCatalina
2 years agoLenny
2 years agoLavonna
2 years agoMilly
2 years agoRebeca
2 years agoOrville
2 years ago