Explanation:The object class has the following members:Aggregate,Function and Procedure. 7. Which of the following returns a row for each security principal in a SQL Server database ?
A. sys.database_role_members
B. sys.sql_logins
C. sys.database_principals
D. None of the mentioned
Answer:A
Explanation:The object class has the following members:Aggregate,Function and Procedure. 7. Which of the following returns a row for each security principal in a SQL Server database ?
A. sys.database_role_members B. sys.sql_logins C. sys.database_principals D. None of the mentioned
Explanation:The permissions of fixed database roles do not appear in sys.database_permissions. 8. Any SQL Server authentication login can see ________ login name.