Give the reasoning behind using an index.

Question Posted / guest

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

More DB Administration Interview Questions

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

From the database level, how can you tell under which time zone a database is operating?

I lost one datafile i dont have backup how can you recover that???

how can you schedule a job in database?

What is the default fill factor value? : sql server DBA

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

What are statistics, under what circumstances they go out of date, how do you update them?

how do see how much space is used and free in a tablespace

by issuing "alter tablespace begin backup;" what happens to tablespace?

why we use cursors

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

What is transparent data encryption? : sql server DBA

For more DB Administration Interview Questions Click Here