Answer Posted / 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 |
Post New Answer View All Answers
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you communicate with operating system files from oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What happens on checkpoint? : sql server DBA
how can you schedule a job in database?
What are the steps you will take to improve performance of a poor performing query?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the default fill factor value? : sql server DBA
