Question 25 2 pts The company is growing very fast and many new employees are be

Question

Question 25 2 pts The company is growing very fast and many new employees are being hired. The Database Administrator (DBA) is being overwhelmed with requests to give people access to the database. For each new user the DBA must define exactly which tables and which actions (SELECT, INSERT, UPDATE, DELETE) the new user needs. Which of the following would be a strategy to make this process easier for the DBA? O Have employees share usernames and password. O Create views to restrict what new hires can access. O Authenticate the new users in the operating system not in the database. O Create a limited number of database roles and assign permissions to each role. Then assign new employees to these roles.

Explanation / Answer

Question 25:
create views to restrict what new hire can access
Question 26:
Combine the tables since they are in a 1:1 relationship
Question 27:
create a view from the credit card that does not include the
balance column .assign permissions to access the view to
users who should not see the balance data.
Question 28:clustered index
Question 29:bitmap index
Question 30:increase the frequency of check points

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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