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
2 months agoRusty
13 days agoKris
20 days agoLinette
22 days agoRomana
1 months agoJudy
2 months agoTruman
2 months agoCraig
2 months agoLucy
15 days agoChara
21 days agoMarvel
26 days agoShaquana
2 months agoBen
2 months agoHailey
3 months agoMarkus
3 months agoStevie
3 months agoCatarina
2 months agoIvan
2 months agoPamella
2 months agoMel
2 months agoPaola
3 months ago