Give the reasoning behind using an index.
Answers were Sorted based on User's Feedback
Answer / mathavan
Indexes are used for faster access of required data in a
large table.
| Is This Answer Correct ? | 7 Yes | 1 No |
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 |
what is the purpose of catlaog in oracle rman?
Explain the difference between a data block, an extent and a segment.
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
what do you understand by fine-grained auditing?
What are the different types of indexes available in sql server? : sql server DBA
What are the commands used in dcl? : sql server DBA
what is logical system in sap basis
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Compare and contrast TRUNCATE and DELETE for a table.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Oracle (3253)
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)