Oracle Database Administration from Zero to Hero - Using Password File Authentication

What is the primary purpose of the password file in Oracle Database?

• To store user data

• To save administrative user passwords

• To backup database files

• To manage database connections

Where is the password file located in Linux platforms?

• Under the database subdirectory

• In the Oracle HOME directory

• In the system root directory

• Under the DBS subdirectory

What is the mandatory argument when using the Ora PWD utility?

• FORMAT

• FILE

• PASSWORD

• OVERWRITE

What is the recommended format for the password file when using the Ora PWD utility?

• 12

• 11.2

• 12.2

• 10.2

What happens if the remote login password file parameter is set to 'None'?

• Password file authentication is enabled

• Password file authentication is disabled

• Multiple instances can access the password file

• The password file is opened in read-only mode

Which authentication method takes precedence when both OS and password file authentication are applicable?

• Password file authentication

• OS authentication

• Network authentication

• None of the above

What does the AT symbol (@) signify in a connection attempt to Oracle Database?

• A secure connection

• A network connection

• A local connection

• An administrative connection

What should be done first if the password file is lost?

• Restart the database

• Change the database password

• Revoke all user privileges

• Create a new password file

How can you synchronize user passwords in the database with a new password file?

• By changing the database password

• By revoking and re-granting administrative privileges

• By restarting the database

• By creating a backup of the database

What is the default permission setting for the password file?

• No access for any user

• Read-write for the DBA group

• Read-only for OR install group members

• Read-write for all users