Give the reasoning behind using an index.

Question Posted / guest

2 Answers
8705 Views
I also Faced
E-Mail Answers

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

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers

how will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

What are the different types of indexes available in sql server? : sql server DBA

0 Answers

the process of adding a cpu in sql server is called..?

2 Answers TCS,

Give two examples of how you might determine the structure of the table DEPT.

2 Answers

1)how to Take Backup in sql server 2005 from Flash Drive