PrepAway - Latest Free Exam Questions & Answers

What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?

A column mask that is to be used for row and column access control (RCAC) was created with the
DISABLE option specified. What must be done if this mask is to be used to restrict access to data
stored in a table named EMPLOYEE?

PrepAway - Latest Free Exam Questions & Answers

A.
The column mask must be enabled; the EMPLOYEE table must be altered to activate column
access control.

B.
The column mask must be enabled (column access control for the EMPLOYEE table will be
activated automatically).

C.
The EMPLOYEE table must be altered to activate column access control (the column mask will
be enabled automatically).

D.
The EMPLOYEE table must be altered to activate column access control; row permission must
be granted to everyone who needs to use thecolumn mask.

Explanation:


Leave a Reply