Multiple Choice
Which of the following is true about database access control?
A) to access a database the SQL Server login must be mapped to a database user
B) members of the sysadmin server role don't have access to databases by default
C) once a user logs in to the SQL Server, they have automatic access to underlying database objects
D) the database user login name must be different from the server login name
Correct Answer:
Verified
Correct Answer:
Verified
Q16: List and describe three fixed roles that
Q17: AES is a block cipher that translates
Q18: Which default account is enabled when SQL
Q19: SQL Server can generate a self-signed _
Q20: What happens when a users requests access
Q22: What SQL function should you use to
Q23: Which of the following is an authentication
Q24: Which environments must use SQL Server authentication
Q25: Which method of securing client/server connections used
Q26: How is a user granted permission to