Multiple choice technology databases

A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column?

  1. Using a view to access the table

  2. Using a referential constraint on the table

  3. Revoking access from the phone_number column

  4. Defining a table check constraint on the table
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A view is a virtual table that can restrict access to specific columns. By creating a view that excludes the phone_number column and granting users access only to the view (not the base table), you effectively limit their read access. Referential constraints enforce relationships between tables, revoking access from a column doesn't work as columns are accessed through the table, and check constraints validate data values.

Keep practicing — related questions