Oracle security Interview Questions

There's another option.
There is a product called OraPlayer, that is tracking all actions performed by all the end-users of Oracle Forms.
It tracks all the data sent from the forms user to the server and from the server.

Auditing is a functionality which keep track of all the activity happening to DB There are two type of auditing in Oracle 1, Standard Auditing2. Fine grained Auditing The standard Auditing is again di...

Wallet is a Oracle object which keeps the record of Master key for the entire database and all other digital certificates used by the database for encryption purpose. The Walled kept outside the database software and has a different password then DBA system password.

For applications dealing with this highly sensitive data like passwords, Oracle provides the DBMS_OBFUSCATION_TOOLKIT PL/SQL package to encrypt and decrypt data. It includes string inputs and raw inpu...

Privilege auditing involves the tracking of the SQL statements issued by users who have been granted the right to execute that statement through a system privilege. In order to enable or disable audit...

The Statement auditing is tracking the SQL statements issued by database users. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege.

Object auditing involves the tracking of the specific SQL DML statements issued against objects by database users.

A profile is used to restrict the reource uses, password reuses, idle time of a session etc.  We can also attach a password verify function for the database user.  A database user can be assigned a profile.  It is an optional clause.  By default it takes DEFAULT profile.

A profile contains the details about the RESOURCE LIMITS and PASSWORD LIMITS at Oracle level pertaining to a specific user.

1. it possible to enable archive log mode while creating the database using DBCA.2. By mentioning the required parameters like LOG_ARCHIVE_DEST, LOG_ARCHIVE_FORMAT, LOG_ARCHIVE_START in init.ora file ...

These are points we should consider when we think abt archivelog mode starts automatic Before stutting down the DB, just alter the parameter name "log_archive_start" into "TRUE"Issue the following st...

Auditing involves in recording all the activities based on the auditing rules
Some types of auditing are Database level Auditing, Schema Level auditing, Object level Auditing and Statement level auditing.

Auditing in Oracle can be done by writing logs to either the SYS.AUD$ table or to the OS itself.

Auditing to the OS makes deleting the audit trail by a DB user more difficult. But auditing all accounts and all actions would severely affect performance.

The default tablespace is the tablepsace in which the user's objects are created. Generally while creating the user, the default tablespace is mentioned. If by any chance the default tablespace is...

Amount of CPU TIME, PERCENTAGE CPU, IDLE TIME etc..

SQL Plus, SQL Loader, EXP, IMP

Hi

Tablespace quota nothing but a restricted quota that is asign to a particular user in a particular  tablespace .

Roles are named groups of privileges (which my OR MAY NOT be related to each other) that are granted to users or other roles.

Roles  are  named groups of related privileges that are granted to users or others

Bhim Mangla(IBM)

&

DBSNMP

Supports Oracle SNMP (Simple Network Management Protocol).

The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP"

Cheers

Ravi Prakash

http://ravidba-oracle.blogspot.com/

Force attempts are not stopped by the Listener but it can log them if logging is enabled.

set LOGGING_LISTENER=ON

Cheers

Ravi Prakash

http://ravidba-oracle.blogspot.com/

Database Security is a group of related things...in which the Oracle Database hardening is Must to make the Database secure.Some of them are1)OS server should be a single function system dedicated to ...

If we want to say that our Database is secured then we must confirm first that our Data is validate.There are various methods of validating the Data:1. Accept only known valid Data.2. Reject known Bad...