Oracle Diagnostic Files-Short Questions and Answers

For doing the administrative tasks of Oracle database, you need certain privileges withing the database. Here short questions & answers can help you to know about Oracle Users & Security.

01. which administrator accounts are
automatically created when Oracle Database is installed?

Ans. SYS and SYSTEM.

02. What are the super powerful
administrative privileges?

Ans. SYSDBA and SYSOPER

3. Show the operations that are

authorized by the SYSDBA and SYSOPER system privileges.

Ans.

SYSDBA	Performs startup & shutdown operations.  Creates Database Drops database Alters database open/mount/backup Creates spfile Alters database archivelog Alters database recover Includes the Restricted session privilege
SYSOPER	Performs startup & shutdown operations. Alters database open/mount/backup Creates spfile Alters database archivelog Alters database recover Includes the Restricted session privilege

That's why, the main difference
between SYSDBA vs. SYSOPER is that in the SYSDBA the extra two privilege such
as CREATE DATABASE and DROP DATABASE are present while in SYSOPER these two
privileges are absent.

04. How will you connect SYS with
SYSDBA?

Ans. By the following SQL command,
you can connect SYS with SYSDBA.

SQL> connect sys as sysdba

Here you can use any password.

How to Connect SYS as SYSDBA

05. Which schema is for SYSDBA?

Ans. SYS

06. Which schema is for SYSOPER?

Ans. PUBLIC

07. How can you verify who has the
SYSDBA privilege in Database?

Ans. By this following command you
can do so.

SQL>select * from V$PWFILE_USERS;

USERNAME      
              SYSDB SYSOP SYSAS

------------------------------ -----
----- -----

SYS      
                   TRUE
 TRUE  FALSE

08. How can you login the database
remotely from a distant clent with sysdba privilege?

Ans. SQL>connect
system@'103.10.5.15:1521/orcl' as SYSDBA

Here 103.10.5.15 is ip address.