Oracle Database 12c: Advanced Administration — Question 103

LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?

Answer options

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Correct answer: A

Explanation

The first authentication method attempted is by password file because the user scott is connecting with the syntax that specifies sysdba. This method takes precedence in cases where LDAP_DIRECTORY_SYSAUTH is set to YES but the password file is still configured. The other options are not attempted first due to the specified connection method and existing configurations.