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:
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.
Related Online Tests:
No comment yet. Be the first to post a comment.