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 answers are 4 and 5. The database manager configuration parameters keystore_type and keystore_location are key to implementing the encryption...
