onkar

• Sep 28th, 2005

exceptions can be handled in various ways in the stored procedures. Method (1) could be using EXCEPTION block in the procedure within which use WHEN <exceptionname> THEN. Method (2) could be dec...

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

it aviods fragmentation.

Answer Question  Select Best Answer

Lalit Chhimwal

• Aug 6th, 2006

buffer busy wait is the condition in which oracle server has to wait to access the segment header block for the table on which concurrent insert or delete operation r to be done.the segment header blo...

Answer Question  Select Best Answer

RAM

• Jun 20th, 2012

- - - - -
| | | | |
| | | | +----- Day of week (0-6)
| | | +------- Month (1 - 12)
| | +--------- Day of month (1 - 31)
| +----------- Hour (0 - 23)
+------------- Min (0 - 59)

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

FTS means the oracle server reads all the records from the concerned table. And it all depends on the size of the table/ partitioned table. What you say if a table consists of 10 million of records. so we musr avoid FTS. And  after all Oracle is build for searching.

Answer Question  Select Best Answer

Mohammed Mushtaq Momen

• Jul 23rd, 2006

Lookup tables are like constraints which hold a value.  The content in the lookup tables dosen't change often, hence refered as lookup (reference). Example : Countries table Countries are not add...

ed Di

• Apr 18th, 2006

They're all lookup tables.  After you load a table what's left to do but "Look up" the information at a later time. It's what database is all about; storing information for later retrieval.You pr...

Answer Question  Select Best Answer

Looking for a detailed answer if possible

aw_zahid

 Profile Answers by aw_zahid Questions by aw_zahid

• Nov 18th, 2008

A many-to-many relationship is usually resolved by making a tertiary (third intermediate) table where PKs of both the related tables are recoreded as FKs.Example: A student can take many classes and a...

Answer Question  Select Best Answer

kodaliprakash

 Profile Answers by kodaliprakash Questions by kodaliprakash

• Sep 7th, 2007

DSS is desicion support system. This is mainly useful for tking appropriate decisions based on existing data. All the data is already available in the DB. And we have to get reports according to the n...

Answer Question  Select Best Answer

What is a waterfall testing?

qaisar khan umraj

• Aug 12th, 2013

In waterfall we each step check 1st and last time means only one time we checking never take back checking never
we can repeat any previous steps

Answer Question  Select Best Answer

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 17th, 2008

Alter table add constraint primary key ()DEFERRABLE initially immediate enable novalidate

Answer Question  Select Best Answer

saurabh.nigam27

 Profile Answers by saurabh.nigam27 Questions by saurabh.nigam27

• Sep 16th, 2009

Due to DML commands, HWM will increase, which means for a query till the HWM all the blocks will be read whether blocks contain data or not (due to delete), because of this performance will go down.

Answer Question  Select Best Answer

Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS? Write your answer according to the requirements of Oracle 9i or 10g Enterprise database system.

vdamodharan

 Profile Answers by vdamodharan Questions by vdamodharan

• Jan 20th, 2010

That depends on what role you are playing in the DBA team.  If you are a operation DBA, then all you need to know to create a database are:  Initial sizing, redo, archive log size.  The...

Answer Question  Select Best Answer

azam.irshad

 Profile Answers by azam.irshad Questions by azam.irshad

• Jan 2nd, 2008

A process that runs on each of the nodes. It functions as the executor of jobs and events sent by the console by way of the mangement server. High availability is ensured since the agent can function regardless of the status of the cosole or network connections

Answer Question  Select Best Answer

azam.irshad

 Profile Answers by azam.irshad Questions by azam.irshad

• Jan 2nd, 2008

Sets of free lists available for use by one or more instances.When data is frequently inserted into a table from multiple nodes and the table is not partitioned, use free list groups to avoid performa...

Answer Question  Select Best Answer

what are the necessary steps to be take when server gets down? How can we increase size of a database?

subha gunasekaran

 Profile Answers by subha gunasekaran Questions by subha gunasekaran

• Jun 5th, 2008

1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring u...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

You can make use of VSIZE function to get the number of bytes in the internal representation of individual field. However this cannot be applied on fields that has BLOB data type and in such case you have to use dbms_lob.getlength function on BLOB data type field.

Answer Question  Select Best Answer

How will you check the database status from os level in a unix env ?consider that some of the instances are in mount state; hence checking the pmon os process will be vain..? Need a unix os command to check if the databases are up and running

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

• Mar 21st, 2010

Use the command $ps -ef | grep ora_

Answer Question  Select Best Answer

.

raja_wipro

 Profile Answers by raja_wipro Questions by raja_wipro

• Dec 2nd, 2008

In Oracle 10G we do not have Bitmap Index . Bitmap index  is available only in Oracle9i Enterprise Edition

Answer Question  Select Best Answer

What is High Water Mark in Oracle?

DPsireesha

 Profile Answers by DPsireesha Questions by DPsireesha

• Feb 24th, 2009

The High Watermark is the maximum fill-grade a table has ever reached. The blocks above high water mark are empty blocks.Initially when you create a table the high water mark is the first block. When ...

Answer Question  Select Best Answer

What will happen in database if your like hard disk crashes & what will be your next step to recover that database?

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

• Mar 21st, 2010

If your Harddisk gets crashed then If your Database is in Archive Log Mode, you should recover your database by applying all Archives or by restoring the latest backup.

Answer Question  Select Best Answer