A Database contains one or more Rollback Segments to temporarily store "undo" information.

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jan 28th, 2008

It stores your uncommited temporart data. ex. If you do any insert/update/delete and you won't commit it is written in rollback segment.

Answer Question  Select Best Answer

Here i'm sending all of you the error which occurred frequently during database connection.While creating a data block in Oracle Forms, the error which encountered frequently is "ORA-12560: TNS Protocol Adapter Error" During lectures instructor had told us that if such error encountered then copy the TNSNAMES.ORA file from ..oracleora92networkadminsample to forms9inetworkadminsample as it contains...

sahil4439

 Profile Answers by sahil4439 Questions by sahil4439

• Jun 15th, 2008

dude  ur databse is not running...right click on my compiuter>manage>services& applictaions(on right side)>services>oracle_databse_name(the datasbe  that ur  trying ...

Answer Question  Select Best Answer

what is remote login user and local user in database?And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..What does it mean ?

cmanan

 Profile Answers by cmanan Questions by cmanan

• Jul 10th, 2008

When you have distributed environment,you may access one database from other.This is normally done  via db link.So lets say you have flight database and customer dabatabase.Now from customer data...

Answer Question  Select Best Answer

Hi,

If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?

Regards,
Shashi

Aayudh

• Aug 24th, 2011

Oracle uses query executed by user because when you use a view name in an other query, it simply transform query. select empid,name from emp; --- original create view emp_view as select empid,name f...

Answer Question  Select Best Answer

The Primary function of the redo log is to record all changes made to data.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 21st, 2008

Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their ...

sujeshm

 Profile Answers by sujeshm Questions by sujeshm

• Feb 27th, 2006

Redo log is a part of physical structure of oracle. its basic function is to record all the changesmade to daatabase information. wheneveer an abnormal shutdown take place preventing system to update the database, changes can be obtained from redolog and hence the changes are not lost.

Answer Question  Select Best Answer

No.

Tauseef

• Nov 25th, 2007

Yes. you can add integrity constraint. but that will effects the new records only not the existing one

Samuel Kiarie

• Mar 31st, 2006

Yes.Use Enable Novalidate to enforce the constraints. Existing data will not be checked, only new/update will be validated.

Answer Question  Select Best Answer

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.

soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Aug 9th, 2007

A table can have any number unique keys but a single primary key

Thriveni P

• Mar 14th, 2006

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls.Unique key cannot be used to create referential integrity whereas primary key can do.

Answer Question  Select Best Answer

A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.

Mohammed Abdul Afroze

• Sep 20th, 2007

It is a Logical area of storage in a Database, that directly corresponds to one or more physical files.

sandeep vig

• Oct 13th, 2005

A tablespace is a group of segments and a segment is a group of extents and an extent is a group of blocks.a tablespace can occupy two physical datafiles.

Answer Question  Select Best Answer

Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Mohammed Abdul Afroze

• Sep 20th, 2007

Every Oracle Database contains a tablespace called system tablespace.This tablespace gets created at the time of database creation and it holds data dictionary information for the entire database.

Praveen

• Sep 15th, 2006

HelloAs far as i know, a system tablespace is the only tablespace which is created automatically, when the oracle DB is installed, no matter what the DB will contain atleast one tablespace and that  is the system tablespace. Do let me know if u have any other answers.Praveen.R

Answer Question  Select Best Answer

A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 27th, 2010

Table is manager which contain row and colomnin which store data ande retrive data

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

Table is data base object which stores the data in the logical representatiom in form of rows n coluns which is existing in two dimension form... and is stored in the databse.

Answer Question  Select Best Answer

Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

manish hoiyani

• Sep 14th, 2006

temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system   will use temporary segments  for this query.

manu

• Apr 7th, 2006

  To execute any program in Computer it needs memory area(RAM), Oracle allocates some memeory  for processing SQL statement. After execution this memory is released for future use. This one call Temporary work area.

Answer Question  Select Best Answer

Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

sendhur

• Mar 15th, 2007

The data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space.

Priya

• Sep 25th, 2006

Actually we can alter the size of the datafile by using the below syntaxSyntax :ALTER DATABASE DATAFILE RESIZE ;

Answer Question  Select Best Answer

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

Mohammed Abdul Afroze

• Oct 16th, 2007

Uses of a Controlfile:1.It is used to identify the names and locations of datafiles,redologfiles.2.Redo History is recorded during log switches.3.Checkpoint information is recorded at ckpts are m...

Lalit Vasuja

• Jan 4th, 2006

Control file contain the physical structure of database.it also contain the current log sequence number.when database mount ->open then oracle server check the consistency of the database through the control fie.

Answer Question  Select Best Answer

Yes.

mayur

• Dec 24th, 2015

No, at a time only one tablespace as default can be allocate to any user. If we want to store objects of one user to multiple tablespace then assign that tablespaces as a default tablespace for user at a time

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Yes objects of the same schema can reside in different tablepaces. Becuase when we create any schema (user) we can assign many tablespaces to one shcema so objects (eg. tables) will create in different tablespaces.

Answer Question  Select Best Answer

The related columns of the tables in a cluster is called the Cluster Key.

Dheemathi

• Mar 4th, 2019

Cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common. Oracle database stores together all the rows from all the tables that share the same cluster key.

pradeep

• May 5th, 2015

The related columns of the table in the cluster are called the cluster key

Answer Question  Select Best Answer

Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

Ravikumar

• Oct 18th, 2011

Database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Oct 14th, 2011

Private database link is created by a user in his schema. While creating the link, the keyword GLOBAL is not used. The syntax for creation is CREATE DATABASE LINK myPrivateDBLink connect to identified by using ;
Private DB links can not be used by other schema's.

Answer Question  Select Best Answer

A materialized view is a replica of a target master from a singlepoint in time. The concept was first introduced with Oracle7 termed asSNAPSHOT. In Oracle release 7.1.6 snapshots were enhanced to enableDMLs along with a new terminology, updatable snapshots. With Oracle8.1.6 snapshots started to be used in data warehouse environments so anew terminology materialized view was introduced to address bothdistributed...

irfanyell

 Profile Answers by irfanyell Questions by irfanyell

• Apr 24th, 2008

Both are mirror copy of tables but in that main difference is in snapshot we cannot edit the data. in the case of materialized view we can edit the data.

pravin Karde

• Sep 25th, 2006

sir  i m a M.E. student & i developed a project on Materialized view selection & maintenance.sir for this i urgently need the architecture of Materialized view & its operation. sir pl. help me & send me if  possible.thanks waiting +vely.

Answer Question  Select Best Answer

From where does PMON gets the informance about failure? How is the user process terminited?

premk

 Profile Answers by premk Questions by premk

• Dec 23rd, 2009

When user process is terminated abruptly due to power cut or any other factors then oracle database instance goes down then PMON mandatory background process is activated i.e it will then writes the c...

aabishkar

 Profile Answers by aabishkar Questions by aabishkar

• Sep 28th, 2009

When a user process fails or when it is killed, it then cleans up the cache and frees resources that the process used. PMON checks server processes and restarts them if they have failed.

Answer Question  Select Best Answer

What is the use of archive log file? How will you apply archive log file? How does archive log file helps to make backup consistent?

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A Archive log file is used to archive the filled redo log files. and used in recovery.

It is used in recovery but not in instance recovery.
Rest it is used to make database consistent after recovery by matching header of data file and control file checkpoint information.

rsona

 Profile Answers by rsona Questions by rsona

• Mar 2nd, 2011

Hello Ganesh,Q : What is the use of archive log file? A : It is used for Point In Time Database Instance Recovery.     Q : How will you apply archive log file? A : Archive Log need...

Answer Question  Select Best Answer

Harshad Khuspe

• Feb 26th, 2015

Virtual Tables are contains information about the base tables in oracle. Like V$database is virtual table which provide information of database name, open mode etc. or v$log will provide redo log members etc.

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Either virtual table is a temporary table or v$ or Xv$ views

Answer Question  Select Best Answer