Free Preparation Discussions
MENU
CompTIA DS0-001 Exam - 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;
Kristofer
4 months agoHailey
4 months agoCallie
4 months agoDante
5 months agoMagdalene
5 months agoDevorah
5 months agoMadonna
5 months agoNicholle
5 months agoAntonio
6 months agoEmerson
6 months agoJessenia
6 months agoCory
6 months agoLelia
6 months agoLeontine
6 months agoEdgar
6 months agoAlverta
6 months agoBenton
6 months agoRyan
11 months agoRusty
9 months agoKris
10 months agoLinette
10 months agoRomana
10 months agoJudy
11 months agoTruman
11 months agoCraig
11 months agoLucy
9 months agoChara
10 months agoMarvel
10 months agoShaquana
11 months agoBen
11 months agoHailey
12 months agoMarkus
12 months agoStevie
12 months agoCatarina
11 months agoIvan
11 months agoPamella
11 months agoMel
11 months agoPaola
12 months ago