Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Give the reasoning behind using an index.

Answers were Sorted based on User's Feedback



Give the reasoning behind using an index...

Answer / mathavan

Indexes are used for faster access of required data in a
large table.

Is This Answer Correct ?    7 Yes 1 No

Give the reasoning behind using an index...

Answer / rajesh naidu

INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB Administration Interview Questions

wat is global index and local indes

1 Answers   Oracle,


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  


what is asm?

0 Answers   Oracle,


any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,


Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  


Explain the difference between a data block, an extent and a segment.

2 Answers  


how to restore files with rman?

0 Answers  


how can you process messages in order asynchronously?

0 Answers   Oracle,


why do we give pctfree and pctused in create table statement?

1 Answers   CTS,


Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  


Name three advisory statistics you can collect.

1 Answers  


What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,


Categories