10 Apr, 2007
Database Interview Questions
- What is Privilege Auditing? - Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
- What is Object Auditing? - Object auditing is the auditing of accesses to specific schema objects without regard to user.
- What is Auditing? - Monitoring of user access to aid in the investigation of database use.
- What are the responsibilities of a Database Administrator?
- 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 optimizing the performance of the database.
- Planning for backup and recovery of database information.
- Maintain archived data on tape
- Backing up and restoring the database.
- Contacting Oracle Corporation for technical support.
- What is a trace file and how is it created? - 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.
- What is a profile? - Each database user is assigned a Profile that specifies limitations on various system resources available to the user.
- How will you enforce security using stored procedures? - 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.
