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 |
Can we attach the same List of Values to different fields in Design time ?
Which database is best for storing images?
What are the advantages of manual database?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What is advantage of dbms?
What is the best database management system?
What is the first step in creating a database?
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.
does pl/sql support “overloading”? Explain
What is file manager?
What is database development process?
Do models have limitations?
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)