Examice

Exam CAD All QuestionsBrowse all questions from this exam

Question 117

Assume a table called table exists and contains 3 fields: field1, field2, field3. Examine the Access Control list for table:

Which field or fields can a user with the itil role read?

All fields except field3

field1, field2, and field3

field1 and field3

field3 only

Correct Answer: D

A user with the itil role can read only field3. According to the Access Control list, the first entry grants read access to users with the itil role for all fields, but the second entry restricts read access to only users with the admin role. The third entry then specifically grants read access to field3 for users with the itil role. Therefore, the itil role can read only field3 as field1 and field2 are restricted by the second entry.

Discussion

doctorFOption: C

First - Gives Access to admin and itil for every field second - give access to only the admin for every field third - give read access to field 3 to itil

stophsOption: D

D. field3 only

51f8ce8Option: D

field 3 only

f37cbd9Option: C

itil has access to 1 and 3

GoMaggieO2Option: D

doctorF spells it out correctly.