🎴 Flashcard Mode
Oracle Database and SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
Using a view to access the table
💡 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.