Free Preparation Discussions
MENU
CompTIA Exam DS0-001 Topic 3 Question 16 Discussion
Topic #: 3
Which of the following describes the purpose of a snapshot?
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;
Ryan
3 months agoRusty
1 months agoKris
1 months agoLinette
1 months agoRomana
2 months agoJudy
2 months agoTruman
2 months agoCraig
3 months agoLucy
1 months agoChara
1 months agoMarvel
2 months agoShaquana
2 months agoBen
3 months agoHailey
3 months agoMarkus
3 months agoStevie
3 months agoCatarina
2 months agoIvan
3 months agoPamella
3 months agoMel
3 months agoPaola
3 months ago