What are indexes ? What are the advantages ? (Phone Screen)
Answer / ankit parikh
A database index is a data structure that improves the speed
of operations in a table.
Refer wiki: http://en.wikipedia.org/wiki/Index_(database).
One of the easiest sources to learn !
| Is This Answer Correct ? | 12 Yes | 1 No |
What are the ACID Properties in a Database and Why are They Important?
What are the six database objects?
What is ordbms with example?
what are the two integrity rules used in DBMS?
What is big data database?
Give us a non-computer example of preemptive and non-preemptive scheduling?
Define data, entity, domain and referential integrity?
What does rdbms stand for?
Write a query to create a duplicate table with and without data present?
What is an image database?
How does a database partition work?
Explain the main control blocks available in ims db?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)