Creating Oracle Password File - Quiz Explanation
The correct answers are indicated below, along with the text that explains the correct answers.
1.
Why are password files necessary?
Please select the best answer.
A.
There is no room in the database for passwords to be stored.
B.
They allow DBAs to be authenticated when the database is closed.
C.
Reading a password file is more efficient than reading a password from the database.
D.
They avoid the overhead of generating redo log entries when a password is changed.
Answer B is correct.
Normal user passwords are stored in the database files and are accessible only when the database is open. DBAs need to connect to an instance even when the database is closed. Password files allow this to happen because they are accessible regardless of a database’s state.
2.
What is the name of the utility used to create password files?
Please select the best answer.
A.
orapwd
B.
pwd
C.
genpwd
D.
pwdfile
The correct answer is A.
The name of the utility used to create password files is orapwd, so the correct answer is A.
3.
You are creating a password file and configuring a database to use it. You have just determined the proper location and name for the password file. What is your next step?
Please select the best answer.
A.
Use the orapwd utility to create the password file
B.
Restart the database and bounce the listener
C.
Grant
SYSDBA
to the
SYSTEM
user
D.
Set the
REMOTE_LOGIN_PASSWORDFILE
initialization parameter to
EXCLUSIVE
The correct answer is A.
The next step after determining location and name for the password is creating the password file.