Multiple choice technology databases

Identify SQL statement which is used as Data Control Language command. Choose all that apply.

  1. Alter

  2. Grant

  3. Select

  4. Rename

  5. Revoke

  6. Update

Reveal answer Fill a bubble to check yourself
B,E Correct answer
Explanation

Data Control Language (DCL) commands manage permissions and access: Grant gives privileges to users, Revoke removes privileges. Alter and Rename are DDL structure commands, Select retrieves data, Update modifies data - none are access control commands.