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 |
How the size of the table space can be increased?
select Nth highest salary by using rownum
4 Answers Ford, TCS, Tech Mahindra,
What are procedures in dbms?
What are records and fields in a database?
What are different cursor types in dbms?
Why is it better to use an Integrity Constraint to validate data ?
What are the types of database?
What is bcnf?
Explain the concepts of a primary key and foreign key.
Is it good to store image in database?
Describe the four types of indexes.
Explain how RDBMS software deals with deadlocks.
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)