文档介绍：Exam : 1Z0-031
Title : Oracle9i:Database Fundamentals I
Ver :
1Z0-031
QUESTION 1:
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 da_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/bination in
the password file can log into Oracle remotely and administer the instance.
Incorrect Answers
A: The main problem that the connection failed is the REMOTE_LOGIN_PASSWORDFILE initialization
parameter is set to NONE. Granting the DBA privilege to dba_user will not fix the issue.
C: The default directory for the password file is $ORACLE_HOME/dbs/, so there is no error in the location of
the password file.
D: The main problem that the connection failed is the REMOTE_LOGIN_PASSWORDFILE initialization
parameter is set to NONE. Specifying the password during login process will not fix the issue.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 513-516
Chapter 10: Basics of the Oracle Database Architecture
QUESTION 2:
John has created a procedure named SALARY_CALC. Which SQL query allows him to view the text of the
procedure?
A. SELECT text FROM user_source
WHERE name='SALARY_CALC';