Skip to content

CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management

A bank's database administrator runs the statement GRANT SELECT ON customer TO audit_team. Which category of SQL sub-language does this statement belong to, and what is its effect?

GRANT belongs to Data Control Language (DCL). It gives the audit team the privilege to read the customer table using SELECT. It neither changes table structure nor retrieves data itself, and it is not a transaction control command, so DCL for access privileges is correct.

  1. ADDL, because it changes the structure of the customer table
  2. BDCL, because it gives the audit team read access privilegesCorrect
  3. CTCL, because it commits the privilege to the database
  4. DDML, because it retrieves rows from the customer table

Explanation

GRANT and REVOKE are Data Control Language commands that manage access privileges. Here the audit team receives permission to read data only. It does not alter table structure (DDL), manipulate rows itself (DML) or manage transactions (TCL).

Did you get it right without looking?

One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.

Practise Database ManagementFree diagnostic mock

More Database Management questions