The  Tablespace  to  contain  schema  objects  created without specifying a tablespace name.

kapil

• Nov 1st, 2015

Users need to have a default tablespace, where their objects will be created if they dont explicitly assign a different tablespace during object creation

Chiranjeevi Manne

• Mar 30th, 2007

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...

Answer Question  Select Best Answer

 DBA_FREE_SPACEDBA_SEGMENTSDBA_DATA_FILES.

Newton Aseri

• Oct 7th, 2015

DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES..

Answer Question  Select Best Answer

How will you enable database auditing? In How many ways can you implement database auditing?

yossin

 Profile Answers by yossin Questions by yossin

• Oct 15th, 2009

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.

johnjohn1976

 Profile Answers by johnjohn1976 Questions by johnjohn1976

• May 25th, 2009

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...

Answer Question  Select Best Answer

What is Oracle Wallet?

imran44

 Profile Answers by imran44 Questions by imran44

• Dec 28th, 2008

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.

Answer Question  Select Best Answer

meetsanc

 Profile Answers by meetsanc Questions by meetsanc

• Oct 2nd, 2008

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...

Answer Question  Select Best Answer

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

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 25th, 2008

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...

Answer Question  Select Best Answer

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

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 25th, 2008

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.

Answer Question  Select Best Answer

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

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 25th, 2008

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

Answer Question  Select Best Answer

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

gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 15th, 2007

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.

Chiranjeevi Manne

• Mar 30th, 2007

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

Answer Question  Select Best Answer

      Shut the database     Backup the database     Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.     Start up the database.

Chiranjeevi Manne

• Mar 30th, 2007

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 ...

Nitan Jandial

• Dec 28th, 2006

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...

Answer Question  Select Best Answer

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

Chiranjeevi Manne

• Mar 30th, 2007

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

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 3rd, 2006

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.

Answer Question  Select Best Answer

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...

Chiranjeevi Manne

• Mar 30th, 2007

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

Answer Question  Select Best Answer

 SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL  *  Loader  -  It loads data from standard operating system files (Flat files) into ORACLE database tables. Export  (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Chiranjeevi Manne

• Mar 30th, 2007

SQL Plus, SQL Loader, EXP, IMP

Answer Question  Select Best Answer

The collective amount of disk space available to the objects in a schema on a particular tablespace.

Guest

• Jan 12th, 2007

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

Answer Question  Select Best Answer

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

Patrick McShea

• Dec 7th, 2006

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

Mangla

 Profile Answers by Mangla Questions by Mangla

• Sep 20th, 2006

Roles  are  named groups of related privileges that are granted to users or othersBhim Mangla(IBM)

Answer Question  Select Best Answer

 DBA - role Contains all database system privileges. SYS  user  account  - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary are store in this schema and are manipulated only by ORACLE. SYSTEM user account - It has all the system privileges for the database and additional  tables  and  views ...

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 4th, 2006

&DBSNMPSupports 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" CheersRavi Prakashhttp://ravidba-oracle.blogspot.com/

Answer Question  Select Best Answer

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 3rd, 2006

Force attempts are not stopped by the Listener but it can log them if logging is enabled. set LOGGING_LISTENER=ONCheersRavi Prakashhttp://ravidba-oracle.blogspot.com/

Answer Question  Select Best Answer

prakashpichika

 Profile Answers by prakashpichika Questions by prakashpichika

• Oct 3rd, 2006

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 ...

Answer Question  Select Best Answer

Pooja Chaturvedi

• Aug 15th, 2006

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...

Answer Question  Select Best Answer

 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 Oralce license agreementControlling and monitoring user access...

skumarpenugonda

 Profile Answers by skumarpenugonda Questions by skumarpenugonda

• Jul 7th, 2006

adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloa...

Prabha Sharma

• Apr 13th, 2006

Defining physical and logical schema of database.Take periodically backup of the database.Assign authorization to the database users.Define various method for storing and retrieving of data.

Answer Question  Select Best Answer