Oracle Database Administration from Zero to Hero - Administrative Accounts and Privileges

This lecture covers Oracle database administrative accounts and privileges, detailing the roles of SYS and SYSTEM accounts, and the differences between SYSDBA and SYSOPER privileges. It explains password management, default schemas, and best practices for privilege management. The lecture emphasizes the importance of understanding administrative roles and their security implications.

What is the primary role of the SYS user in Oracle databases?

• To manage user accounts

• To perform nearly any action on the database

• To handle network configurations

• To manage application roles

Which administrative account is responsible for backup and recovery operations?

• SYSRAC

• SYSBACKUP

• SYSDG

• SYSKM

What must be included in the connection string when logging in as an administrative user?

• The database version

• The keyword 'as SYSDBA'

• The user's email address

• The server IP address

Where is the SYS user password stored starting from Oracle database release 12.2?

• In the database

• In the password file

• In the user profile

• In the system registry

What is the main difference between SYSDBA and SYSOPER privileges?

• SYSDBA can perform high-level operations, SYSOPER cannot

• SYSOPER can start the database, SYSDBA cannot

• SYSOPER can manage user data, SYSDBA cannot

• SYSDBA is for network management, SYSOPER is not

Which privilege allows access to a database instance even when it is not open?

• SYSDG

• SYSKM

• SYSDBA

• DBA

What is a key difference between SYS and SYSTEM users?

• SYSTEM can manage network settings, SYS cannot

• SYS owns the data dictionary, SYSTEM does not

• SYSTEM can start the database, SYS cannot

• SYS can perform backups, SYSTEM cannot

Why can't the SYSTEM user connect to the database when it is in mount state?

• It requires a special connection string

• It lacks the SYSDBA privilege

• It is not an administrative account

• Its password is not saved in the password file

What is the recommended practice for granting administrative privileges to a user with an application role?

• Grant privileges to a role and assign the role to the user

• Use a shared account for all users

• Create a separate account for administrative tasks

• Grant privileges directly to the user

What should be documented and approved before implementing in Oracle databases?

• User login attempts

• Network configuration changes

• Grant and revoke requests

• Database schema changes