Oracle Security

Oracle Security interview questions

<<Previous  Next>>

Explain the security features in Oracle. Data abstraction has been achieved in Oracle by separating the client and the server side logic. Therefore the client applications cannot manipulate the data. The triggers perform content based auditing and selectively disable application updates............. Read answer What are roles? How can we implement roles? A role is a set or group of privileges that can be granted to users or another role................ Read answer What is user Account in Oracle database? A user account is a schema which is used to store database objects, applications,.......................  Read answer What is a trace file and how is it created? The files that are created when an oracle background process encounters an exception are Trace files................... Read answer What are Tablespace Quota and default tablespace? A tablespace is a logical storage unit within an Oracle database because it is not visible in the file system of the machine, the database resides on................. Read answer 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.................... Read answer Explain Statement Auditing, Privilege Auditing, And Object Auditing. There are three levels of auditing: Statement level: Statements found in stmt_audit_option_map are audited.................    Read answer What are the steps to creating a password authentication file? The steps are : First set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file.............. Read answer Also read Use of Roles in oracle Roles in Oracle can be used to grant privileges to a specific group of users for security. The database manager is usually responsible for granting privileges to a Role.......... Describe the purpose of view in oracle The purpose of views is defined below: Views hide data complexity, views add security by restricting access to the columns of a table........... Oracle auditing Session auditing, Statement auditing, Privilege auditing, Object auditing............. Oracle backup Describe the Oracle backup, i.e. archive log mode, cold and hot backups, incremental backups...............  <<Previous  Next>>