Answers
Question 1: The correct answer is 1. Authentication occurs at the server by using the OS security facility. However, the user ID and password that the user enters to attach to an instance or connect to a database stored on the server may be encrypted at the client before it is sent to the server for validation.
Question 2: The correct answer is 2. VERIFY_TRUSTED_CONTEXT_ROLE_FOR_USER (SESSION_USER, [RoleNameExp]) - Returns a value that indicates that the authorization ID identified by the SESSION_USER special register has acquired a role under a trusted connection associated with some trusted context, and that the role is in (or contained in any of) the role names specified by the list of RoleNameExp arguments.
Question 3: The correct ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access