Technical Interview Questions

Don’t grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

Each database user is assigned a Profile that specifies limitations on various system resources available to the user.

Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

* Installing and upgrading the Oracle Server and application tools.
* Allocating system storage and planning future storage requirements for the database system.
* Managing primary database structures (tablespaces)
* Managing primary objects (table, views, indexes)
* Enrolling users and maintaining system security.
* Ensuring compliance with Oracle license agreement
* Controlling and monitoring user access to the database.
* Monitoring and [...]

Monitoring of user access to aid in the investigation of database use.

Object auditing is the auditing of accesses to specific schema objects without regard to user.

Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.

REDUCED GRANTING OF PRIVILEGES -
Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group.
DYNAMIC PRIVILEGE MANAGEMENT -
When the privileges of a group must change, [...]