You intend to use only password authentication and have used the password file utility to
create a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE.
You created a user and granted only the SYSDBA privilege to that user as follows:
CREATE USER dba_user
IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;
The user attempts to connect to the database as follows:
connect dba_user/dba_pass as sysdba;
Why does the connection fail?
A. The DBA privilege was not granted to dba_user.
B. REMOTE_LOGIN_PASSWORDFILE is not set to EXCLUSIVE.
C. The password file has been created in the wrong directory.
D. The user did not specify the password orapass to connect as SYSDBA.
Answer: B
Setting REMOTE_LOGIN_PASSWORDFILE to exclusive means that a password file exists and
any user/password combination in the password file can log into Oracle remotely and administer
the instance.
---------------------------
You used the password file utility to create a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
You created a user and granted only the SYSDBA privilege to that user as follows:
CREATE USER dba_user
IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;
The user attempts to connect to the database as follows:
connect dba_user/orapass as sysdba;
Why does the connection fail?
A. The DBA privilege had not been granted to dba_user.
B. The SYSOPER privilege had not been granted to dba_user.
C. The user did not provide the password dba_pass to connect as SYSDBA.
D. The information about dba_user has not been stored in the password file.
Answer: C
Connection failed because the user did not provide the password dba_pass to connect as
SYSDBA.
----------------------------
两道题一对比:是不是说我如果用sys登录,就要用orapass作为密码,这个叫做口令文件认证的方式;我如果用dba_user登录,就要用dba_pass作为密码?
我用dba_user/dba_pass登录,叫做什么认证方式呢?(我猜测也是叫口令文件认证,对么?)