Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

Give the reasoning behind using an index.

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

Faster access to data blocks in a table.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
Compare and contrast TRUNCATE and DELETE for a table.Give the two types of tables involved in producing a star schema and the type of data they hold.