DEVFYI - Developer Resource - FYI

What is an administrative (privileged) user? (for DBA

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

188. What is an administrative (privileged) user? (for DBA

Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER allow access to a database instance even if it is not running. Control of these privileges is managed outside of the database via password files and special operating system groups. This password file is created with the orapwd utility.

<

(Continued on next question...)

Other Interview Questions