Test Difficulty Level: Hard

Syllabus of Test

Computer Programming: Questions based on the strong knowledge of Oracle Database.

Sample Question from this online test:

Question: 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 ?

Option A: The DBA privilege was not granted to dba_user

Option B: REMOTE_LOGIN_PASSWORDFILE is not set to EXCLUSIVE

Option C: The password file has been created in the wrong directory

Option D: The user did not specify the password orapass to connect as SYSDBA

To answer, click the "Start This Test" button below.

Start this Test