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
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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is transparent data encryption? : sql server DBA
internal architecture
How can you control the amount of free space in your index pages? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
how can you initialize log miner?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you connect from 10g user to 11g user??
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what are the types of connection load-balancing?
how can you schedule a job in database?
You create a private database link and upon
connection, fails with: ORA-2085: connects to