Database Security Oracle Interview Preparation Guide
Download PDF

Database Security Oracle Frequently Asked Questions in various Database Security Interviews asked by the interviewer. So learn Database Security Oracle with the help of this Database Security Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Database Security Interview Question or answer by the comment feature available on the page.

23 Database Security Questions and Answers:

1 :: Explain What is user Account in Oracle database?

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges.

2 :: Explain What is Privilege Auditing?

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

3 :: What is a database security profile?

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

4 :: Explain What is Auditing? What are the different Levels of Auditing?

Auditing includes reading, writing and deleting the access on the objects at the table level. The privileges granted to a user can be audited.

There are three levels of auditing:

Statement level
Object level
Privilege level

5 :: Explain 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.

6 :: Explain What are Roles?

Roles are named groups of related privileges that are granted to users or other roles.

7 :: Explain What is Statement Auditing?

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

8 :: Explain What are the system resources that can be controlled through Profile?

The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user's session the amout of logical I/O available to a single call to ORACLE made by a SQL statement the allowed amount of idle time for the user's session the allowed amount of connect time for the user's session.

9 :: Explain What is an Auditing?

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

10 :: Explain What is an Object Auditing?

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