Aptitude Reasoning English GK Computer Knowledge Programming Skill Banking Software Testing

Question

DB2 Certification:-

A table named DEPARTMENT has the following columns:

DEPT_ID

DEPT_NAME

MANAGER

AVG_SALARY

Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

  • Encrypt the table\'s data
  • Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users
  • Create a view that does not contain the AVG_SALARY column
  • Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
  • None of these
Answer- C


More Test for Practice


IT Certifications