Question: 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
Get step-by-step solutions from verified subject matter experts
