You are working as a SQL Developer for a company that manages rental properties.

Question

You are working as a SQL Developer for a company that manages rental properties. The administrative staff needs to generate mailing labels to current and potential tenants letting them know about an upcoming special if a current tenant or new tenant signs a lease. As you look at the PEOPLE table you notice fields such as SSN (for social security number), DLic (for driver's license) and DOB (for date of birth). The administrative staff do not need access to those columns. In order to create the mailing labels, what should you do? Create a view called MailingLabels and make sure the administrative staff has access to that view. Create a table called MailingLabels and copy only the columns necessary to generate the mailing labels. Make sure the administrative staff has access to that table. Provide the administrative staff access to the entire table, while standing over their shoulder making sure they don't access the columns they don't need. Create a XML file called MailingLabels and make sure the administrative staff has access to that view.

Explanation / Answer

Answer:

B) Create a table called Mailing labels and copy only the columns necessary to generate the mailing lables Make sure sure the adminstrative staff has access to that table.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.