Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. The following account creates the link between a server (SQL Server engine) level login and the database user. (Hint: Database user is a database
1. The following account creates the link between a server (SQL Server engine) level login and the database user. (Hint: Database user is a database level account)
1. SA account 2.Domain account 3.Database account 4.None of the above
2. Assume a database user named Tim needs to be able to read and write to all the tables in a particular database; granting him the following role would make your job as a DBA easy. (Hint: select and update, insert or delete)
1.dbo
2.db_datareader 3.db_datawriter 4.db_dataowner
3. Securables are entities in SQL Server on which permissions are granted. We can grant these permissions by the following method(s)
1. | Data control language | |
2. | SQL Server management studio | |
3. | Data permission language | |
4. | All of the above |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started