An  index  is a database structure used by the server to have direct access of a row in a table. An  index  is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the create index command.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

An index is a database structure used by the server to quickly find a row in a table.In a relational database the physical location of row is irrelevent-unless, of course, the database needs to find i...

Answer Question  Select Best Answer

ganesha23

 Profile Answers by ganesha23 Questions by ganesha23

• Dec 16th, 2009

Parse, fetch and execue.

Vishal

• Sep 18th, 2007

1. Parse:  a. Search for identical statementb. Check syntax, object names, and privilegesc.  Lock objects  used during parsed. Create and store execution plan2. Execute: Process the Statement3. Fetch: Return rows to User Process

Answer Question  Select Best Answer

You can do it at the OS level by deleting all the files of the database. The files to be deleted can be found using: 1) select * from dba_data_files; 2) select * from v$logfile; 3) select * from v$controlfile; 4) archive log list 5) initSID.ora 6) In addition you can clean the UDUMP, BDUMP, scripts etc Clean up the listener.ora and the tnsnames.ora. make sure that the oratab entry is also removed. 

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

Start the database with startup mount restrictthen drop the database using drop database command.

mahender.komat

 Profile Answers by mahender.komat Questions by mahender.komat

• Aug 5th, 2009

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT MOUNT;DROP DATABASE;

Answer Question  Select Best Answer

You can query dba_data_files and dba_temp_files

prasant singh

• Oct 3rd, 2017

Can you explain why using bytes/1024/1024/1024

gvishalsoft

 Profile Answers by gvishalsoft Questions by gvishalsoft

• Apr 28th, 2009

Select substr(to_char(sum(bytes)/1024/1024, '999,999,999.99'), 1, 15) "TOTALMB", substr(to_char(sum(bytes)/1024/1024/1024, '999,999.99'), 1, 11) "TOTALGB" from dba_data_files;

Answer Question  Select Best Answer

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 29th, 2008

Characteristics of a Data File : - A Data file can be associated with only one tablespace. - Once created, a datafile can be increased or decreased in size with RESIZE command. Example: ALTER da...

alex.v

 Profile Answers by alex.v Questions by alex.v

• Jul 11th, 2008

datafiles can be resized to a lower size also, but till the used space....

Answer Question  Select Best Answer

 The set of objects owned by user account is called the schema.

Sriniv@s..

• Jun 20th, 2012

Schema is a set of objects own by a Particular user..

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

Schema is collection of database object.

Answer Question  Select Best Answer

rohit

• Jul 28th, 2011

We use bitmap indexes on tables with fairly static low cardinality values (a small number of different values which do not change very often).
It is used in long size table containing 'n' no of records with duplicate records.

RASH

• Mar 25th, 2007

The explanations are above, read further in the concepts manual.I would advice caution when using these, as they can cause severe conention when used in Update/Insert Intensive / OLTP environs.This is...

Answer Question  Select Best Answer

jayesh gaikar

• Nov 6th, 2018

LMT(Locally Managed Tablespace) :In LMT Extents are managed at the data file level.
DMT(Dictionary Managed Tabalespace) :Extent management in DMT is maintained and carried out at the data dictionary level.

Surya

• Jun 15th, 2017

When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks, called an extent, is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary, or in the tablespace itself

Answer Question  Select Best Answer

mahmed100

 Profile Answers by mahmed100 Questions by mahmed100

• May 16th, 2010

Take a Backup

vishnusivathej

 Profile Answers by vishnusivathej Questions by vishnusivathej

• Jul 21st, 2008

Backup the entire database...

Answer Question  Select Best Answer

A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota 200 M Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?

bassem_farouk

 Profile Answers by bassem_farouk Questions by bassem_farouk

• Sep 17th, 2008

Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored. SQL> create user test identified by test1; User created. SQL> grant connect, reso...

vishnusivathej

 Profile Answers by vishnusivathej Questions by vishnusivathej

• Jul 21st, 2008

There will be no such thing as default size for a tablespace u have to assign it when it is being created.. and more over by default u can have 100 datafiles in a database which is the default value used during the database creation process u can also change this value..

Answer Question  Select Best Answer

Can you perform DML operations when the standby database is in read only in Standby Database?

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

In a nutshell, One can do SELECTS only on a Physical/Logical Standby database. The basic principle behind Oracle Standby database is to provide protection against media failures. So no DMLs are allowe...

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Jul 7th, 2009

I agree with omelkoz, But I need to add a small point here. Specifying STANDBY is to to prevent all users other than SYS from making DML and DDL changes to any table or sequence being maintained through SQL apply operations. Not everybody can execute statements on a standby. :)

Answer Question  Select Best Answer

What is dump destination? What are bdump, cdump and udump? Explain in detail.

anurag2202

 Profile Answers by anurag2202 Questions by anurag2202

• Oct 30th, 2009

The dump destination is: Oracle_home/admin/<SID>The UDUMP specifies user dump directory where all the user related information is stored in the form of trace file.The BDUMP specifies background ...

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Jul 6th, 2009

UDUMP is specifying the user dump directory where all user error logs (trace files) will be placed.BDUMP is specifying the background dump directory where all database error logs (trace files) will be...

Answer Question  Select Best Answer

What is PCT Free and PCT Used?What is PCT increase parameter in segment?What is growth factor?

mkguduru

 Profile Answers by mkguduru Questions by mkguduru

• Jan 21st, 2010

PCTFREE: Percentage of blocks to be reserved for future updates.After this parameter is met the block is considered to be full and it is not available to insert new rows. PCTUSED: It allows the block to reconsidered for the insertion of new rows.

refakat

 Profile Answers by refakat Questions by refakat

• Aug 12th, 2009

This is the parameter which specify in percent? that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less ...

Answer Question  Select Best Answer

A user issues the below query,
1. Select * from table1 lock table

At the same time DBA is trying to modify this table table1 using alter command, will he able to do that or not?

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

DDL lock are exclusive locks. It shared the data. Means anyone can select data from same table.

anil

• Mar 13th, 2012

There dba can break the lock given to table.
but in real time, no dba has the right to break the lock given by the user

Answer Question  Select Best Answer

Neeraj Kumar Singh

• Feb 17th, 2012

Code
 

Arunkumar

• Dec 28th, 2011

Code
 

Answer Question  Select Best Answer

alvinstars

 Profile Answers by alvinstars Questions by alvinstars

• Sep 7th, 2010

The database automatically maintains and uses indexes after they are created. The database also automatically reflects changes to data, such as adding, updating, and deleting rows, in all relevant indexes with no additional actions required by users.

Prashidha

 Profile Answers by Prashidha Questions by Prashidha

• Apr 8th, 2009

We can update the index by rebuilding it.Alter index indexname rebuilt

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Jan 30th, 2010

Four types of segments are found in oracle database:1- Data segment2- Index segment3- Temporary segment4- Rollback segment

kpeer40

 Profile Answers by kpeer40 Questions by kpeer40

• Jan 28th, 2010

Table segmentsIndex segmentsUndo segmentsTemp segmentsRollback segments

Answer Question  Select Best Answer

santosh Panigrahi

 Profile Answers by santosh Panigrahi Questions by santosh Panigrahi

• Jul 12th, 2009

The 2 basic feature of Oracle 10g makes database Maximum protection and Zero downtime (1) Undo Retention Guarantee.(2) Stand by server compatibility.

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

Maximum Protection mode - guarantees Zero data loss.  But it can not guarantee Zero down time.Any transaction happening in Primary Database has to be propagated and commited in Standby Datab...

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 28th, 2007

An Extent is a set of contignous data blocks obtain in a single allocation and used to store specific type of information.

Yoh

• Jul 30th, 2006

Extends are a collection of data blocks

Answer Question  Select Best Answer

csanthoshreddy

 Profile Answers by csanthoshreddy Questions by csanthoshreddy

• Mar 6th, 2012

Datafile is the physical storage location of the database.tablespace is logical.for creation of tablespace one or more datafiles needed.we can define the datafile location with the following parameter

db_create_file_dest

Dharma Kotha

 Profile Answers by Dharma Kotha Questions by Dharma Kotha

• Oct 10th, 2011

Datafiles are physical data location of oracle architecture. Table space contains no.of datafiles.

Answer Question  Select Best Answer