Oracle Database: Test 1 - Online Test

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






Comments

No comment yet. Be the first to post a comment.