Suppose the university creates:
CREATE VIEW Public_Students AS SELECT id, name, major FROM Students;
Why might the DBA grant access to this view instead of the base Students table?

Question

Suppose the university creates: 
 CREATE VIEW Public_Students AS SELECT id, name, major FROM Students; 
 Why might the DBA grant access to this view instead of the base  Students  table?

Answer

b.  To enforce primary key constraints

Answer

c.  To hide sensitive columns like GPA or SSN

Answer

a.  To improve query performance by materializing results

Answer

d.  To auto-create indexes on  id

Crowdly

Suppose the university creates: CREATE VIEW Public_Students AS SELECT id, name...

Want instant access to all verified answers on moodle.usth.edu.vn?